BLANKET

 SELECT PHA.SEGMENT1,
        PHA.BLANKET_TOTAL_AMOUNT,
        PHA.AMOUNT_LIMIT,
        PLA.ITEM_DESCRIPTION,
        PDA.CODE_COMBINATION_ID,
        PLLA.NEED_BY_DATE,
        PLLA.PRICE_OVERRIDE,
        PLLA.QUANTITY,
        PRA.RELEASE_NUM,
        RSH.RECEIPT_NUM,
        AIA.INVOICE_NUM,
        AIA.INVOICE_AMOUNT,
        AILA.LINE_TYPE_LOOKUP_CODE,
        AILA.LINE_NUMBER,
        AIDA.DISTRIBUTION_LINE_NUMBER,
        AIDA.AMOUNT,
        AIPA.AMOUNT,
        AIPA.CHECK_ID,
        APC.BANK_ACCOUNT_NAME,
        APC.BANK_ACCOUNT_NUM
 FROM   PO_HEADERS_ALL  PHA,
        PO_LINES_ALL    PLA,
        PO_LINE_LOCATIONS_ALL PLLA,
        PO_DISTRIBUTIONS_ALL   PDA,
        PO_RELEASES_ALL        PRA,
        RCV_SHIPMENT_HEADERS   RSH,
        RCV_SHIPMENT_LINES     RSL,
        AP_INVOICES_ALL         AIA,
        AP_INVOICE_LINES_ALL   AILA,
        AP_INVOICE_DISTRIBUTIONS_ALL AIDA,
        AP_INVOICE_PAYMENTS_ALL  AIPA,
        AP_CHECKS_ALL            APC
 WHERE  PHA.SEGMENT1='6044'
 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    PLLA.PO_RELEASE_ID=PRA.PO_RELEASE_ID
 AND    RSH.SHIPMENT_HEADER_ID=RSL.SHIPMENT_HEADER_ID
 AND    PLLA.LINE_LOCATION_ID=RSL.PO_LINE_LOCATION_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    AIPA.INVOICE_ID=AIA.INVOICE_ID
 AND    AIPA.CHECK_ID=APC.CHECK_ID




SELECT * FROM PO_RELEASES_ALL


SELECT *  FROM PO_LINE_LOCATIONS_ALL