VIEW: APPS.CSP_REG_USAGE_DETAILS_V

Source

View Text - Preformatted

SELECT curm.INVENTORY_ITEM_ID INVENTORY_ITEM_ID, cpp.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 cpp.node_type IN ('REGION','SPARES_PLANNING') And curm.LEVEL_ID like cpp.LEVEL_ID || '%' 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, cpp.PLANNING_PARAMETERS_ID, sysdate - ROUND((TO_NUMBER(sysdate - curm.period_start_date)/ cfrb.period_size+0.5)) * cfrb.period_size

View Text - HTML Formatted

SELECT CURM.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, CPP.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 CPP.NODE_TYPE IN ('REGION'
, 'SPARES_PLANNING')
AND CURM.LEVEL_ID LIKE CPP.LEVEL_ID || '%'
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
, CPP.PLANNING_PARAMETERS_ID
, SYSDATE - ROUND((TO_NUMBER(SYSDATE - CURM.PERIOD_START_DATE)/ CFRB.PERIOD_SIZE+0.5)) * CFRB.PERIOD_SIZE