VIEW: APPS.DDR_SV_EXCPTN_C_MV#

Source

View Text - Preformatted

SELECT "A1"."CLNDR_WK_ID" "CLNDR_WK_ID",
    "A1"."RTL_ORG_CD" "RTL_ORG_CD",
    "A1"."ORG_RGN_ID" "ORG_RGN_ID",
    "A1"."CHNL_TYP_CD" "CHNL_TYP_CD",
    "A1"."EXCPTN_TYP" "EXCPTN_TYP",
    "A1"."MFG_ITEM_CLASS_ID" "MFG_ITEM_CLASS_ID",
    "A1"."CLNDR_WK_ID" "CLNDR_DIM_ID",
    DECODE("A1"."CLNDR_WK_ID",NULL,NULL,'WK') "CLNDR_DIM_LVL",
    "A1"."ORG_RGN_ID" "ORG_DIM_ID",
    DECODE("A1"."ORG_RGN_ID",NULL,NULL,'RGN') "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",
    COUNT(*) "CNT_TOTAL",
    SUM("A1"."EXCPTN_CNT") "EXCPTN_CNT",
    SUM("A1"."EXCPTN_QTY") "EXCPTN_QTY",
    SUM("A1"."EXCPTN_AMT") "EXCPTN_AMT",
    COUNT("A1"."EXCPTN_CNT") "CNT_EXCPTN_CNT",
    COUNT("A1"."EXCPTN_QTY") "CNT_EXCPTN_QTY",
    COUNT("A1"."EXCPTN_AMT") "CNT_EXCPTN_AMT",
    GROUPING_ID("A1"."EXCPTN_TYP","A1"."MFG_ITEM_CLASS_ID","A1"."RTL_ORG_CD","A1"."ORG_RGN_ID","A1"."CLNDR_WK_ID","A1"."CHNL_TYP_CD") "GROUPING_ID"
  FROM "APPS"."DDR_BS_EXCPTN_SKU_BU_WK_C_MV" "A1"
  GROUP BY GROUPING SETS (("A1"."EXCPTN_TYP", "A1"."CLNDR_WK_ID", "A1"."MFG_ITEM_CLASS_ID", "A1"."ORG_RGN_ID", "A1"."CHNL_TYP_CD"), ("A1"."EXCPTN_TYP", "A1"."CLNDR_WK_ID", "A1"."MFG_ITEM_CLASS_ID", "A1"."RTL_ORG_CD", "A1"."CHNL_TYP_CD"))

View Text - HTML Formatted

SELECT "A1"."CLNDR_WK_ID" "CLNDR_WK_ID"
, "A1"."RTL_ORG_CD" "RTL_ORG_CD"
, "A1"."ORG_RGN_ID" "ORG_RGN_ID"
, "A1"."CHNL_TYP_CD" "CHNL_TYP_CD"
, "A1"."EXCPTN_TYP" "EXCPTN_TYP"
, "A1"."MFG_ITEM_CLASS_ID" "MFG_ITEM_CLASS_ID"
, "A1"."CLNDR_WK_ID" "CLNDR_DIM_ID"
, DECODE("A1"."CLNDR_WK_ID"
, NULL
, NULL
, 'WK') "CLNDR_DIM_LVL"
, "A1"."ORG_RGN_ID" "ORG_DIM_ID"
, DECODE("A1"."ORG_RGN_ID"
, NULL
, NULL
, 'RGN') "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"
, COUNT(*) "CNT_TOTAL"
, SUM("A1"."EXCPTN_CNT") "EXCPTN_CNT"
, SUM("A1"."EXCPTN_QTY") "EXCPTN_QTY"
, SUM("A1"."EXCPTN_AMT") "EXCPTN_AMT"
, COUNT("A1"."EXCPTN_CNT") "CNT_EXCPTN_CNT"
, COUNT("A1"."EXCPTN_QTY") "CNT_EXCPTN_QTY"
, COUNT("A1"."EXCPTN_AMT") "CNT_EXCPTN_AMT"
, GROUPING_ID("A1"."EXCPTN_TYP"
, "A1"."MFG_ITEM_CLASS_ID"
, "A1"."RTL_ORG_CD"
, "A1"."ORG_RGN_ID"
, "A1"."CLNDR_WK_ID"
, "A1"."CHNL_TYP_CD") "GROUPING_ID"
FROM "APPS"."DDR_BS_EXCPTN_SKU_BU_WK_C_MV" "A1" GROUP BY GROUPING SETS (("A1"."EXCPTN_TYP"
, "A1"."CLNDR_WK_ID"
, "A1"."MFG_ITEM_CLASS_ID"
, "A1"."ORG_RGN_ID"
, "A1"."CHNL_TYP_CD")
, ("A1"."EXCPTN_TYP"
, "A1"."CLNDR_WK_ID"
, "A1"."MFG_ITEM_CLASS_ID"
, "A1"."RTL_ORG_CD"
, "A1"."CHNL_TYP_CD"))