[Home] [Help]
View: CSP_PLANNING_TOPNODE_HDR_V
View Text
SELECT CPHV.FUNC_CALL
, CPHV.INVENTORY_ITEM_ID
, MSI.CONCATENATED_SEGMENTS ITEM_NUMBER
, MSI.DESCRIPTION ITEM_DESCRIPTION
, SUM(NVL(ACTUAL_COST
, 0)) ACTUAL_COST
, SUM(NVL(RECOMMENDED_COST
, 0)) RECOMMENDED_COST
, SUM(NVL(DELTA_COST
, 0)) DELTA_COST
FROM CSP_PLANNING_HEADERS_V CPHV
, MTL_SYSTEM_ITEMS_B_KFV MSI
WHERE CPHV.HEADER_DATA_TYPE IN (1
, 4)
AND MSI.INVENTORY_ITEM_ID = CPHV.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID = CSP_PICK_UTILS.CSP_PRODUCT_ORGANIZATION GROUP BY CPHV.INVENTORY_ITEM_ID
, MSI.CONCATENATED_SEGMENTS
, MSI.DESCRIPTION
, CPHV.FUNC_CALL
Columns
Name |
FUNC_CALL |
INVENTORY_ITEM_ID |
ITEM_NUMBER |
ITEM_DESCRIPTION |
ACTUAL_COST |
RECOMMENDED_COST |
DELTA_COST |