VIEW: APPS.CSP_NEW_PRODUCT_PLANNING_V

Source

View Text - Preformatted

SELECT cfr.inventory_item_id, cpp.organization_id, nvl(cpp.secondary_inventory,'-'), cp.population_change, manual_failure_rate, calculated_failure_rate, cpp.level_id from csp_planning_parameters cpp, csp_product_populations cp, csp_failure_rates cfr where cpp.node_type in ('ORGANIZATION_WH','SUBINVENTORY') and cp.planning_parameters_id = cpp.planning_parameters_id and cp.population_change is not null and cp.product_id = cfr.product_id and cfr.planning_parameters_id = nvl(cpp.product_norm_node_id,cpp.planning_parameters_id)

View Text - HTML Formatted

SELECT CFR.INVENTORY_ITEM_ID
, CPP.ORGANIZATION_ID
, NVL(CPP.SECONDARY_INVENTORY
, '-')
, CP.POPULATION_CHANGE
, MANUAL_FAILURE_RATE
, CALCULATED_FAILURE_RATE
, CPP.LEVEL_ID
FROM CSP_PLANNING_PARAMETERS CPP
, CSP_PRODUCT_POPULATIONS CP
, CSP_FAILURE_RATES CFR
WHERE CPP.NODE_TYPE IN ('ORGANIZATION_WH'
, 'SUBINVENTORY')
AND CP.PLANNING_PARAMETERS_ID = CPP.PLANNING_PARAMETERS_ID
AND CP.POPULATION_CHANGE IS NOT NULL
AND CP.PRODUCT_ID = CFR.PRODUCT_ID
AND CFR.PLANNING_PARAMETERS_ID = NVL(CPP.PRODUCT_NORM_NODE_ID
, CPP.PLANNING_PARAMETERS_ID)