View: CSP_PLN_DRILLDOWN_ORG_V

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

View Text

SELECT CPHV.FUNC_CALL
, CPHV.INVENTORY_ITEM_ID
, CPHV.ORGANIZATION_ID
, 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
, CSP_PLANNING_PARAMETERS CPP
WHERE HEADER_DATA_TYPE = 4
AND CPHV.ORGANIZATION_ID = OOD.ORGANIZATION_ID
AND CPP.ORGANIZATION_ID = CPHV.ORGANIZATION_ID
AND CPP.SECONDARY_INVENTORY IS NULL
AND CPP.ORGANIZATION_TYPE = 'W' UNION SELECT 0
, CPOHV.INVENTORY_ITEM_ID
, CPOHV.ORGANIZATION_ID
, CPOHV.ITEM_NUMBER
, CPOHV.ITEM_DESCRIPTION
, OOD.ORGANIZATION_NAME
, CPOHV.ACTUAL_COST
, CPOHV.RECOMMENDED_COST
, CPOHV.DELTA_COST
FROM CSP_PLANNING_ORG_HDR_V CPOHV
, ORG_ORGANIZATION_DEFINITIONS OOD
, CSP_PLANNING_PARAMETERS CPP
WHERE OOD.ORGANIZATION_ID = CPOHV.ORGANIZATION_ID
AND CPP.ORGANIZATION_ID = CPOHV.ORGANIZATION_ID
AND CPP.SECONDARY_INVENTORY IS NULL
AND CPP.ORGANIZATION_TYPE = 'F'

Columns