View: PO_BY_BUYER_V

Product:	PO - Purchasing
Description:	Purchase order information by buyer
Implementation/DBA Data:	APPS.PO_BY_BUYER_V

View Text

SELECT POH.SEGMENT1
, POH.TYPE_LOOKUP_CODE
, POH.CREATION_DATE
, PPF.FULL_NAME
, RTRIM(POV.VENDOR_NAME)
, ROUND(SUM(PLL.PRICE_OVERRIDE*(PLL.QUANTITY - PLL.QUANTITY_CANCELLED))
, 2)
, POH.CURRENCY_CODE
, POH.ORG_ID
FROM PO_HEADERS POH
, PO_VENDORS POV
, PO_LINE_LOCATIONS_ALL PLL
, PER_PEOPLE_F PPF
WHERE POH.PO_HEADER_ID = PLL.PO_HEADER_ID
AND POH.VENDOR_ID = POV.VENDOR_ID
AND NVL(POH.APPROVED_FLAG
, 'N') = 'Y'
AND POH.AGENT_ID = PPF.PERSON_ID GROUP BY POH.SEGMENT1
, POH.TYPE_LOOKUP_CODE
, POH.CREATION_DATE
, POV.VENDOR_NAME
, POH.CURRENCY_CODE
, PPF.FULL_NAME
, POH.ORG_ID

Columns