View: CSP_REG_USAGE_DETAILS_V

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

View Text

SELECT CURM.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, CURM.PLANNING_PARAMETERS_ID
, TRUNC(SYSDATE - ROUND((TO_NUMBER(SYSDATE - CURM.PERIOD_START_DATE)/ CFRB.PERIOD_SIZE+0.5)) * CFRB.PERIOD_SIZE) PERIOD_START_DATE
, SUM(CURM.QUANTITY) QUANTITY
FROM CSP_PLANNING_PARAMETERS CPP
, CSP_USAGE_REG_MV CURM
, CSP_FORECAST_RULES_B CFRB
WHERE CURM.PLANNING_PARAMETERS_ID = CPP.PLANNING_PARAMETERS_ID
AND CPP.NODE_TYPE = 'REGION'
AND CURM.PERIOD_START_DATE BETWEEN TRUNC(SYSDATE) - CFRB.PERIOD_SIZE * CFRB.HISTORY_PERIODS
AND TRUNC(SYSDATE)
AND CFRB.FORECAST_RULE_ID = CPP.FORECAST_RULE_ID GROUP BY CURM.INVENTORY_ITEM_ID
, CURM.PLANNING_PARAMETERS_ID
, SYSDATE - ROUND((TO_NUMBER(SYSDATE - CURM.PERIOD_START_DATE)/ CFRB.PERIOD_SIZE+0.5)) * CFRB.PERIOD_SIZE

Columns