P2P Cycle

- Requisition Creation

1- Requisition_headers_all

2- Requisition_lines_all   (Linking field is Requisition_header_id)

select * from po_requisition_headers_all where segment1=110;  -- segment1= requisition_no

- Purchase Order Creation

1- PO_headers_all   (segment1 = PO#)

2- PO_Lines_all (Linking field is po_header_id)

select * from po_line_all where po_header_id = (select po_header_id from po_headers_all where segment1=450);

3- PO_Line_locations_all  (Linking field is po_header_id)
(Shipment level details)

select * from po_line_locations_all where po_header_id = (select po_header_id from po_headers_all where segment1=110);


4- PO_distributions_all
(All distribution details)

select * from po_distributions_all where po_header_id = (select po_header_id from po_headers_all where segment1=110);

- Receivings

1- Rcv_Shipment_headers
select * from rcv_shipment_headers where receipt_num=1245;

2- Rcv_shipment_lines (Linking field is shipment_header_id)
select * from rcv_shipment_lines where shipment_header_id in (select shipment_header_id from rcv_shipment_headers where receipt_num=1245 and shipment_header_id=5656);


3- Rcv_transactions
select * from rcv_transactions where po_header_id in (select po_header_id from po_headers_all where segment1=450);


- Invoice Creation

1- Ap_Invoices_all

2- Ap_invoice_distributions_all (Linking field is invoice_id)
select * from ap_invoice_distributions_all where invoice_id in (select invoice_id from ap_invoices_all where invoice_num='1234');


- Payments

1- AP_Invoice_Payments_all (Master key invoice_id)

2- AP_Payment_Schedules_all
select * from ap_payment_schedules_all where incoie_id in (select invoice_id from ap_invoices_all where invoice_num='1234');

3- AP_Payment_Distributions_all
Select * from Ap_Payment_Distributions_all where invoice_payment_id in (select invoice_payment_id from ap_invoice_payments_all where invoice_id in (select invoice_id from ap_invoices_all where invoice_num='1234'));


4- AP_Checks_all
select * from Ap_Checks_all where check_id=12344444;


- Reconciling with cash management

1- CE_Statement_Headers_all
select statement_header_id from ce_statement_headers_all where statement_header_id=456456;

2- CE_Statement_lines
select * from ce_statement_lines where statement_header_id in  (select statement_header_id from ce_statement_headers_all where statement_header_id=456456);

*****************************************************************************
A GOOD ILLUSTRATION
*****************************************************************************

https://govoracleapps.wordpress.com/category/procure-to-payp2p/

http://www.slideshare.net/venugopalram/p2-p-and-o2c