VIEW: APPS.PO_LINES_SUPPLIER_ITEMS_ALL_V

Source

View Text - Preformatted

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') AND PL.VENDOR_PRODUCT_NUM IS NOT NULL

View Text - HTML Formatted

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')
AND PL.VENDOR_PRODUCT_NUM IS NOT NULL