View: PO_LINES_SUPPLIER_ITEMS_V

Product:	PO - Purchasing
Description:	10SC ONLY
Implementation/DBA Data:	APPS.PO_LINES_SUPPLIER_ITEMS_V

View Text

SELECT DISTINCT PL.VENDOR_PRODUCT_NUM
, PL.ORG_ID
FROM PO_HEADERS_ALL PH
, PO_LINES PL
WHERE PL.PO_HEADER_ID = PH.PO_HEADER_ID
AND PH.TYPE_LOOKUP_CODE IN ('STANDARD'
, 'BLANKET'
, 'PLANNED'
, 'QUOTATION'
, 'RFQ')
AND NVL(PH.APPROVED_FLAG
, 'N') = 'Y'
AND NVL(PH.CANCEL_FLAG
, 'N') = 'N'
AND NVL(PL.CANCEL_FLAG
, 'N') = 'N'
AND PL.VENDOR_PRODUCT_NUM IS NOT NULL

Columns