[Home] [Help]
View: CSP_PLN_DRILLDOWN_SUBINV_V
View Text
SELECT CPHV.FUNC_CALL
, CPHV.INVENTORY_ITEM_ID
, CPHV.ORGANIZATION_ID
, CPHV.SECONDARY_INVENTORY
, CPHV.ITEM_NUMBER
, CPHV.ITEM_DESCRIPTION
, SUM(CPHV.ACTUAL_COST) ACTUAL_COST
, SUM( CPHV.RECOMMENDED_COST) RECOMMENDED_COST
, SUM(CPHV.DELTA_COST) DELTA_COST
FROM CSP_PLANNING_HEADERS_V CPHV
WHERE CPHV. HEADER_DATA_TYPE = 1 GROUP BY CPHV.FUNC_CALL
, CPHV.INVENTORY_ITEM_ID
, CPHV.ORGANIZATION_ID
, CPHV.SECONDARY_INVENTORY
, CPHV.ITEM_NUMBER
, CPHV.ITEM_DESCRIPTION
Columns
Name |
FUNC_CALL |
INVENTORY_ITEM_ID |
ORGANIZATION_ID |
SECONDARY_INVENTORY |
ITEM_NUMBER |
ITEM_DESCRIPTION |
ACTUAL_COST |
RECOMMENDED_COST |
DELTA_COST |