SELECT "A7"."MFG_ORG_CD" "MFG_ORG_CD",
"A7"."RTL_ORG_CD" "RTL_ORG_CD",
"A7"."ORG_BSNS_UNIT_ID" "ORG_BSNS_UNIT_ID",
"A7"."ITM_TYP" "ITM_TYP",
"A7"."FRCST_PURP" "FRCST_PURP",
"A7"."FRCST_TYP" "FRCST_TYP",
"A2"."ORG_RGN_ID" "ORG_RGN_ID",
"A2"."ORG_CHAIN_ID" "ORG_CHAIN_ID",
"A4"."MFG_ITEM_ID" "MFG_ITEM_ID",
"A4"."MFG_ITEM_CLASS_ID" "MFG_ITEM_CLASS_ID",
"A3"."RTL_ITEM_ID" "RTL_ITEM_ID",
"A3"."RTL_ITEM_CLASS_ID" "RTL_ITEM_CLASS_ID",
"A5"."CLNDR_WK_ID" "CLNDR_WK_ID",
COUNT(*) "CNT_TOTAL",
SUM("A1"."ACT_FRCST_SLS_AMT_RPT") "ACT_FRCST_SLS_AMT_RPT",
SUM("A1"."ACT_FRCST_SLS_QTY_PRMRY") "ACT_FRCST_SLS_QTY_PRMRY",
SUM(NVL("A7"."FRCST_SLS_QTY_PRMRY",0)) "FRCST_SLS_QTY_PRMRY",
SUM(NVL("A7"."FRCST_SLS_QTY_ALT",0)) "FRCST_SLS_QTY_ALT",
SUM(NVL("A7"."FRCST_SLS_AMT",0)) "FRCST_SLS_AMT",
SUM(NVL("A7"."FRCST_SLS_AMT_RPT",0)) "FRCST_SLS_AMT_RPT",
COUNT("A1"."ACT_FRCST_SLS_AMT_RPT") "CNT_ACT_FRCST_SLS_AMT_RPT",
COUNT("A1"."ACT_FRCST_SLS_QTY_PRMRY") "CNT_ACT_FRCST_SLS_QTY_PRMRY",
COUNT(NVL("A7"."FRCST_SLS_QTY_PRMRY",0)) "CNT_FRCST_SLS_QTY_PRMRY",
COUNT(NVL("A7"."FRCST_SLS_QTY_ALT",0)) "CNT_FRCST_SLS_QTY_ALT",
COUNT(NVL("A7"."FRCST_SLS_AMT",0)) "CNT_FRCST_SLS_AMT",
COUNT(NVL("A7"."FRCST_SLS_AMT_RPT",0)) "CNT_FRCST_SLS_AMT_RPT"
FROM "DDR_B_SLS_FRCST_ITEM_DAY" "A7",
"DDR_BS_FRCST_VRSN_MV" "A6",
"DDR_R_CLNDR_DAY_DN_MV" "A5",
"DDR_R_MFG_ITEM_SKU_DN_MV" "A4",
"DDR_R_RTL_ITEM_SKU_DN_MV" "A3",
"DDR_R_ORG_BU_DN_MV" "A2",
"DDR_BS_FRCST_LST_SLS_MV" "A1"
WHERE "A5"."DAY_CD" ="A7"."DAY_CD"
AND "A5"."CLNDR_DESC"="A7"."MFG_ORG_CD"
||'-CLNDR'
AND "A6"."MAX_FRCST_VRSN" ="A7"."FRCST_VRSN"
AND "A6"."DAY_CD" ="A7"."DAY_CD"
AND "A6"."MFG_SKU_ITEM_ID" ="A7"."MFG_SKU_ITEM_ID"
AND "A6"."ORG_BSNS_UNIT_ID"="A7"."ORG_BSNS_UNIT_ID"
AND "A6"."RTL_SKU_ITEM_ID" ="A7"."RTL_SKU_ITEM_ID"
AND "A6"."FRCST_PURP" ="A7"."FRCST_PURP"
AND "A6"."FRCST_TYP" ="A7"."FRCST_TYP"
AND "A4"."MFG_SKU_ITEM_ID" ="A7"."MFG_SKU_ITEM_ID"
AND "A3"."RTL_SKU_ITEM_ID" ="A7"."RTL_SKU_ITEM_ID"
AND "A2"."ORG_BSNS_UNIT_ID"="A7"."ORG_BSNS_UNIT_ID"
AND "A7"."FRCST_VRSN" ="A1"."MAX_FRCST_VRSN"
AND "A7"."DAY_CD" ="A1"."DAY_CD"
AND "A7"."MFG_SKU_ITEM_ID" ="A1"."MFG_SKU_ITEM_ID"
AND "A7"."ORG_BSNS_UNIT_ID"="A1"."ORG_BSNS_UNIT_ID"
AND "A7"."RTL_SKU_ITEM_ID" ="A1"."RTL_SKU_ITEM_ID"
AND "A7"."FRCST_PURP" ="A1"."FRCST_PURP"
AND "A7"."FRCST_TYP" ="A1"."FRCST_TYP"
GROUP BY "A5"."CLNDR_WK_ID",
"A7"."MFG_ORG_CD",
"A7"."RTL_ORG_CD",
"A7"."ORG_BSNS_UNIT_ID",
"A7"."ITM_TYP",
"A2"."ORG_RGN_ID",
"A2"."ORG_CHAIN_ID",
"A4"."MFG_ITEM_ID",
"A4"."MFG_ITEM_CLASS_ID",
"A3"."RTL_ITEM_ID",
"A3"."RTL_ITEM_CLASS_ID",
"A7"."FRCST_PURP",
"A7"."FRCST_TYP"
SELECT "A7"."MFG_ORG_CD" "MFG_ORG_CD"
,
"A7"."RTL_ORG_CD" "RTL_ORG_CD"
,
"A7"."ORG_BSNS_UNIT_ID" "ORG_BSNS_UNIT_ID"
,
"A7"."ITM_TYP" "ITM_TYP"
,
"A7"."FRCST_PURP" "FRCST_PURP"
,
"A7"."FRCST_TYP" "FRCST_TYP"
,
"A2"."ORG_RGN_ID" "ORG_RGN_ID"
,
"A2"."ORG_CHAIN_ID" "ORG_CHAIN_ID"
,
"A4"."MFG_ITEM_ID" "MFG_ITEM_ID"
,
"A4"."MFG_ITEM_CLASS_ID" "MFG_ITEM_CLASS_ID"
,
"A3"."RTL_ITEM_ID" "RTL_ITEM_ID"
,
"A3"."RTL_ITEM_CLASS_ID" "RTL_ITEM_CLASS_ID"
,
"A5"."CLNDR_WK_ID" "CLNDR_WK_ID"
,
COUNT(*) "CNT_TOTAL"
,
SUM("A1"."ACT_FRCST_SLS_AMT_RPT") "ACT_FRCST_SLS_AMT_RPT"
,
SUM("A1"."ACT_FRCST_SLS_QTY_PRMRY") "ACT_FRCST_SLS_QTY_PRMRY"
,
SUM(NVL("A7"."FRCST_SLS_QTY_PRMRY"
, 0)) "FRCST_SLS_QTY_PRMRY"
,
SUM(NVL("A7"."FRCST_SLS_QTY_ALT"
, 0)) "FRCST_SLS_QTY_ALT"
,
SUM(NVL("A7"."FRCST_SLS_AMT"
, 0)) "FRCST_SLS_AMT"
,
SUM(NVL("A7"."FRCST_SLS_AMT_RPT"
, 0)) "FRCST_SLS_AMT_RPT"
,
COUNT("A1"."ACT_FRCST_SLS_AMT_RPT") "CNT_ACT_FRCST_SLS_AMT_RPT"
,
COUNT("A1"."ACT_FRCST_SLS_QTY_PRMRY") "CNT_ACT_FRCST_SLS_QTY_PRMRY"
,
COUNT(NVL("A7"."FRCST_SLS_QTY_PRMRY"
, 0)) "CNT_FRCST_SLS_QTY_PRMRY"
,
COUNT(NVL("A7"."FRCST_SLS_QTY_ALT"
, 0)) "CNT_FRCST_SLS_QTY_ALT"
,
COUNT(NVL("A7"."FRCST_SLS_AMT"
, 0)) "CNT_FRCST_SLS_AMT"
,
COUNT(NVL("A7"."FRCST_SLS_AMT_RPT"
, 0)) "CNT_FRCST_SLS_AMT_RPT"
FROM "DDR_B_SLS_FRCST_ITEM_DAY" "A7"
,
"DDR_BS_FRCST_VRSN_MV" "A6"
,
"DDR_R_CLNDR_DAY_DN_MV" "A5"
,
"DDR_R_MFG_ITEM_SKU_DN_MV" "A4"
,
"DDR_R_RTL_ITEM_SKU_DN_MV" "A3"
,
"DDR_R_ORG_BU_DN_MV" "A2"
,
"DDR_BS_FRCST_LST_SLS_MV" "A1"
WHERE "A5"."DAY_CD" ="A7"."DAY_CD"
AND "A5"."CLNDR_DESC"="A7"."MFG_ORG_CD"
||'-CLNDR'
AND "A6"."MAX_FRCST_VRSN" ="A7"."FRCST_VRSN"
AND "A6"."DAY_CD" ="A7"."DAY_CD"
AND "A6"."MFG_SKU_ITEM_ID" ="A7"."MFG_SKU_ITEM_ID"
AND "A6"."ORG_BSNS_UNIT_ID"="A7"."ORG_BSNS_UNIT_ID"
AND "A6"."RTL_SKU_ITEM_ID" ="A7"."RTL_SKU_ITEM_ID"
AND "A6"."FRCST_PURP" ="A7"."FRCST_PURP"
AND "A6"."FRCST_TYP" ="A7"."FRCST_TYP"
AND "A4"."MFG_SKU_ITEM_ID" ="A7"."MFG_SKU_ITEM_ID"
AND "A3"."RTL_SKU_ITEM_ID" ="A7"."RTL_SKU_ITEM_ID"
AND "A2"."ORG_BSNS_UNIT_ID"="A7"."ORG_BSNS_UNIT_ID"
AND "A7"."FRCST_VRSN" ="A1"."MAX_FRCST_VRSN"
AND "A7"."DAY_CD" ="A1"."DAY_CD"
AND "A7"."MFG_SKU_ITEM_ID" ="A1"."MFG_SKU_ITEM_ID"
AND "A7"."ORG_BSNS_UNIT_ID"="A1"."ORG_BSNS_UNIT_ID"
AND "A7"."RTL_SKU_ITEM_ID" ="A1"."RTL_SKU_ITEM_ID"
AND "A7"."FRCST_PURP" ="A1"."FRCST_PURP"
AND "A7"."FRCST_TYP" ="A1"."FRCST_TYP"
GROUP BY "A5"."CLNDR_WK_ID"
,
"A7"."MFG_ORG_CD"
,
"A7"."RTL_ORG_CD"
,
"A7"."ORG_BSNS_UNIT_ID"
,
"A7"."ITM_TYP"
,
"A2"."ORG_RGN_ID"
,
"A2"."ORG_CHAIN_ID"
,
"A4"."MFG_ITEM_ID"
,
"A4"."MFG_ITEM_CLASS_ID"
,
"A3"."RTL_ITEM_ID"
,
"A3"."RTL_ITEM_CLASS_ID"
,
"A7"."FRCST_PURP"
,
"A7"."FRCST_TYP"
|
|
|