p2p o2c

Pencial   66459  14313  6066  23732 10037665  1,060.00

SELECT  OOHA.ORDER_NUMBER,
        OOHA.FLOW_STATUS_CODE,
        OOHA.ORDER_CATEGORY_CODE,
        OOLA.ORDERED_ITEM,
        ODSS.LINE_ID,
        ODSS.DROP_SHIP_SOURCE_ID,
        QLH.NAME,
        PRHA.SEGMENT1 REQNUM,
        PHA.SEGMENT1 PONUM,
        RSH.RECEIPT_NUM ,
        AIA.INVOICE_ID,
        AIPA.AMOUNT ,
        ACA.CHECK_ID,
        ACA.BANK_ACCOUNT_NAME
FROM    OE_ORDER_HEADERS_ALL        OOHA,
        OE_ORDER_LINES_ALL          OOLA,
        OE_DROP_SHIP_SOURCES        ODSS,
        QP_LIST_HEADERS             QLH,
        PO_REQUISITION_HEADERS_ALL  PRHA,
        PO_REQUISITION_LINES_ALL    PRLA,
        PO_REQ_DISTRIBUTIONS_ALL    PRDA,
        PO_HEADERS_ALL              PHA,
        PO_LINES_ALL                PLA,
        PO_LINE_LOCATIONS_ALL       PLLA,
        PO_DISTRIBUTIONS_ALL        PDA,
        RCV_SHIPMENT_HEADERS        RSH,
        RCV_SHIPMENT_LINES          RSL,
        HZ_PARTIES                  HP,
        HZ_CUST_ACCOUNTS            HCA,
        HZ_CUST_SITE_USES_ALL       HCSUA,
        HZ_LOCATIONS                HL,
        HZ_PARTY_SITES              HPS,
        HZ_CUST_ACCT_SITES_ALL      HCASA,
        RA_CUSTOMER_TRX_ALL         RCTA ,
        AR_PAYMENT_SCHEDULES_ALL    APSA,
        AP_INVOICES_ALL             AIA,
        AP_INVOICE_LINES_ALL        AILA,
        AP_INVOICE_DISTRIBUTIONS_ALL  AIDA,
        AP_INVOICE_PAYMENTS_ALL     AIPA,
        AP_CHECKS_ALL               ACA
WHERE   OOHA.ORDER_NUMBER=66459
AND     OOHA.HEADER_ID=OOLA.HEADER_ID
AND     OOLA.HEADER_ID=ODSS.HEADER_ID
AND     OOHA.PRICE_LIST_ID=QLH.LIST_HEADER_ID
AND     PRHA.REQUISITION_HEADER_ID=PRLA.REQUISITION_HEADER_ID
AND     PRLA.REQUISITION_LINE_ID=PRDA.REQUISITION_LINE_ID
AND     PHA.PO_HEADER_ID=PLA.PO_HEADER_ID
AND     PLA.PO_LINE_ID=PLLA.PO_LINE_ID
AND     PLLA.LINE_LOCATION_ID=PDA.LINE_LOCATION_ID
AND     PRDA.DISTRIBUTION_ID=PDA.REQ_DISTRIBUTION_ID
AND     ODSS.PO_HEADER_ID=PHA.PO_HEADER_ID
AND     RSH.SHIPMENT_HEADER_ID=RSL.SHIPMENT_HEADER_ID
AND     PLLA.LINE_LOCATION_ID=RSL.PO_LINE_LOCATION_ID
AND     HP.PARTY_ID=HCA.PARTY_ID
AND     HCA.CUST_ACCOUNT_ID=OOHA.SOLD_TO_ORG_ID
AND     HCSUA.SITE_USE_ID=OOHA.SHIP_TO_ORG_ID
AND     HL.LOCATION_ID=HPS.LOCATION_ID
AND     HPS.PARTY_SITE_ID=HCASA.PARTY_SITE_ID
AND     HCSUA.CUST_ACCT_SITE_ID=HCASA.CUST_ACCT_SITE_ID
AND     TO_CHAR(OOHA.ORDER_NUMBER)=RCTA.INTERFACE_HEADER_ATTRIBUTE1
AND     RCTA.CUSTOMER_TRX_ID=APSA.CUSTOMER_TRX_ID
AND     AIA.INVOICE_ID=AILA.INVOICE_ID
AND     AILA.LINE_NUMBER=AIDA.INVOICE_LINE_NUMBER
AND     AIA.INVOICE_ID=AIDA.INVOICE_ID
AND     AIDA.PO_DISTRIBUTION_ID=PDA.PO_DISTRIBUTION_ID
AND     AIA.INVOICE_ID=AIPA.INVOICE_ID
AND     AIPA.CHECK_ID=ACA.CHECK_ID


SELECT * FROM OE_DROP_SHIP_SOURCES