VIEW: APPS.MTH_RES_REQ_LT_MV#

Source

View Text - Preformatted

SELECT
RES_REQ.PRODUCT_FK_KEY,
RES_REQ.LEVEL9_FK_KEY,
SUM(RES_REQ.PLANNED_USAGE_QTY)PLANNED_USAGE_QTY,
COUNT(RES_REQ.PLANNED_USAGE_QTY)PLANNED_USAGE_QTY_COUNT,
SUM(RES_REQ.PLANNED_USAGE_VAL)PLANNED_USAGE_VAL,
COUNT(RES_REQ.PLANNED_USAGE_VAL)PLANNED_USAGE_VAL_COUNT,
RES_REQ.DAY_ID,
RES_REQ.CALENDAR_MONTH_ID,
COUNT(*)TOTAL_COUNT,
GROUPING_ID (PRODUCT_FK_KEY,LEVEL9_FK_KEY,DAY_ID, CALENDAR_MONTH_ID) GROUPING_ID,
DECODE (GROUPING_ID(DAY_ID, CALENDAR_MONTH_ID),
		1,DAY_ID,
		2,CALENDAR_MONTH_ID)TIME_DIM_KEY,
DECODE (GROUPING_ID(DAY_ID, CALENDAR_MONTH_ID),
		1,10,
		2,9)TIME_DIM_LEVEL,
DECODE (GROUPING_ID(PRODUCT_FK_KEY, LEVEL9_FK_KEY),
		1,PRODUCT_FK_KEY,
		2,LEVEL9_FK_KEY)ITEM_DIM_KEY,
DECODE (GROUPING_ID(PRODUCT_FK_KEY, LEVEL9_FK_KEY),
		1,10,
		2,9)ITEM_DIM_LEVEL
FROM
MTH_RES_REQ_IT_MV RES_REQ
GROUP BY GROUPING SETS ((PRODUCT_FK_KEY,CALENDAR_MONTH_ID),
						(LEVEL9_FK_KEY,DAY_ID),
						(LEVEL9_FK_KEY,CALENDAR_MONTH_ID))

View Text - HTML Formatted

SELECT RES_REQ.PRODUCT_FK_KEY
, RES_REQ.LEVEL9_FK_KEY
, SUM(RES_REQ.PLANNED_USAGE_QTY)PLANNED_USAGE_QTY
, COUNT(RES_REQ.PLANNED_USAGE_QTY)PLANNED_USAGE_QTY_COUNT
, SUM(RES_REQ.PLANNED_USAGE_VAL)PLANNED_USAGE_VAL
, COUNT(RES_REQ.PLANNED_USAGE_VAL)PLANNED_USAGE_VAL_COUNT
, RES_REQ.DAY_ID
, RES_REQ.CALENDAR_MONTH_ID
, COUNT(*)TOTAL_COUNT
, GROUPING_ID (PRODUCT_FK_KEY
, LEVEL9_FK_KEY
, DAY_ID
, CALENDAR_MONTH_ID) GROUPING_ID
, DECODE (GROUPING_ID(DAY_ID
, CALENDAR_MONTH_ID)
, 1
, DAY_ID
, 2
, CALENDAR_MONTH_ID)TIME_DIM_KEY
, DECODE (GROUPING_ID(DAY_ID
, CALENDAR_MONTH_ID)
, 1
, 10
, 2
, 9)TIME_DIM_LEVEL
, DECODE (GROUPING_ID(PRODUCT_FK_KEY
, LEVEL9_FK_KEY)
, 1
, PRODUCT_FK_KEY
, 2
, LEVEL9_FK_KEY)ITEM_DIM_KEY
, DECODE (GROUPING_ID(PRODUCT_FK_KEY
, LEVEL9_FK_KEY)
, 1
, 10
, 2
, 9)ITEM_DIM_LEVEL FROM MTH_RES_REQ_IT_MV RES_REQ GROUP BY GROUPING SETS ((PRODUCT_FK_KEY
, CALENDAR_MONTH_ID)
, (LEVEL9_FK_KEY
, DAY_ID)
, (LEVEL9_FK_KEY
, CALENDAR_MONTH_ID))