View: RCV_PO_ITEMS_V

Product:	PO - Purchasing
Description:	- Retrofitted
Implementation/DBA Data:	APPS.RCV_PO_ITEMS_V

View Text

SELECT PL.PO_LINE_ID
, PL.ITEM_ID
, PL.ITEM_DESCRIPTION
, PL.ITEM_REVISION
, PL.CATEGORY_ID
, MIF.ITEM_NUMBER
, MIF.ORGANIZATION_ID
, UNIT_PRICE
FROM PO_LINES PL
, MTL_ITEM_FLEXFIELDS MIF
WHERE PL.ITEM_ID = MIF.ITEM_ID UNION SELECT PL.PO_LINE_ID
, TO_NUMBER(NULL)
, PL.ITEM_DESCRIPTION
, PL.ITEM_REVISION
, PL.CATEGORY_ID
, NULL
, TO_NUMBER(NULL)
, UNIT_PRICE
FROM PO_LINES PL
WHERE PL.ITEM_ID IS NULL

Columns