View: CSP_ENGINEER_DAYS_V

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

View Text

SELECT CPP.PLANNING_PARAMETERS_ID
, LEAST(MAX(TRUNC(SYSDATE) - TRUNC(CPP1.CREATION_DATE))
, CFRB.HISTORY_PERIODS * CFRB.PERIOD_SIZE)
, SUM(TRUNC(SYSDATE) - TRUNC(CPP1.CREATION_DATE))
FROM CSP_PLANNING_PARAMETERS CPP
, CSP_PLANNING_PARAMETERS CPP1
, CSP_FORECAST_RULES_B CFRB
WHERE CPP.NODE_TYPE = 'REGION'
AND CPP1.LEVEL_ID LIKE CPP.LEVEL_ID || '%'
AND CPP1.NODE_TYPE = 'SUBINVENTORY'
AND NVL(CPP1.CONDITION_TYPE
, 'B') = 'G'
AND CFRB.FORECAST_RULE_ID = CPP.FORECAST_RULE_ID GROUP BY CPP.PLANNING_PARAMETERS_ID
, CFRB.HISTORY_PERIODS * CFRB.PERIOD_SIZE

Columns