MATERIALIZED VIEW: APPS.DDR_SV_SLSR_MV

Source

SELECT "A1"."BSNS_WK_ID" "BSNS_WK_ID","A1"."BSNS_MNTH_ID" "BSNS_MNTH_ID","A1"."ORG_RGN_ID" "ORG_RGN_ID","A1"."ORG_CHAIN_ID" "ORG_CHAIN_ID","A1"."MKT_AREA_ID" "MKT_AREA_ID","A1"."CHNL_TYP_CD" "CHNL_TYP_CD","A1"."ITM_TYP" "ITM_TYP","A1"."MFG_ITEM_CLASS_ID" "MFG_ITEM_CLASS_ID","A1"."RTL_ITEM_CLASS_ID" "RTL_ITEM_CLASS_ID","A1"."SLS_TYP_CD" "SLS_TYP_CD",DECODE(GROUPING_ID("A1"."BSNS_MNTH_ID","A1"."BSNS_WK_ID"),2,"A1"."BSNS_WK_ID",1,"A1"."BSNS_MNTH_ID") "BSNS_CLNDR_DIM_ID",DECODE(GROUPING_ID("A1"."BSNS_MNTH_ID","A1"."BSNS_WK_ID"),2,'WK',1,'MNTH') "BSNS_CLNDR_DIM_LVL",DECODE(GROUPING_ID("A1"."ORG_CHAIN_ID","A1"."ORG_RGN_ID"),2,"A1"."ORG_RGN_ID",1,"A1"."ORG_CHAIN_ID") "ORG_DIM_ID",DECODE(GROUPING_ID("A1"."ORG_CHAIN_ID","A1"."ORG_RGN_ID"),2,'RGN',1,'CHN') "ORG_DIM_LVL","A1"."MFG_ITEM_CLASS_ID" "MFG_ITEM_DIM_ID",DECODE("A1"."MFG_ITEM_CLASS_ID",NULL,NULL,'CLS') "MFG_ITEM_DIM_LVL","A1"."RTL_ITEM_CLASS_ID" "RTL_ITEM_DIM_ID",DECODE("A1"."RTL_ITEM_CLASS_ID",NULL,NULL,'CLS') "RTL_ITEM_DIM_LVL",COUNT(*) "CNT_TOTAL",SUM("A1"."ACT_BU_ITM_DAYS_SCANNED") "ACT_BU_ITM_DAYS_SCANNED",COUNT("A1"."ACT_BU_ITM_DAYS_SCANNED") "CNT_ACT_BU_ITM_DAYS_SCANNED",SUM("A1"."SLS_QTY_PRMRY") "SLS_QTY_PRMRY",SUM("A1"."SLS_QTY_ALT") "SLS_QTY_ALT",SUM("A1"."SLS_AMT") "SLS_AMT",SUM("A1"."SLS_AMT_RPT") "SLS_AMT_RPT",SUM("A1"."SLS_COST_AMT") "SLS_COST_AMT",SUM("A1"."SLS_COST_AMT_RPT") "SLS_COST_AMT_RPT",SUM("A1"."RTRN_QTY_PRMRY") "RTRN_QTY_PRMRY",SUM("A1"."RTRN_QTY_ALT") "RTRN_QTY_ALT",SUM("A1"."RTRN_AMT") "RTRN_AMT",SUM("A1"."RTRN_AMT_RPT") "RTRN_AMT_RPT",SUM("A1"."RTRN_COST_AMT") "RTRN_COST_AMT",SUM("A1"."RTRN_COST_AMT_RPT") "RTRN_COST_AMT_RPT",COUNT("A1"."SLS_QTY_PRMRY") "CNT_SLS_QTY_PRMRY",COUNT("A1"."SLS_QTY_ALT") "CNT_SLS_QTY_ALT",COUNT("A1"."SLS_AMT") "CNT_SLS_AMT",COUNT("A1"."SLS_AMT_RPT") "CNT_SLS_AMT_RPT",COUNT("A1"."SLS_COST_AMT") "CNT_SLS_COST_AMT",COUNT("A1"."SLS_COST_AMT_RPT") "CNT_SLS_COST_AMT_RPT",COUNT("A1"."RTRN_QTY_PRMRY") "CNT_RTRN_QTY_PRMRY",COUNT("A1"."RTRN_QTY_ALT") "CNT_RTRN_QTY_ALT",COUNT("A1"."RTRN_AMT") "CNT_RTRN_AMT",COUNT("A1"."RTRN_AMT_RPT") "CNT_RTRN_AMT_RPT",COUNT("A1"."RTRN_COST_AMT") "CNT_RTRN_COST_AMT",COUNT("A1"."RTRN_COST_AMT_RPT") "CNT_RTRN_COST_AMT_RPT",GROUPING_ID("A1"."MFG_ITEM_CLASS_ID","A1"."RTL_ITEM_CLASS_ID","A1"."ORG_RGN_ID","A1"."ORG_CHAIN_ID","A1"."BSNS_WK_ID","A1"."BSNS_MNTH_ID","A1"."MKT_AREA_ID","A1"."CHNL_TYP_CD","A1"."ITM_TYP","A1"."SLS_TYP_CD") "GROUPING_ID" FROM "APPS"."DDR_BS_SLSR_ITM_BU_WK_MV" "A1" GROUP BY  GROUPING SETS (("A1"."BSNS_MNTH_ID", "A1"."ORG_RGN_ID", "A1"."MFG_ITEM_CLASS_ID", "A1"."RTL_ITEM_CLASS_ID", "A1"."MKT_AREA_ID", "A1"."CHNL_TYP_CD", "A1"."ITM_TYP", "A1"."SLS_TYP_CD"), ("A1"."BSNS_MNTH_ID", "A1"."ORG_CHAIN_ID", "A1"."MFG_ITEM_CLASS_ID", "A1"."RTL_ITEM_CLASS_ID", "A1"."MKT_AREA_ID", "A1"."CHNL_TYP_CD", "A1"."ITM_TYP", "A1"."SLS_TYP_CD"), ("A1"."BSNS_WK_ID", "A1"."ORG_RGN_ID", "A1"."ITM_TYP"), ("A1"."BSNS_WK_ID", "A1"."ORG_CHAIN_ID", "A1"."ITM_TYP"), ("A1"."BSNS_WK_ID", "A1"."ORG_CHAIN_ID", "A1"."RTL_ITEM_CLASS_ID", "A1"."ITM_TYP"))