MATERIALIZED VIEW: APPS.DDR_BS_SHIP_ITM_BU_WK_C_MV

Source

SELECT "A6"."MFG_ORG_CD" "MFG_ORG_CD","A6"."RTL_ORG_CD" "RTL_ORG_CD","A6"."ORG_BSNS_UNIT_ID" "ORG_BSNS_UNIT_ID","A6"."SHIP_TO_ORG_CD" "SHIP_TO_ORG_CD","A6"."SHIP_TO_BSNS_UNIT_ID" "SHIP_TO_BSNS_UNIT_ID","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","A1"."ORG_RGN_ID" "SHIP_TO_RGN_ID","A1"."ORG_CHAIN_ID" "SHIP_TO_CHAIN_ID",COUNT(*) "CNT_TOTAL",SUM(NVL("A6"."SHIP_QTY_PRMRY",0)) "SHIP_QTY_PRMRY",SUM(NVL("A6"."SHIP_QTY_ALT",0)) "SHIP_QTY_ALT",SUM(NVL("A6"."SHIP_AMT",0)) "SHIP_AMT",SUM(NVL("A6"."SHIP_AMT_RPT",0)) "SHIP_AMT_RPT",SUM(NVL("A6"."SHIP_COST",0)) "SHIP_COST",SUM(NVL("A6"."SHIP_COST_RPT",0)) "SHIP_COST_RPT",COUNT(NVL("A6"."SHIP_QTY_PRMRY",0)) "CNT_SHIP_QTY_PRMRY",COUNT(NVL("A6"."SHIP_QTY_ALT",0)) "CNT_SHIP_QTY_ALT",COUNT(NVL("A6"."SHIP_AMT",0)) "CNT_SHIP_AMT",COUNT(NVL("A6"."SHIP_AMT_RPT",0)) "CNT_SHIP_AMT_RPT",COUNT(NVL("A6"."SHIP_COST",0)) "CNT_SHIP_COST",COUNT(NVL("A6"."SHIP_COST_RPT",0)) "CNT_SHIP_COST_RPT" FROM "DDR"."DDR_B_RTL_SHIP_ITEM_DAY" "A6","APPS"."DDR_R_CLNDR_DAY_DN_MV" "A5","APPS"."DDR_R_MFG_ITEM_SKU_DN_MV" "A4","APPS"."DDR_R_RTL_ITEM_SKU_DN_MV" "A3","APPS"."DDR_R_ORG_BU_DN_MV" "A2","APPS"."DDR_R_ORG_BU_DN_MV" "A1" WHERE "A5"."DAY_CD"="A6"."DAY_CD" AND "A5"."CLNDR_DESC"="A6"."MFG_ORG_CD"||'-CLNDR' AND "A4"."MFG_SKU_ITEM_ID"="A6"."MFG_SKU_ITEM_ID" AND "A3"."RTL_SKU_ITEM_ID"="A6"."RTL_SKU_ITEM_ID" AND "A2"."ORG_BSNS_UNIT_ID"="A6"."ORG_BSNS_UNIT_ID" AND "A1"."ORG_BSNS_UNIT_ID"="A6"."SHIP_TO_BSNS_UNIT_ID" GROUP BY "A5"."CLNDR_WK_ID","A6"."MFG_ORG_CD","A6"."RTL_ORG_CD","A6"."ORG_BSNS_UNIT_ID","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","A6"."SHIP_TO_ORG_CD","A6"."SHIP_TO_BSNS_UNIT_ID","A1"."ORG_RGN_ID","A1"."ORG_CHAIN_ID"