View: FV_PO_MASTER_V

Product:	FV - Federal Financials
Description:	The View is used to retrieve purchase order details in the form
Implementation/DBA Data:	APPS.FV_PO_MASTER_V

View Text

SELECT PH.ORG_ID
, PH.PO_HEADER_ID
, PL.PO_LINE_ID
, PLL.LINE_LOCATION_ID
, PH.VENDOR_ID
, PH.VENDOR_SITE_ID
, PR.PO_RELEASE_ID
, PH.SEGMENT1
, PH.CREATION_DATE
, PR.RELEASE_NUM
, PH.AGENT_ID
, PO_HEADERS_SV3.GET_PO_STATUS(PH.PO_HEADER_ID)
, PLL.CANCEL_FLAG
, PL.LINE_NUM
, PLL.SHIPMENT_NUM
, PLL.QUANTITY
, PLL.QUANTITY_RECEIVED
, PLL.QUANTITY_BILLED
, PL.ITEM_ID
, PL.CATEGORY_ID
, PL.UNIT_PRICE
, PL.UNIT_MEAS_LOOKUP_CODE
, PL.ITEM_DESCRIPTION
FROM PO_HEADERS PH
, PO_LINE_LOCATIONS PLL
, PO_RELEASES PR
, PO_LINES PL
WHERE PH.PO_HEADER_ID = PL.PO_HEADER_ID
AND PLL.PO_LINE_ID(+) = PL.PO_LINE_ID
AND PLL.PO_RELEASE_ID = PR.PO_RELEASE_ID(+)
AND TYPE_LOOKUP_CODE NOT IN ('CONTRACT')

Columns