VIEW: APPS.CSP_PRODUCT_POPULATIONS_FR_V

Source

View Text - Preformatted

SELECT cp.product_id,cp.current_population,cp.population_change, cfr.inventory_item_id,cpp.organization_id,nvl(cpp.secondary_inventory,'-'), cfr.calculated_failure_rate,cfr.manual_failure_rate,cpp.planning_parameters_id, cpp.node_type,cpp.level_id from csp_product_populations cp, csp_failure_rates cfr, csp_planning_parameters cpp where cpp.planning_parameters_id = cp.planning_parameters_id and cpp.recommend_method in ('PNORM','USAGE_PNORM') and cfr.planning_parameters_id = nvl(cpp.product_norm_node_id,cp.planning_parameters_id) and cfr.product_id = cp.product_id

View Text - HTML Formatted

SELECT CP.PRODUCT_ID
, CP.CURRENT_POPULATION
, CP.POPULATION_CHANGE
, CFR.INVENTORY_ITEM_ID
, CPP.ORGANIZATION_ID
, NVL(CPP.SECONDARY_INVENTORY
, '-')
, CFR.CALCULATED_FAILURE_RATE
, CFR.MANUAL_FAILURE_RATE
, CPP.PLANNING_PARAMETERS_ID
, CPP.NODE_TYPE
, CPP.LEVEL_ID
FROM CSP_PRODUCT_POPULATIONS CP
, CSP_FAILURE_RATES CFR
, CSP_PLANNING_PARAMETERS CPP
WHERE CPP.PLANNING_PARAMETERS_ID = CP.PLANNING_PARAMETERS_ID
AND CPP.RECOMMEND_METHOD IN ('PNORM'
, 'USAGE_PNORM')
AND CFR.PLANNING_PARAMETERS_ID = NVL(CPP.PRODUCT_NORM_NODE_ID
, CP.PLANNING_PARAMETERS_ID)
AND CFR.PRODUCT_ID = CP.PRODUCT_ID