Product: | FV - Federal Financials |
---|---|
Description: | The View is used to retrieve requisition details in the form 'Document Cross-Reference' |
Implementation/DBA Data: | APPS.FV_REQUISITION_MASTER_V |
SELECT PRH.ORG_ID
, PRH.REQUISITION_HEADER_ID
, PRL.REQUISITION_LINE_ID
, PLL.LINE_LOCATION_ID
, PH.PO_HEADER_ID
, SUGGESTED_VENDOR_NAME
, SUGGESTED_VENDOR_LOCATION
, PH.VENDOR_ID
, PH.VENDOR_SITE_ID
, PRH.SEGMENT1
, PRH.CREATION_DATE
, PRH.AUTHORIZATION_STATUS
, PRL.CANCEL_FLAG
, PRH.PREPARER_ID
, PRL.LINE_NUM
, PRL.ITEM_ID
, PRL.CATEGORY_ID
, PRL.ITEM_DESCRIPTION
, PRL.TO_PERSON_ID
, PRL.QUANTITY
, PRL.UNIT_MEAS_LOOKUP_CODE
, PRL.UNIT_PRICE
, PRL.NEED_BY_DATE
FROM PO_REQUISITION_HEADERS PRH
, PO_REQUISITION_LINES_ALL PRL
, PO_LINE_LOCATIONS_ALL PLL
, PO_HEADERS_ALL PH
WHERE PRL.REQUISITION_HEADER_ID = PRH.REQUISITION_HEADER_ID
AND PRL.LINE_LOCATION_ID = PLL.LINE_LOCATION_ID(+)
AND PLL.PO_HEADER_ID = PH.PO_HEADER_ID(+)
AND PRH.AUTHORIZATION_STATUS = 'APPROVED'