APPROVED PO REQUISITION REPORT QUERY

 
   APPROVED PO REQUISITION REPORT(PO)
  -----------------------------------

 THIS REPORT SHOWS THE INFORMATION ABOUT APPROVED PURCHASE REQUISITION.THIS
 REPRT CONTAIN BOTHE INTERNAL & PURCHASE REQUISITIONS WHICH ARE APPROVED BY
 THE AUTHORITIES

 SELECT PRHA.SEGMENT1 POREQNO,
        PRHA.TYPE_LOOKUP_CODE POREQTYPE,
        PRHA.LAST_UPDATE_DATE POREQDATE,
        PRHA.PREPARER_ID,
        MSIB.SEGMENT1 ITEM,
        MSIB.DESCRIPTION,
        PRLA.QUANTITY,
        PRLA.RATE PRICE,
        PRLA.QUANTITY*PRLA.UNIT_PRICE AMOUNT,
        GCC.CHART_OF_ACCOUNTS_ID,
        PP.PERSON_ID REQUESTOR,
        HL.ADDRESS_LINE_1 LOCNAME,
        OOD.ORGANIZATION_NAME
 FROM PO_REQUISITION_HEADERS_ALL PRHA,
   PO_REQUISITION_LINES_ALL PRLA,
   PO_REQ_DISTRIBUTIONS_ALL PRDA,
   PER_ALL_PEOPLE_F PP,
   MTL_SYSTEM_ITEMS_B MSIB,
   GL_CODE_COMBINATIONS GCC,
   HR_LOCATIONS HL,
   ORG_ORGANIZATION_DEFINITIONS OOD
 WHERE PRHA.PREPARER_ID=PP.PERSON_ID
   AND PRHA.REQUISITION_HEADER_ID=PRLA.REQUISITION_HEADER_ID
   AND PRLA.ITEM_ID=MSIB.INVENTORY_ITEM_ID
   AND PRDA.CODE_COMBINATION_ID=GCC.CODE_COMBINATION_ID
   AND PRLA.REQUISITION_LINE_ID=PRDA.REQUISITION_LINE_ID
   AND PRLA.DELIVER_TO_LOCATION_ID=HL.LOCATION_ID
   AND MSIB.ORGANIZATION_ID=OOD.ORGANIZATION_ID
   AND PRHA.AUTHORIZATION_STATUS='APPROVER'