View: CSP_PLANNING_ORG_HDR_V

Product:	CSP - Spares Management
Description:
Implementation/DBA Data:	APPS.CSP_PLANNING_ORG_HDR_V

View Text

SELECT CPHV.FUNC_CALL
, CPHV.INVENTORY_ITEM_ID
, CPHV.ORGANIZATION_ID
, MSI.CONCATENATED_SEGMENTS ITEM_NUMBER
, MSI.DESCRIPTION ITEM_DESCRIPTION
, SUM(ACTUAL_COST) ACTUAL_COST
, SUM(RECOMMENDED_COST) RECOMMENDED_COST
, SUM(DELTA_COST) DELTA_COST
FROM CSP_PLANNING_HEADERS_V CPHV
, MTL_SYSTEM_ITEMS_B_KFV MSI
WHERE CPHV.HEADER_DATA_TYPE = 1
AND MSI.INVENTORY_ITEM_ID(+) = CPHV.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID(+) = CPHV.ORGANIZATION_ID GROUP BY CPHV.INVENTORY_ITEM_ID
, CPHV.ORGANIZATION_ID
, MSI.CONCATENATED_SEGMENTS
, MSI.DESCRIPTION
, CPHV.FUNC_CALL

Columns