MATERIALIZED VIEW: APPS.DDR_BS_INV_SKU_BU_DAY_MV

Source

SELECT "A1"."MFG_ORG_CD" "MFG_ORG_CD","A1"."RTL_ORG_CD" "RTL_ORG_CD","A1"."ORG_BSNS_UNIT_ID" "ORG_BSNS_UNIT_ID","A1"."ITM_TYP" "ITM_TYP","A1"."GLBL_ITEM_ID" "GLBL_ITEM_ID","A1"."GLBL_ITEM_ID_TYP" "GLBL_ITEM_ID_TYP","A1"."MFG_SKU_ITEM_ID" "MFG_SKU_ITEM_ID","A1"."RTL_SKU_ITEM_ID" "RTL_SKU_ITEM_ID","A1"."DAY_CD" "DAY_CD",COUNT(*) "CNT_TOTAL",SUM("A1"."ON_HAND_QTY_PRMRY") "ON_HAND_QTY_PRMRY",SUM("A1"."ON_HAND_QTY_ALT") "ON_HAND_QTY_ALT",SUM("A1"."RECVD_QTY_PRMRY") "RECVD_QTY_PRMRY",SUM("A1"."RECVD_QTY_ALT") "RECVD_QTY_ALT",SUM("A1"."IN_TRANSIT_QTY_PRMRY") "IN_TRANSIT_QTY_PRMRY",SUM("A1"."IN_TRANSIT_QTY_ALT") "IN_TRANSIT_QTY_ALT",SUM("A1"."BCK_ORDR_QTY_PRMRY") "BCK_ORDR_QTY_PRMRY",SUM("A1"."BCK_ORDR_QTY_ALT") "BCK_ORDR_QTY_ALT",SUM("A1"."QLTY_HOLD_QTY_PRMRY") "QLTY_HOLD_QTY_PRMRY",SUM("A1"."QLTY_HOLD_QTY_ALT") "QLTY_HOLD_QTY_ALT",SUM("A1"."ON_HAND_NET_COST_AMT") "ON_HAND_NET_COST_AMT",SUM("A1"."ON_HAND_NET_COST_AMT_RPT") "ON_HAND_NET_COST_AMT_RPT",SUM("A1"."RECVD_NET_COST_AMT") "RECVD_NET_COST_AMT",SUM("A1"."RECVD_NET_COST_AMT_RPT") "RECVD_NET_COST_AMT_RPT",SUM("A1"."IN_TRANSIT_NET_COST_AMT") "IN_TRANSIT_NET_COST_AMT",SUM("A1"."IN_TRANSIT_NET_COST_AMT_RPT") "IN_TRANSIT_NET_COST_AMT_RPT",SUM("A1"."BCKORDR_NET_COST_AMT") "BCKORDR_NET_COST_AMT",SUM("A1"."BCKORDR_NET_COST_AMT_RPT") "BCKORDR_NET_COST_AMT_RPT",SUM("A1"."QLTY_HOLD_NET_COST_AMT") "QLTY_HOLD_NET_COST_AMT",SUM("A1"."QLTY_HOLD_NET_COST_AMT_RPT") "QLTY_HOLD_NET_COST_AMT_RPT",SUM("A1"."ON_HAND_RTL_AMT") "ON_HAND_RTL_AMT",SUM("A1"."ON_HAND_RTL_AMT_RPT") "ON_HAND_RTL_AMT_RPT",SUM("A1"."RECVD_RTL_AMT") "RECVD_RTL_AMT",SUM("A1"."RECVD_RTL_AMT_RPT") "RECVD_RTL_AMT_RPT",SUM("A1"."IN_TRANSIT_RTL_AMT") "IN_TRANSIT_RTL_AMT",SUM("A1"."IN_TRANSIT_RTL_AMT_RPT") "IN_TRANSIT_RTL_AMT_RPT",SUM("A1"."BCKORDR_RTL_AMT") "BCKORDR_RTL_AMT",SUM("A1"."BCKORDR_RTL_AMT_RPT") "BCKORDR_RTL_AMT_RPT",SUM("A1"."QLTY_HOLD_RTL_AMT") "QLTY_HOLD_RTL_AMT",SUM("A1"."QLTY_HOLD_RTL_AMT_RPT") "QLTY_HOLD_RTL_AMT_RPT",COUNT("A1"."ON_HAND_QTY_PRMRY") "CNT_ON_HAND_QTY_PRMRY",COUNT("A1"."ON_HAND_QTY_ALT") "CNT_ON_HAND_QTY_ALT",COUNT("A1"."RECVD_QTY_PRMRY") "CNT_RECVD_QTY_PRMRY",COUNT("A1"."RECVD_QTY_ALT") "CNT_RECVD_QTY_ALT",COUNT("A1"."IN_TRANSIT_QTY_PRMRY") "CNT_IN_TRANSIT_QTY_PRMRY",COUNT("A1"."IN_TRANSIT_QTY_ALT") "CNT_IN_TRANSIT_QTY_ALT",COUNT("A1"."BCK_ORDR_QTY_PRMRY") "CNT_BCK_ORDR_QTY_PRMRY",COUNT("A1"."BCK_ORDR_QTY_ALT") "CNT_BCK_ORDR_QTY_ALT",COUNT("A1"."QLTY_HOLD_QTY_PRMRY") "CNT_QLTY_HOLD_QTY_PRMRY",COUNT("A1"."QLTY_HOLD_QTY_ALT") "CNT_QLTY_HOLD_QTY_ALT",COUNT("A1"."ON_HAND_NET_COST_AMT") "CNT_ON_HAND_NET_COST_AMT",COUNT("A1"."ON_HAND_NET_COST_AMT_RPT") "CNT_ON_HAND_NET_COST_AMT_RPT",COUNT("A1"."RECVD_NET_COST_AMT") "CNT_RECVD_NET_COST_AMT",COUNT("A1"."RECVD_NET_COST_AMT_RPT") "CNT_RECVD_NET_COST_AMT_RPT",COUNT("A1"."IN_TRANSIT_NET_COST_AMT") "CNT_IN_TRANSIT_NET_COST_AMT",COUNT("A1"."IN_TRANSIT_NET_COST_AMT_RPT") "CNT_IN_TRANSIT_NET_CST_AMT_RPT",COUNT("A1"."BCKORDR_NET_COST_AMT") "CNT_BCKORDR_NET_COST_AMT",COUNT("A1"."BCKORDR_NET_COST_AMT_RPT") "CNT_BCKORDR_NET_COST_AMT_RPT",COUNT("A1"."QLTY_HOLD_NET_COST_AMT") "CNT_QLTY_HOLD_NET_COST_AMT",COUNT("A1"."QLTY_HOLD_NET_COST_AMT_RPT") "CNT_QLTY_HOLD_NET_COST_AMT_RPT",COUNT("A1"."ON_HAND_RTL_AMT") "CNT_ON_HAND_RTL_AMT",COUNT("A1"."ON_HAND_RTL_AMT_RPT") "CNT_ON_HAND_RTL_AMT_RPT",COUNT("A1"."RECVD_RTL_AMT") "CNT_RECVD_RTL_AMT",COUNT("A1"."RECVD_RTL_AMT_RPT") "CNT_RECVD_RTL_AMT_RPT",COUNT("A1"."IN_TRANSIT_RTL_AMT") "CNT_IN_TRANSIT_RTL_AMT",COUNT("A1"."IN_TRANSIT_RTL_AMT_RPT") "CNT_IN_TRANSIT_RTL_AMT_RPT",COUNT("A1"."BCKORDR_RTL_AMT") "CNT_BCKORDR_RTL_AMT",COUNT("A1"."BCKORDR_RTL_AMT_RPT") "CNT_BCKORDR_RTL_AMT_RPT",COUNT("A1"."QLTY_HOLD_RTL_AMT") "CNT_QLTY_HOLD_RTL_AMT",COUNT("A1"."QLTY_HOLD_RTL_AMT_RPT") "CNT_QLTY_HOLD_RTL_AMT_RPT" FROM "DDR"."DDR_B_RTL_INV_ITEM_DAY" "A1" GROUP BY "A1"."MFG_ORG_CD","A1"."RTL_ORG_CD","A1"."ORG_BSNS_UNIT_ID","A1"."ITM_TYP","A1"."GLBL_ITEM_ID","A1"."GLBL_ITEM_ID_TYP","A1"."MFG_SKU_ITEM_ID","A1"."RTL_SKU_ITEM_ID","A1"."DAY_CD"