View: CSP_PLANNING_TOPNODE_HDR_V

Product:	CSP - Spares Management
Description:
Implementation/DBA Data:	APPS.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