[Home] [Help]
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
Name |
PO_LINE_ID |
ITEM_ID |
ITEM_DESCRIPTION |
ITEM_REVISION |
CATEGORY_ID |
ITEM_NUMBER |
ORGANIZATION_ID |
UNIT_PRICE |