[Home] [Help]
View: PO_LINES_ALL_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 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
Columns
Name |
LINE_NUM |
CONCATENATED_SEGMENTS |
ITEM_REVISION |
ITEM_ID |
UNIT_MEAS_LOOKUP_CODE |
ITEM_DESCRIPTION |
PO_HEADER_ID |
PO_LINE_ID |
ORG_ID |