FND Design Data [Home] [Help]

View: PO_LINES_SUPPLIER_ITEMS_ALL_V

Product: PO - Purchasing
Description: 10SC ONLY
Implementation/DBA Data: ViewAPPS.PO_LINES_SUPPLIER_ITEMS_ALL_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')
AND PL.VENDOR_PRODUCT_NUM IS NOT NULL

Columns

Name
VENDOR_PRODUCT_NUM
ORG_ID