[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 |
APPS.PO_LINES_ALL_V