Procure to Pay(P2P) Query

Requisition:

select * from po_requisition_headers_all where segment1='14895';

select authorization_status from   po_requisition_headers_all where segment1='14895';

go the program

select * from po_requisition_lines_all where requisition_header_id=184097

select * from po_req_distributions_all where requisition_line_id=211718

select authorization_status from   po_requisition_headers_all where segment1='14895';


Purchase Order:Auto Create

select * from po_headers_all where segment1='6850';

select authorization_status from po_headers_all where segment1='6850';

go the program

select * from po_lines_all where po_header_id=113543

select * from po_line_locations_all where po_line_id=176377

select * from po_distributions_all where line_location_id=267947

select authorization_status from po_headers_all where segment1='6850';

Receiving:Receipts


select * from rcv_shipment_headers where receipt_num='8785' and trunc(creation_date)=trunc(sysdate)

select * from rcv_shipment_lines where shipment_header_id=4941927

select * from rcv_transactions where shipment_line_id=4937487

Switch Responsibility:Payables Vision Operations:Oracle Payables:Entry:Invoices

select * from ap_invoices_all where invoice_num='ERS-8785-166226';

select * from ap_invoice_lines_all where invoice_id=214137

select * from ap_invoice_distributions_all where invoice_id='214137'

select accounting_event_id from ap_invoice_distributions_all where invoice_id='214137'

select * from ap_invoice_payments_all where invoice_id=214137

select * from ap_payment_schedules_all where invoice_id=214137

select * from ap_checks_all order by creation_date desc

select * from ap_checks_all where check_number=1017

General Ledger:

select * from gl_je_headers where name='Jun-11 Payments USD' and description='Journal Import

5834645:';

select * from gl_je_headers where description like '%5834645%' and ledger_id=1;

select * from gl_je_lines where je_header_id=4802230;

select * from gl_import_references where je_header_id=4802230

select * from gl_je_batches where je_batch_id=3048259

Sub Ledger:

select * from xla_events where entity_id=3340714

select * from xla_ae_headers where event_id=3408207

select * from xla_ae_lines where ae_header_id=5064034