[Home] [Help]
View: 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
Name |
FUNC_CALL |
INVENTORY_ITEM_ID |
ORGANIZATION_ID |
ITEM_NUMBER |
ITEM_DESCRIPTION |
ORGANIZATION_NAME |
ACTUAL_COST |
RECOMMENDED_COST |
DELTA_COST |