PO Matching Report

SELECT

      PHA.TYPE_LOOKUP_CODE,

      PHA.LAST_UPDATE_DATE,

      PHA.SEGMENT1,

      PHA.SUMMARY_FLAG,

      PHA.ENABLED_FLAG,

      PHA.APPROVED_FLAG,

      PLA.UNIT_MEAS_LOOKUP_CODE,      

      PLA.QUANTITY,

      PLA.UNIT_PRICE,

      PLA.LIST_PRICE_PER_UNIT,

      PLA.PRICE_TYPE_LOOKUP_CODE,

      PLL.RECEIPT_REQUIRED_FLAG,

      PLL.INSPECTION_REQUIRED_FLAG,decode

         (INSPECTION_REQUIRED_FLAG||RECEIPT_REQUIRED_FLAG,'NN','2-Way','NY','3-Way','YY','4-Way','Not Specified')   

                              Matching,       

      PLL.ENCUMBERED_FLAG,

      PDA.QUANTITY_ORDERED,      

      PDA.ACCRUAL_ACCOUNT_ID,

      PDA.VARIANCE_ACCOUNT_ID

 FROM

       PO_HEADERS_ALL PHA,

       PO_LINES_ALL PLA,

       PO_LINE_LOCATIONS_ALL PLL,

       PO_DISTRIBUTIONS_ALL PDA

 WHERE

        PDA.PO_HEADER_ID=PLL.PO_HEADER_ID

AND          

       PLL.PO_HEADER_ID=PLA.PO_HEADER_ID

AND

       PLA.PO_HEADER_ID=PDA.PO_HEADER_ID

AND        

     

       PLA.UNIT_PRICE>1000000000

AND

      decode

(INSPECTION_REQUIRED_FLAG||RECEIPT_REQUIRED_FLAG,'NN','2-Way','NY','3-Way','YY','4-Way','Not Specified')=:MATCH LEVEL