P2P QUERY

SELECT  PRHA.SEGMENT1 REQNUM
       ,PHA.SEGMENT1  PONUM
       ,HL.LOCATION_CODE SHIPTO
       ,HL1.LOCATION_CODE BILTO
       ,APS.VENDOR_NAME
       ,APSSA.VENDOR_SITE_CODE
       ,APSC.FIRST_NAME
       ,APSC.LAST_NAME
       ,RT.TRANSACTION_TYPE
       ,RSH.RECEIPT_NUM PORECEIPTNUM
       ,AIA.INVOICE_NUM
      ---,XTE.ENTITY_CODE
FROM    PO_REQUISITION_HEADERS_ALL  PRHA
       ,PO_REQUISITION_LINES_ALL    PRLA
       ,PO_REQ_DISTRIBUTIONS_ALL    PRDA
       ,PO_DISTRIBUTIONS_ALL        PDA
       ,PO_LINE_LOCATIONS_ALL       PLLA
       ,PO_LINES_ALL                PLA
       ,PO_HEADERS_ALL              PHA
       ,HR_LOCATIONS                HL
       ,HR_LOCATIONS                HL1
       ,MTL_SYSTEM_ITEMS_B          MSIB
       ,AP_SUPPLIERS                APS
       ,AP_SUPPLIER_SITES_ALL       APSSA
       ,AP_SUPPLIER_CONTACTS        APSC
       ,RCV_TRANSACTIONS            RT
       ,RCV_SHIPMENT_LINES          RSL
       ,RCV_SHIPMENT_HEADERS        RSH
       ,AP_INVOICE_DISTRIBUTIONS_ALL AIDA
       ,AP_INVOICE_LINES_ALL         AILA
       ,AP_INVOICES_ALL              AIA
       ,AP_INVOICE_PAYMENTS_ALL      AIPA
       ,AP_CHECKS_ALL                ACA
       ,XLA_AE_HEADERS               XAH
       ,XLA_AE_LINES                 XAL
       ,XLA_EVENTS                   XE
       ,XLA_TRANSACTION_ENTITIES     XTE
       ,XLA_DISTRIBUTION_LINKS       XDL
       ,GL_IMPORT_REFERENCES         GIR
       ,GL_JE_BATCHES                GJB
       ,GL_JE_HEADERS                GJH
       ,GL_JE_LINES                  GJL    
WHERE   PRHA.SEGMENT1='14200'
AND     PRHA.REQUISITION_HEADER_ID=PRLA.REQUISITION_HEADER_ID
AND     PRLA.REQUISITION_LINE_ID=PRDA.REQUISITION_LINE_ID
AND     PRDA.DISTRIBUTION_ID=PDA.REQ_DISTRIBUTION_ID
AND     PDA.LINE_LOCATION_ID=PLLA.LINE_LOCATION_ID
AND     PLLA.PO_LINE_ID=PLA.PO_LINE_ID
AND     PLA.PO_HEADER_ID=PHA.PO_HEADER_ID
AND     HL.LOCATION_ID=PHA.SHIP_TO_LOCATION_ID
AND     HL1.LOCATION_ID=PHA.BILL_TO_LOCATION_ID
AND     MSIB.INVENTORY_ITEM_ID=PLA.ITEM_ID
AND     PHA.ORG_ID=MSIB.ORGANIZATION_ID
AND     PHA.VENDOR_ID=APS.VENDOR_ID
AND     PHA.VENDOR_SITE_ID=APSSA.VENDOR_SITE_ID
AND     APS.VENDOR_ID=APSSA.VENDOR_ID
AND     PHA.VENDOR_CONTACT_ID=APSC.VENDOR_CONTACT_ID
AND     PHA.PO_HEADER_ID=RT.PO_HEADER_ID
--AND     PLLA.PO_LINE_ID=RSL.PO_LINE_ID
--AND     PHA.PO_HEADER_ID=RSL.PO_HEADER_ID
AND     RT.TRANSACTION_TYPE='DELIVER'
AND     RT.SHIPMENT_LINE_ID=RSL.SHIPMENT_LINE_ID
AND     RSL.SHIPMENT_HEADER_ID=RSH.SHIPMENT_HEADER_ID
AND     PDA.PO_DISTRIBUTION_ID=AIDA.PO_DISTRIBUTION_ID
AND     AIDA.INVOICE_LINE_NUMBER=AILA.LINE_NUMBER
AND     AIDA.INVOICE_ID=AILA.INVOICE_ID
AND     AILA.INVOICE_ID=AIA.INVOICE_ID
AND     AIA.INVOICE_ID=AIPA.INVOICE_ID
AND     AIPA.CHECK_ID=ACA.CHECK_ID
AND     ACA.CHECK_NUMBER=XTE.TRANSACTION_NUMBER
AND     AIPA.CHECK_ID=XTE.SOURCE_ID_INT_1
AND     AIA.ORG_ID=XTE.SECURITY_ID_INT_1
AND    XAH.AE_HEADER_ID=XAL.AE_HEADER_ID
AND    XAH.EVENT_ID=XE.EVENT_ID
AND    XE.ENTITY_ID=XTE.ENTITY_ID
AND    XAL.AE_LINE_NUM=AIDA.INVOICE_LINE_NUMBER
AND    XAL.AE_LINE_NUM=XDL.AE_LINE_NUM
AND    XDL.APPLIED_TO_DIST_ID_NUM_1=AIDA.INVOICE_DISTRIBUTION_ID
AND    GIR.REFERENCE_5=XTE.ENTITY_ID
AND    XTE.ENTITY_CODE='MANUAL'
AND    GIR.REFERENCE_6=TO_CHAR(XE.EVENT_ID)
AND    GIR.REFERENCE_7=TO_CHAR(XAH.AE_HEADER_ID)
AND    GIR.GL_SL_LINK_ID=XAL.GL_SL_LINK_ID
AND    GJB.JE_BATCH_ID=GIR.JE_BATCH_ID
AND    GJH.JE_BATCH_ID=GJB.JE_BATCH_ID
AND    GJH.JE_HEADER_ID=GIR.JE_HEADER_ID
AND    GJL.JE_HEADER_ID=GJH.JE_HEADER_ID
AND    GJL.JE_LINE_NUM=GIR.JE_LINE_NUM