CONTRACT PURCHASING

SELECT  PHA.SEGMENT1 PONUM,
        PHA.TYPE_LOOKUP_CODE,
        PHA1.SEGMENT1  STDPOUM,
        PHA1.TYPE_LOOKUP_CODE,
        MSIB.SEGMENT1 ITEM,
        APS.VENDOR_NAME,
        APSSA.VENDOR_SITE_CODE,
        PHA.AMOUNT_LIMIT,
        HL1.LOCATION_CODE,
        HL2.LOCATION_CODE,
        HOU.NAME ORGNAME,
        PLA.QUANTITY,
        PLA.UNIT_PRICE,
        PLLA.NEED_BY_DATE,
        PDA.CODE_COMBINATION_ID,
        GCCK.CONCATENATED_SEGMENTS,
        RSH.RECEIPT_NUM,
        RSL.DESTINATION_TYPE_CODE,
        RT.DESTINATION_TYPE_CODE,
        AIA.INVOICE_NUM,
        AIA.INVOICE_AMOUNT,
        AILA.LINE_TYPE_LOOKUP_CODE,
        AILA.LINE_NUMBER,
        AIDA.DISTRIBUTION_LINE_NUMBER,
        AIDA.AMOUNT,
        AIPA.INVOICE_PAYMENT_ID,
        AIPA.AMOUNT,
        AIPA.CHECK_ID,
        ACA.BANK_ACCOUNT_NAME,
        ACA.BANK_ACCOUNT_NUM
FROM    PO_HEADERS_ALL                 PHA,
        PO_HEADERS_ALL                 PHA1,
        PO_LINES_ALL                   PLA,
        PO_LINE_LOCATIONS_ALL          PLLA,
        PO_DISTRIBUTIONS_ALL           PDA,
        GL_CODE_COMBINATIONS_KFV       GCCK,
        MTL_SYSTEM_ITEMS_B             MSIB,
        AP_SUPPLIERS                   APS,
        AP_SUPPLIER_SITES_ALL          APSSA,
        HR_OPERATING_UNITS             HOU,
        RCV_SHIPMENT_HEADERS           RSH,
        RCV_SHIPMENT_LINES             RSL,
        RCV_TRANSACTIONS               RT,
        AP_INVOICES_ALL                AIA,
        AP_INVOICE_LINES_ALL           AILA,
        AP_INVOICE_DISTRIBUTIONS_ALL   AIDA,
        AP_INVOICE_PAYMENTS_ALL        AIPA,
        AP_CHECKS_ALL                  ACA,
        HR_LOCATIONS                   HL1,
        HR_LOCATIONS                   HL2
WHERE   PHA.SEGMENT1='6050'
AND     RT.DESTINATION_TYPE_CODE='INVENTORY'
AND     PHA1.PO_HEADER_ID=PLA.PO_HEADER_ID
AND     PLA.CONTRACT_ID=PHA.PO_HEADER_ID
AND     PLA.PO_LINE_ID=PLLA.PO_LINE_ID
AND     PLLA.LINE_LOCATION_ID=PDA.LINE_LOCATION_ID
AND     PDA.CODE_COMBINATION_ID=GCCK.CODE_COMBINATION_ID
AND     MSIB.INVENTORY_ITEM_ID=PLA.ITEM_ID
AND     MSIB.ORGANIZATION_ID=PHA.ORG_ID
AND     PHA.ORG_ID=HOU.ORGANIZATION_ID
AND     RSH.SHIPMENT_HEADER_ID=RSL.SHIPMENT_HEADER_ID
AND     RSL.SHIPMENT_LINE_ID=RT.SHIPMENT_LINE_ID
AND     RSL.PO_LINE_LOCATION_ID=PLLA.LINE_LOCATION_ID
AND     AIA.INVOICE_ID=AILA.INVOICE_ID
AND     AILA.LINE_NUMBER=AIDA.INVOICE_LINE_NUMBER
AND     AIDA.INVOICE_ID=AIA.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
AND     HL1.LOCATION_ID=PHA.SHIP_TO_LOCATION_ID
AND     HL2.LOCATION_ID=PHA.BILL_TO_LOCATION_ID
AND     APS.VENDOR_ID=PHA.VENDOR_ID
AND     APSSA.VENDOR_SITE_ID=PHA.VENDOR_SITE_ID



SELECT * FROM PO_HEADERS_ALL WHERE SEGMENT1='6050'

SELECT * FROM PO_HEADERS_ALL  WHERE SEGMENT1='6051'

SELECT * FROM PO_LINES_ALL WHERE CONTRACT_ID=110410


SELECT * FROM PO_HEADERS_ALL WHERE SEGMENT1='6050'

SELECT * FROM PO_HEADERS_ALL WHERE SEGMENT1='6051'

SELECT  PLA.CONTRACT_ID
FROM    PO_LINES_ALL    PLA,
        PO_HEADERS_ALL  PHA
WHERE   CONTRACT_ID=110410
AND     PHA.PO_HEADER_ID=PLA.CONTRACT_ID