VIEW: APPS.CSP_PLN_DRILLDOWN_ORG_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'