P2P Tables with joins

P2P Cycle technical flow step by step with joins in simple way


    REQUISITION TABLES
       
SELECT * FROM  PO_REQUISITION_HEADERS_ALL
WHERE segment1=1100004-- requisition_header_id=61

SELECT * FROM  PO_REQUISITION_LINES_ALL
WHERE REQUISITION_HEADER_ID=61  --REQUISITION_LINE_ID=101,requisition_header_id=61

SELECT * FROM  PO_REQUISITION_LINES_ALL
WHERE REQUISITION_LINE_ID=101    --REQUISITION_HEADER_ID=61

SELECT * FROM  PO_REQ_DISTRIBUTIONS_ALL
WHERE REQUISITION_LINE_ID=101  --distributon_id=94

                PO TABLES

SELECT * FROM  PO_DISTRIBUTIONS_ALL
WHERE PO_HEADER_ID=92 -- --PO_HEADER_ID=92, PO_LINE_ID=373 , po_distribution_id=80

SELECT * FROM  PO_LINES_ALL
WHERE PO_HEADER_ID=92  --PO_HEADER_ID=92, PO_LINE_ID=373

SELECT * FROM  PO_HEADERS_ALL
WHERE SEGMENT1=1100061 --po_header_id=92

          RECEIPTS TABLES

SELECT * FROM  RCV_TRANSACTIONS
WHERE PO_DISTRIBUTION_ID=80 -- shipment_header_id=3025 , PO_HEADER_ID=92, PO_LINE_ID=373

SELECT * FROM  RCV_SHIPMENT_HEADERS
WHERE SHIPMENT_HEADER_ID=3025   --SHIPMENT_LINE_ID=3028

SELECT * FROM  RCV_SHIPMENT_LINES
WHERE SHIPMENT_HEADER_ID=3025    --SHIPMENT_LINE_ID=3028, po_header_id=92, po_line_id=373,po_distribution_id=80

                ACCOUNT PAYABLES TABLES

SELECT * FROM  AP_INVOICE_DISTRIBUTIONS_ALL
WHERE PO_DISTRIBUTION_ID =3823   --REQ_DISTRIBUTION_ID=  ,ACCOUNTING_EVENT_ID=926551,926552  ,INVOICE_ID=65057

SELECT * FROM  AP_INVOICE_LINES_ALL
WHERE INVOICE_ID=65057

SELECT * FROM  AP_INVOICES_ALL
WHERE INVOICE_ID=65057

                XLA TABLES 

SELECT * FROM  XLA.XLA_TRANSACTION_ENTITIES
WHERE SOURCE_ID_INT_1='65057'    --ENTITY_ID=1000248

SELECT * FROM  XLA.XLA_AE_HEADERS
WHERE ENTITY_ID=1000248  -- ae_header_id=1091228

SELECT * FROM  XLA.XLA_AE_LINES
WHERE AE_HEADER_ID=1091228    --gl_sl_link_id in(2046124,2046123)

                    GL TABLES

SELECT * FROM  GL_IMPORT_REFERENCES
WHERE GL_SL_LINK_ID IN(2046124,2046123)   --JE_HEADER_ID=1393995 , JE_BATCH_ID=1126487

SELECT * FROM  GL_JE_HEADERS
WHERE JE_HEADER_ID=1393995   --je_header_id=1393995

SELECT * FROM  GL_JE_LINES
WHERE JE_HEADER_ID=1393995   --GL_SL_LINK_ID  in(2046123,2046124)