View: PO_LINES_VAL_V

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

View Text

SELECT POL.LINE_NUM
, MIS.CONCATENATED_SEGMENTS
, POL.ITEM_REVISION
, POL.ITEM_ID
, POL.UNIT_MEAS_LOOKUP_CODE
, POL.ITEM_DESCRIPTION
, POL.PO_HEADER_ID
, POL.PO_LINE_ID
, POL.ORG_ID
FROM PO_LINES POL
, MTL_SYSTEM_ITEMS_KFV MIS
, FINANCIALS_SYSTEM_PARAMS_ALL FSP
WHERE NVL(POL.CANCEL_FLAG
, 'N') = 'N'
AND POL.ITEM_ID IS NOT NULL
AND POL.ITEM_ID = MIS.INVENTORY_ITEM_ID
AND NVL(MIS.ORGANIZATION_ID
, FSP.INVENTORY_ORGANIZATION_ID) = FSP.INVENTORY_ORGANIZATION_ID
AND FSP.ORG_ID = POL.ORG_ID UNION SELECT POL.LINE_NUM
, NULL
, POL.ITEM_REVISION
, POL.ITEM_ID
, POL.UNIT_MEAS_LOOKUP_CODE
, POL.ITEM_DESCRIPTION
, POL.PO_HEADER_ID
, POL.PO_LINE_ID
, POL.ORG_ID
FROM PO_LINES POL
WHERE NVL(POL.CANCEL_FLAG
, 'N') = 'N'
AND POL.ITEM_ID IS NULL

Columns