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, supplier_number, supplier_name, po_number,…
Read MoreOracle 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, quantity, unit_price price, need_by_date, shipment_line_num, shipment_qty, shipment_needby_date,…
Read More 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, ‘INTERCOMPANY PRICING’ pricing, item.segment1 item,…
Read MoreOracle EBS – PO Report with Bursting https://doyensys.com/wp-content/uploads/2024/01/oracle-ebs-po-report-with-bursting.doc
Read MoreThis 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…
Read More————————————————————————————– Oracle EBS – Query to get MultiOrg Info ————————————————————————————– ————– Execute the below query into EBS database.—————————————- SELECT mp.organization_code org_code, org.organization_id org_id, org.NAME org_name, hl.location_id, hl.location_code, hl.address_line_1, hl.address_line_2, hl.address_line_3,…
Read MoreOrder 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, rcta.trx_number invoice_number, rcta.status_trx invoice_status, rcta.invoice_currency_code invoice_currency, rctla.line_number, msi.segment1 item_number, rctla.description, rctla.extended_amount line_amt, arp.amount_due_original, arp.amount_due_remaining,…
Read More