[Home] [Help]
View: CSP_PLANNING_DRILLDOWN_V
View Text
SELECT CPHV.FUNC_CALL
, CPHV.INVENTORY_ITEM_ID
, CPHV.ORGANIZATION_ID
, CPHV.SECONDARY_INVENTORY
, CPHV.HEADER_DATA_TYPE
, CPHV.ITEM_NUMBER
, CPHV.ITEM_DESCRIPTION
, OOD.ORGANIZATION_NAME
, CPHV.ACTUAL_COST
, CPHV.RECOMMENDED_COST
, CPHV.DELTA_COST
FROM CSP_PLANNING_HEADERS_V CPHV
, ORG_ORGANIZATION_DEFINITIONS OOD
WHERE CPHV.ORGANIZATION_ID = OOD.ORGANIZATION_ID
Columns
Name |
FUNC_CALL |
INVENTORY_ITEM_ID |
ORGANIZATION_ID |
SECONDARY_INVENTORY |
HEADER_DATA_TYPE |
ITEM_NUMBER |
ITEM_DESCRIPTION |
ORGANIZATION_NAME |
ACTUAL_COST |
RECOMMENDED_COST |
DELTA_COST |