Oracle EBS – Query to get Purchase Order Details approved based on Hierarchy Select * from ( SELECT TO_CHAR (SYSDATE, ‘DD-MON-YYYY HH:MI:SS’) rp_run_date, po.* FROM (SELECT ou, [...]

Oracle EBS – Query to get Open Purchase Order Details SELECT org_code, org, operating_unit, buyer, supplier, po_number, line_num line_number, item_code item, item_description description, [...]

 Execute the below query into EBS database. SELECT line, empty, pricing, item, from_date, TO_DATE, total, uom, attirubute, org FROM (SELECT ‘NL’ line, ” empty, [...]

Oracle EBS – PO Report with Bursting https://doyensys.com/blogs/wp-content/uploads/2024/01/oracle-ebs-po-report-with-bursting.doc

This Blog is used to automate PO Promise Date/Need By Date Based on Date Entered in PO Line level/Shipment level by using Form Personalization Please follow the steps as per documents attached [...]

[...]

Item Conversion

Service Contract Details Query

Order To Cash Script o2c   SELECT hp.party_name customer, hca.account_number, hp.party_number, ooh.order_number, ooh.flow_status_code order_status, rcta.trx_date invoice_date, [...]