View: CSP_PRODUCT_POPULATIONS_FR_V

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

View Text

SELECT CP.PRODUCT_ID
, CP.CURRENT_POPULATION
, CP.POPULATION_CHANGE
, CFR.INVENTORY_ITEM_ID
, CPP.ORGANIZATION_ID
, 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

Columns