[Home] [Help]
MATERIALIZED VIEW: APPS.ISC_DBI_CFM_012_MV
Source
SELECT /* 12.0: bug#4526784 */
mv.inv_org_id INV_ORG_ID,
ecat.top_node_flag TOP_NODE_FLAG,
ecat.parent_id PARENT_ID,
ecat.imm_child_id IMM_CHILD_ID,
mv.time_snapshot_date_id TIME_SNAPSHOT_DATE_ID,
mv.late_schedule_flag LATE_SCHEDULE_FLAG,
mv.late_promise_flag LATE_PROMISE_FLAG,
grouping_id(mv.inv_org_id,
ecat.top_node_flag,
ecat.parent_id,
ecat.imm_child_id,
mv.time_snapshot_date_id,
mv.late_schedule_flag,
mv.late_promise_flag) GRP_ID,
1 UMARKER,
sum(mv.days_late) DAYS_LATE,
count(mv.days_late) DAYS_LATE_CNT,
sum(mv.days_late_promise) DAYS_LATE_PROMISE,
count(mv.days_late_promise) DAYS_LATE_PROMISE_CNT,
sum(mv.pdue_line_cnt) PDUE_LINE_CNT,
count(mv.pdue_line_cnt) PDUE_LINE_CNT_C,
sum(mv.pdue_amt_f) PDUE_AMT_F,
count(mv.pdue_amt_f) PDUE_AMT_F_CNT,
sum(mv.pdue_amt_g) PDUE_AMT_G,
count(mv.pdue_amt_g) PDUE_AMT_G_CNT,
sum(mv.pdue_amt_g1) PDUE_AMT_G1,
count(mv.pdue_amt_g1) PDUE_AMT_G1_CNT,
sum(mv.pdue_qty) PDUE_QTY,
count(mv.pdue_qty) PDUE_QTY_CNT,
sum(mv.bucket1_line_cnt) BUCKET1_LINE_CNT,
sum(mv.bucket2_line_cnt) BUCKET2_LINE_CNT,
sum(mv.bucket3_line_cnt) BUCKET3_LINE_CNT,
sum(mv.bucket4_line_cnt) BUCKET4_LINE_CNT,
sum(mv.bucket5_line_cnt) BUCKET5_LINE_CNT,
sum(mv.bucket6_line_cnt) BUCKET6_LINE_CNT,
sum(mv.bucket7_line_cnt) BUCKET7_LINE_CNT,
sum(mv.bucket8_line_cnt) BUCKET8_LINE_CNT,
sum(mv.bucket9_line_cnt) BUCKET9_LINE_CNT,
sum(mv.bucket10_line_cnt) BUCKET10_LINE_CNT,
count(mv.bucket1_line_cnt) BUCKET1_LINE_CNT_C,
count(mv.bucket2_line_cnt) BUCKET2_LINE_CNT_C,
count(mv.bucket3_line_cnt) BUCKET3_LINE_CNT_C,
count(mv.bucket4_line_cnt) BUCKET4_LINE_CNT_C,
count(mv.bucket5_line_cnt) BUCKET5_LINE_CNT_C,
count(mv.bucket6_line_cnt) BUCKET6_LINE_CNT_C,
count(mv.bucket7_line_cnt) BUCKET7_LINE_CNT_C,
count(mv.bucket8_line_cnt) BUCKET8_LINE_CNT_C,
count(mv.bucket9_line_cnt) BUCKET9_LINE_CNT_C,
count(mv.bucket10_line_cnt) BUCKET10_LINE_CNT_C,
sum(mv.bucket1_days_late) BUCKET1_DAYS_LATE,
sum(mv.bucket2_days_late) BUCKET2_DAYS_LATE,
sum(mv.bucket3_days_late) BUCKET3_DAYS_LATE,
sum(mv.bucket4_days_late) BUCKET4_DAYS_LATE,
sum(mv.bucket5_days_late) BUCKET5_DAYS_LATE,
sum(mv.bucket6_days_late) BUCKET6_DAYS_LATE,
sum(mv.bucket7_days_late) BUCKET7_DAYS_LATE,
sum(mv.bucket8_days_late) BUCKET8_DAYS_LATE,
sum(mv.bucket9_days_late) BUCKET9_DAYS_LATE,
sum(mv.bucket10_days_late) BUCKET10_DAYS_LATE,
count(mv.bucket1_days_late) BUCKET1_DAYS_LATE_C,
count(mv.bucket2_days_late) BUCKET2_DAYS_LATE_C,
count(mv.bucket3_days_late) BUCKET3_DAYS_LATE_C,
count(mv.bucket4_days_late) BUCKET4_DAYS_LATE_C,
count(mv.bucket5_days_late) BUCKET5_DAYS_LATE_C,
count(mv.bucket6_days_late) BUCKET6_DAYS_LATE_C,
count(mv.bucket7_days_late) BUCKET7_DAYS_LATE_C,
count(mv.bucket8_days_late) BUCKET8_DAYS_LATE_C,
count(mv.bucket9_days_late) BUCKET9_DAYS_LATE_C,
count(mv.bucket10_days_late) BUCKET10_DAYS_LATE_C,
sum(mv.bucket1_qty) BUCKET1_QTY,
sum(mv.bucket2_qty) BUCKET2_QTY,
sum(mv.bucket3_qty) BUCKET3_QTY,
sum(mv.bucket4_qty) BUCKET4_QTY,
sum(mv.bucket5_qty) BUCKET5_QTY,
sum(mv.bucket6_qty) BUCKET6_QTY,
sum(mv.bucket7_qty) BUCKET7_QTY,
sum(mv.bucket8_qty) BUCKET8_QTY,
sum(mv.bucket9_qty) BUCKET9_QTY,
sum(mv.bucket10_qty) BUCKET10_QTY,
count(mv.bucket1_qty) BUCKET1_QTY_C,
count(mv.bucket2_qty) BUCKET2_QTY_C,
count(mv.bucket3_qty) BUCKET3_QTY_C,
count(mv.bucket4_qty) BUCKET4_QTY_C,
count(mv.bucket5_qty) BUCKET5_QTY_C,
count(mv.bucket6_qty) BUCKET6_QTY_C,
count(mv.bucket7_qty) BUCKET7_QTY_C,
count(mv.bucket8_qty) BUCKET8_QTY_C,
count(mv.bucket9_qty) BUCKET9_QTY_C,
count(mv.bucket10_qty) BUCKET10_QTY_C,
sum(mv.bucket1_pdue_amt_f) BUCKET1_PDUE_AMT_F,
sum(mv.bucket2_pdue_amt_f) BUCKET2_PDUE_AMT_F,
sum(mv.bucket3_pdue_amt_f) BUCKET3_PDUE_AMT_F,
sum(mv.bucket4_pdue_amt_f) BUCKET4_PDUE_AMT_F,
sum(mv.bucket5_pdue_amt_f) BUCKET5_PDUE_AMT_F,
sum(mv.bucket6_pdue_amt_f) BUCKET6_PDUE_AMT_F,
sum(mv.bucket7_pdue_amt_f) BUCKET7_PDUE_AMT_F,
sum(mv.bucket8_pdue_amt_f) BUCKET8_PDUE_AMT_F,
sum(mv.bucket9_pdue_amt_f) BUCKET9_PDUE_AMT_F,
sum(mv.bucket10_pdue_amt_f) BUCKET10_PDUE_AMT_F,
count(mv.bucket1_pdue_amt_f) BUCKET1_PDUE_AMT_F_C,
count(mv.bucket2_pdue_amt_f) BUCKET2_PDUE_AMT_F_C,
count(mv.bucket3_pdue_amt_f) BUCKET3_PDUE_AMT_F_C,
count(mv.bucket4_pdue_amt_f) BUCKET4_PDUE_AMT_F_C,
count(mv.bucket5_pdue_amt_f) BUCKET5_PDUE_AMT_F_C,
count(mv.bucket6_pdue_amt_f) BUCKET6_PDUE_AMT_F_C,
count(mv.bucket7_pdue_amt_f) BUCKET7_PDUE_AMT_F_C,
count(mv.bucket8_pdue_amt_f) BUCKET8_PDUE_AMT_F_C,
count(mv.bucket9_pdue_amt_f) BUCKET9_PDUE_AMT_F_C,
count(mv.bucket10_pdue_amt_f) BUCKET10_PDUE_AMT_F_C,
sum(mv.bucket1_pdue_amt_g) BUCKET1_PDUE_AMT_G,
sum(mv.bucket2_pdue_amt_g) BUCKET2_PDUE_AMT_G,
sum(mv.bucket3_pdue_amt_g) BUCKET3_PDUE_AMT_G,
sum(mv.bucket4_pdue_amt_g) BUCKET4_PDUE_AMT_G,
sum(mv.bucket5_pdue_amt_g) BUCKET5_PDUE_AMT_G,
sum(mv.bucket6_pdue_amt_g) BUCKET6_PDUE_AMT_G,
sum(mv.bucket7_pdue_amt_g) BUCKET7_PDUE_AMT_G,
sum(mv.bucket8_pdue_amt_g) BUCKET8_PDUE_AMT_G,
sum(mv.bucket9_pdue_amt_g) BUCKET9_PDUE_AMT_G,
sum(mv.bucket10_pdue_amt_g) BUCKET10_PDUE_AMT_G,
count(mv.bucket1_pdue_amt_g) BUCKET1_PDUE_AMT_G_C,
count(mv.bucket2_pdue_amt_g) BUCKET2_PDUE_AMT_G_C,
count(mv.bucket3_pdue_amt_g) BUCKET3_PDUE_AMT_G_C,
count(mv.bucket4_pdue_amt_g) BUCKET4_PDUE_AMT_G_C,
count(mv.bucket5_pdue_amt_g) BUCKET5_PDUE_AMT_G_C,
count(mv.bucket6_pdue_amt_g) BUCKET6_PDUE_AMT_G_C,
count(mv.bucket7_pdue_amt_g) BUCKET7_PDUE_AMT_G_C,
count(mv.bucket8_pdue_amt_g) BUCKET8_PDUE_AMT_G_C,
count(mv.bucket9_pdue_amt_g) BUCKET9_PDUE_AMT_G_C,
count(mv.bucket10_pdue_amt_g) BUCKET10_PDUE_AMT_G_C,
sum(mv.bucket1_pdue_amt_g1) BUCKET1_PDUE_AMT_G1,
sum(mv.bucket2_pdue_amt_g1) BUCKET2_PDUE_AMT_G1,
sum(mv.bucket3_pdue_amt_g1) BUCKET3_PDUE_AMT_G1,
sum(mv.bucket4_pdue_amt_g1) BUCKET4_PDUE_AMT_G1,
sum(mv.bucket5_pdue_amt_g1) BUCKET5_PDUE_AMT_G1,
sum(mv.bucket6_pdue_amt_g1) BUCKET6_PDUE_AMT_G1,
sum(mv.bucket7_pdue_amt_g1) BUCKET7_PDUE_AMT_G1,
sum(mv.bucket8_pdue_amt_g1) BUCKET8_PDUE_AMT_G1,
sum(mv.bucket9_pdue_amt_g1) BUCKET9_PDUE_AMT_G1,
sum(mv.bucket10_pdue_amt_g1) BUCKET10_PDUE_AMT_G1,
count(mv.bucket1_pdue_amt_g1) BUCKET1_PDUE_AMT_G1_C,
count(mv.bucket2_pdue_amt_g1) BUCKET2_PDUE_AMT_G1_C,
count(mv.bucket3_pdue_amt_g1) BUCKET3_PDUE_AMT_G1_C,
count(mv.bucket4_pdue_amt_g1) BUCKET4_PDUE_AMT_G1_C,
count(mv.bucket5_pdue_amt_g1) BUCKET5_PDUE_AMT_G1_C,
count(mv.bucket6_pdue_amt_g1) BUCKET6_PDUE_AMT_G1_C,
count(mv.bucket7_pdue_amt_g1) BUCKET7_PDUE_AMT_G1_C,
count(mv.bucket8_pdue_amt_g1) BUCKET8_PDUE_AMT_G1_C,
count(mv.bucket9_pdue_amt_g1) BUCKET9_PDUE_AMT_G1_C,
count(mv.bucket10_pdue_amt_g1) BUCKET10_PDUE_AMT_G1_C,
sum(mv.bucket1_line_cnt_p) BUCKET1_LINE_CNT_P,
sum(mv.bucket2_line_cnt_p) BUCKET2_LINE_CNT_P,
sum(mv.bucket3_line_cnt_p) BUCKET3_LINE_CNT_P,
sum(mv.bucket4_line_cnt_p) BUCKET4_LINE_CNT_P,
sum(mv.bucket5_line_cnt_p) BUCKET5_LINE_CNT_P,
sum(mv.bucket6_line_cnt_p) BUCKET6_LINE_CNT_P,
sum(mv.bucket7_line_cnt_p) BUCKET7_LINE_CNT_P,
sum(mv.bucket8_line_cnt_p) BUCKET8_LINE_CNT_P,
sum(mv.bucket9_line_cnt_p) BUCKET9_LINE_CNT_P,
sum(mv.bucket10_line_cnt_p) BUCKET10_LINE_CNT_P,
count(mv.bucket1_line_cnt_p) BUCKET1_LINE_CNT_P_C,
count(mv.bucket2_line_cnt_p) BUCKET2_LINE_CNT_P_C,
count(mv.bucket3_line_cnt_p) BUCKET3_LINE_CNT_P_C,
count(mv.bucket4_line_cnt_p) BUCKET4_LINE_CNT_P_C,
count(mv.bucket5_line_cnt_p) BUCKET5_LINE_CNT_P_C,
count(mv.bucket6_line_cnt_p) BUCKET6_LINE_CNT_P_C,
count(mv.bucket7_line_cnt_p) BUCKET7_LINE_CNT_P_C,
count(mv.bucket8_line_cnt_p) BUCKET8_LINE_CNT_P_C,
count(mv.bucket9_line_cnt_p) BUCKET9_LINE_CNT_P_C,
count(mv.bucket10_line_cnt_p) BUCKET10_LINE_CNT_P_C,
sum(mv.bucket1_days_late_p) BUCKET1_DAYS_LATE_P,
sum(mv.bucket2_days_late_p) BUCKET2_DAYS_LATE_P,
sum(mv.bucket3_days_late_p) BUCKET3_DAYS_LATE_P,
sum(mv.bucket4_days_late_p) BUCKET4_DAYS_LATE_P,
sum(mv.bucket5_days_late_p) BUCKET5_DAYS_LATE_P,
sum(mv.bucket6_days_late_p) BUCKET6_DAYS_LATE_P,
sum(mv.bucket7_days_late_p) BUCKET7_DAYS_LATE_P,
sum(mv.bucket8_days_late_p) BUCKET8_DAYS_LATE_P,
sum(mv.bucket9_days_late_p) BUCKET9_DAYS_LATE_P,
sum(mv.bucket10_days_late_p) BUCKET10_DAYS_LATE_P,
count(mv.bucket1_days_late_p) BUCKET1_DAYS_LATE_P_C,
count(mv.bucket2_days_late_p) BUCKET2_DAYS_LATE_P_C,
count(mv.bucket3_days_late_p) BUCKET3_DAYS_LATE_P_C,
count(mv.bucket4_days_late_p) BUCKET4_DAYS_LATE_P_C,
count(mv.bucket5_days_late_p) BUCKET5_DAYS_LATE_P_C,
count(mv.bucket6_days_late_p) BUCKET6_DAYS_LATE_P_C,
count(mv.bucket7_days_late_p) BUCKET7_DAYS_LATE_P_C,
count(mv.bucket8_days_late_p) BUCKET8_DAYS_LATE_P_C,
count(mv.bucket9_days_late_p) BUCKET9_DAYS_LATE_P_C,
count(mv.bucket10_days_late_p) BUCKET10_DAYS_LATE_P_C,
sum(mv.bucket1_qty_p) BUCKET1_QTY_P,
sum(mv.bucket2_qty_p) BUCKET2_QTY_P,
sum(mv.bucket3_qty_p) BUCKET3_QTY_P,
sum(mv.bucket4_qty_p) BUCKET4_QTY_P,
sum(mv.bucket5_qty_p) BUCKET5_QTY_P,
sum(mv.bucket6_qty_p) BUCKET6_QTY_P,
sum(mv.bucket7_qty_p) BUCKET7_QTY_P,
sum(mv.bucket8_qty_p) BUCKET8_QTY_P,
sum(mv.bucket9_qty_p) BUCKET9_QTY_P,
sum(mv.bucket10_qty_p) BUCKET10_QTY_P,
count(mv.bucket1_qty_p) BUCKET1_QTY_P_C,
count(mv.bucket2_qty_p) BUCKET2_QTY_P_C,
count(mv.bucket3_qty_p) BUCKET3_QTY_P_C,
count(mv.bucket4_qty_p) BUCKET4_QTY_P_C,
count(mv.bucket5_qty_p) BUCKET5_QTY_P_C,
count(mv.bucket6_qty_p) BUCKET6_QTY_P_C,
count(mv.bucket7_qty_p) BUCKET7_QTY_P_C,
count(mv.bucket8_qty_p) BUCKET8_QTY_P_C,
count(mv.bucket9_qty_p) BUCKET9_QTY_P_C,
count(mv.bucket10_qty_p) BUCKET10_QTY_P_C,
sum(mv.bucket1_pdue_amt_f_p) BUCKET1_PDUE_AMT_F_P,
sum(mv.bucket2_pdue_amt_f_p) BUCKET2_PDUE_AMT_F_P,
sum(mv.bucket3_pdue_amt_f_p) BUCKET3_PDUE_AMT_F_P,
sum(mv.bucket4_pdue_amt_f_p) BUCKET4_PDUE_AMT_F_P,
sum(mv.bucket5_pdue_amt_f_p) BUCKET5_PDUE_AMT_F_P,
sum(mv.bucket6_pdue_amt_f_p) BUCKET6_PDUE_AMT_F_P,
sum(mv.bucket7_pdue_amt_f_p) BUCKET7_PDUE_AMT_F_P,
sum(mv.bucket8_pdue_amt_f_p) BUCKET8_PDUE_AMT_F_P,
sum(mv.bucket9_pdue_amt_f_p) BUCKET9_PDUE_AMT_F_P,
sum(mv.bucket10_pdue_amt_f_p) BUCKET10_PDUE_AMT_F_P,
count(mv.bucket1_pdue_amt_f_p) BUCKET1_PDUE_AMT_F_P_C,
count(mv.bucket2_pdue_amt_f_p) BUCKET2_PDUE_AMT_F_P_C,
count(mv.bucket3_pdue_amt_f_p) BUCKET3_PDUE_AMT_F_P_C,
count(mv.bucket4_pdue_amt_f_p) BUCKET4_PDUE_AMT_F_P_C,
count(mv.bucket5_pdue_amt_f_p) BUCKET5_PDUE_AMT_F_P_C,
count(mv.bucket6_pdue_amt_f_p) BUCKET6_PDUE_AMT_F_P_C,
count(mv.bucket7_pdue_amt_f_p) BUCKET7_PDUE_AMT_F_P_C,
count(mv.bucket8_pdue_amt_f_p) BUCKET8_PDUE_AMT_F_P_C,
count(mv.bucket9_pdue_amt_f_p) BUCKET9_PDUE_AMT_F_P_C,
count(mv.bucket10_pdue_amt_f_p) BUCKET10_PDUE_AMT_F_P_C,
sum(mv.bucket1_pdue_amt_g_p) BUCKET1_PDUE_AMT_G_P,
sum(mv.bucket2_pdue_amt_g_p) BUCKET2_PDUE_AMT_G_P,
sum(mv.bucket3_pdue_amt_g_p) BUCKET3_PDUE_AMT_G_P,
sum(mv.bucket4_pdue_amt_g_p) BUCKET4_PDUE_AMT_G_P,
sum(mv.bucket5_pdue_amt_g_p) BUCKET5_PDUE_AMT_G_P,
sum(mv.bucket6_pdue_amt_g_p) BUCKET6_PDUE_AMT_G_P,
sum(mv.bucket7_pdue_amt_g_p) BUCKET7_PDUE_AMT_G_P,
sum(mv.bucket8_pdue_amt_g_p) BUCKET8_PDUE_AMT_G_P,
sum(mv.bucket9_pdue_amt_g_p) BUCKET9_PDUE_AMT_G_P,
sum(mv.bucket10_pdue_amt_g_p) BUCKET10_PDUE_AMT_G_P,
count(mv.bucket1_pdue_amt_g_p) BUCKET1_PDUE_AMT_G_P_C,
count(mv.bucket2_pdue_amt_g_p) BUCKET2_PDUE_AMT_G_P_C,
count(mv.bucket3_pdue_amt_g_p) BUCKET3_PDUE_AMT_G_P_C,
count(mv.bucket4_pdue_amt_g_p) BUCKET4_PDUE_AMT_G_P_C,
count(mv.bucket5_pdue_amt_g_p) BUCKET5_PDUE_AMT_G_P_C,
count(mv.bucket6_pdue_amt_g_p) BUCKET6_PDUE_AMT_G_P_C,
count(mv.bucket7_pdue_amt_g_p) BUCKET7_PDUE_AMT_G_P_C,
count(mv.bucket8_pdue_amt_g_p) BUCKET8_PDUE_AMT_G_P_C,
count(mv.bucket9_pdue_amt_g_p) BUCKET9_PDUE_AMT_G_P_C,
count(mv.bucket10_pdue_amt_g_p) BUCKET10_PDUE_AMT_G_P_C,
sum(mv.bucket1_pdue_amt_g1_p) BUCKET1_PDUE_AMT_G1_P,
sum(mv.bucket2_pdue_amt_g1_p) BUCKET2_PDUE_AMT_G1_P,
sum(mv.bucket3_pdue_amt_g1_p) BUCKET3_PDUE_AMT_G1_P,
sum(mv.bucket4_pdue_amt_g1_p) BUCKET4_PDUE_AMT_G1_P,
sum(mv.bucket5_pdue_amt_g1_p) BUCKET5_PDUE_AMT_G1_P,
sum(mv.bucket6_pdue_amt_g1_p) BUCKET6_PDUE_AMT_G1_P,
sum(mv.bucket7_pdue_amt_g1_p) BUCKET7_PDUE_AMT_G1_P,
sum(mv.bucket8_pdue_amt_g1_p) BUCKET8_PDUE_AMT_G1_P,
sum(mv.bucket9_pdue_amt_g1_p) BUCKET9_PDUE_AMT_G1_P,
sum(mv.bucket10_pdue_amt_g1_p) BUCKET10_PDUE_AMT_G1_P,
count(mv.bucket1_pdue_amt_g1_p) BUCKET1_PDUE_AMT_G1_P_C,
count(mv.bucket2_pdue_amt_g1_p) BUCKET2_PDUE_AMT_G1_P_C,
count(mv.bucket3_pdue_amt_g1_p) BUCKET3_PDUE_AMT_G1_P_C,
count(mv.bucket4_pdue_amt_g1_p) BUCKET4_PDUE_AMT_G1_P_C,
count(mv.bucket5_pdue_amt_g1_p) BUCKET5_PDUE_AMT_G1_P_C,
count(mv.bucket6_pdue_amt_g1_p) BUCKET6_PDUE_AMT_G1_P_C,
count(mv.bucket7_pdue_amt_g1_p) BUCKET7_PDUE_AMT_G1_P_C,
count(mv.bucket8_pdue_amt_g1_p) BUCKET8_PDUE_AMT_G1_P_C,
count(mv.bucket9_pdue_amt_g1_p) BUCKET9_PDUE_AMT_G1_P_C,
count(mv.bucket10_pdue_amt_g1_p) BUCKET10_PDUE_AMT_G1_P_C,
count(*) CNT
FROM isc_dbi_cfm_008_mv mv,
ENI.ENI_DENORM_HIERARCHIES ecat,
INV.MTL_DEFAULT_CATEGORY_SETS mtl
WHERE mv.item_category_id = ecat.child_id
AND ecat.object_type = 'CATEGORY_SET'
AND ecat.object_id = mtl.category_set_id
AND ecat.dbi_flag = 'Y'
AND mtl.functional_area_id = 11
AND mv.item_cat_flag = 1
AND mv.customer_flag = 1
GROUP BY mv.inv_org_id,
ecat.top_node_flag,
ecat.parent_id,
ecat.imm_child_id,
mv.time_snapshot_date_id,
mv.late_schedule_flag,
mv.late_promise_flag
UNION ALL
SELECT /* 12.0: bug#4526784 */
mv.inv_org_id INV_ORG_ID,
NULL TOP_NODE_FLAG,
NULL PARENT_ID,
NULL IMM_CHILD_ID,
mv.time_snapshot_date_id TIME_SNAPSHOT_DATE_ID,
mv.late_schedule_flag LATE_SCHEDULE_FLAG,
mv.late_promise_flag LATE_PROMISE_FLAG,
grouping_id(mv.inv_org_id,
mv.time_snapshot_date_id,
mv.late_schedule_flag,
mv.late_promise_flag) GRP_ID,
2 UMARKER,
sum(mv.days_late) DAYS_LATE,
count(mv.days_late) DAYS_LATE_CNT,
sum(mv.days_late_promise) DAYS_LATE_PROMISE,
count(mv.days_late_promise) DAYS_LATE_PROMISE_CNT,
sum(mv.pdue_line_cnt) PDUE_LINE_CNT,
count(mv.pdue_line_cnt) PDUE_LINE_CNT_C,
sum(mv.pdue_amt_f) PDUE_AMT_F,
count(mv.pdue_amt_f) PDUE_AMT_F_CNT,
sum(mv.pdue_amt_g) PDUE_AMT_G,
count(mv.pdue_amt_g) PDUE_AMT_G_CNT,
sum(mv.pdue_amt_g1) PDUE_AMT_G1,
count(mv.pdue_amt_g1) PDUE_AMT_G1_CNT,
sum(mv.pdue_qty) PDUE_QTY,
count(mv.pdue_qty) PDUE_QTY_CNT,
sum(mv.bucket1_line_cnt) BUCKET1_LINE_CNT,
sum(mv.bucket2_line_cnt) BUCKET2_LINE_CNT,
sum(mv.bucket3_line_cnt) BUCKET3_LINE_CNT,
sum(mv.bucket4_line_cnt) BUCKET4_LINE_CNT,
sum(mv.bucket5_line_cnt) BUCKET5_LINE_CNT,
sum(mv.bucket6_line_cnt) BUCKET6_LINE_CNT,
sum(mv.bucket7_line_cnt) BUCKET7_LINE_CNT,
sum(mv.bucket8_line_cnt) BUCKET8_LINE_CNT,
sum(mv.bucket9_line_cnt) BUCKET9_LINE_CNT,
sum(mv.bucket10_line_cnt) BUCKET10_LINE_CNT,
count(mv.bucket1_line_cnt) BUCKET1_LINE_CNT_C,
count(mv.bucket2_line_cnt) BUCKET2_LINE_CNT_C,
count(mv.bucket3_line_cnt) BUCKET3_LINE_CNT_C,
count(mv.bucket4_line_cnt) BUCKET4_LINE_CNT_C,
count(mv.bucket5_line_cnt) BUCKET5_LINE_CNT_C,
count(mv.bucket6_line_cnt) BUCKET6_LINE_CNT_C,
count(mv.bucket7_line_cnt) BUCKET7_LINE_CNT_C,
count(mv.bucket8_line_cnt) BUCKET8_LINE_CNT_C,
count(mv.bucket9_line_cnt) BUCKET9_LINE_CNT_C,
count(mv.bucket10_line_cnt) BUCKET10_LINE_CNT_C,
sum(mv.bucket1_days_late) BUCKET1_DAYS_LATE,
sum(mv.bucket2_days_late) BUCKET2_DAYS_LATE,
sum(mv.bucket3_days_late) BUCKET3_DAYS_LATE,
sum(mv.bucket4_days_late) BUCKET4_DAYS_LATE,
sum(mv.bucket5_days_late) BUCKET5_DAYS_LATE,
sum(mv.bucket6_days_late) BUCKET6_DAYS_LATE,
sum(mv.bucket7_days_late) BUCKET7_DAYS_LATE,
sum(mv.bucket8_days_late) BUCKET8_DAYS_LATE,
sum(mv.bucket9_days_late) BUCKET9_DAYS_LATE,
sum(mv.bucket10_days_late) BUCKET10_DAYS_LATE,
count(mv.bucket1_days_late) BUCKET1_DAYS_LATE_C,
count(mv.bucket2_days_late) BUCKET2_DAYS_LATE_C,
count(mv.bucket3_days_late) BUCKET3_DAYS_LATE_C,
count(mv.bucket4_days_late) BUCKET4_DAYS_LATE_C,
count(mv.bucket5_days_late) BUCKET5_DAYS_LATE_C,
count(mv.bucket6_days_late) BUCKET6_DAYS_LATE_C,
count(mv.bucket7_days_late) BUCKET7_DAYS_LATE_C,
count(mv.bucket8_days_late) BUCKET8_DAYS_LATE_C,
count(mv.bucket9_days_late) BUCKET9_DAYS_LATE_C,
count(mv.bucket10_days_late) BUCKET10_DAYS_LATE_C,
sum(mv.bucket1_qty) BUCKET1_QTY,
sum(mv.bucket2_qty) BUCKET2_QTY,
sum(mv.bucket3_qty) BUCKET3_QTY,
sum(mv.bucket4_qty) BUCKET4_QTY,
sum(mv.bucket5_qty) BUCKET5_QTY,
sum(mv.bucket6_qty) BUCKET6_QTY,
sum(mv.bucket7_qty) BUCKET7_QTY,
sum(mv.bucket8_qty) BUCKET8_QTY,
sum(mv.bucket9_qty) BUCKET9_QTY,
sum(mv.bucket10_qty) BUCKET10_QTY,
count(mv.bucket1_qty) BUCKET1_QTY_C,
count(mv.bucket2_qty) BUCKET2_QTY_C,
count(mv.bucket3_qty) BUCKET3_QTY_C,
count(mv.bucket4_qty) BUCKET4_QTY_C,
count(mv.bucket5_qty) BUCKET5_QTY_C,
count(mv.bucket6_qty) BUCKET6_QTY_C,
count(mv.bucket7_qty) BUCKET7_QTY_C,
count(mv.bucket8_qty) BUCKET8_QTY_C,
count(mv.bucket9_qty) BUCKET9_QTY_C,
count(mv.bucket10_qty) BUCKET10_QTY_C,
sum(mv.bucket1_pdue_amt_f) BUCKET1_PDUE_AMT_F,
sum(mv.bucket2_pdue_amt_f) BUCKET2_PDUE_AMT_F,
sum(mv.bucket3_pdue_amt_f) BUCKET3_PDUE_AMT_F,
sum(mv.bucket4_pdue_amt_f) BUCKET4_PDUE_AMT_F,
sum(mv.bucket5_pdue_amt_f) BUCKET5_PDUE_AMT_F,
sum(mv.bucket6_pdue_amt_f) BUCKET6_PDUE_AMT_F,
sum(mv.bucket7_pdue_amt_f) BUCKET7_PDUE_AMT_F,
sum(mv.bucket8_pdue_amt_f) BUCKET8_PDUE_AMT_F,
sum(mv.bucket9_pdue_amt_f) BUCKET9_PDUE_AMT_F,
sum(mv.bucket10_pdue_amt_f) BUCKET10_PDUE_AMT_F,
count(mv.bucket1_pdue_amt_f) BUCKET1_PDUE_AMT_F_C,
count(mv.bucket2_pdue_amt_f) BUCKET2_PDUE_AMT_F_C,
count(mv.bucket3_pdue_amt_f) BUCKET3_PDUE_AMT_F_C,
count(mv.bucket4_pdue_amt_f) BUCKET4_PDUE_AMT_F_C,
count(mv.bucket5_pdue_amt_f) BUCKET5_PDUE_AMT_F_C,
count(mv.bucket6_pdue_amt_f) BUCKET6_PDUE_AMT_F_C,
count(mv.bucket7_pdue_amt_f) BUCKET7_PDUE_AMT_F_C,
count(mv.bucket8_pdue_amt_f) BUCKET8_PDUE_AMT_F_C,
count(mv.bucket9_pdue_amt_f) BUCKET9_PDUE_AMT_F_C,
count(mv.bucket10_pdue_amt_f) BUCKET10_PDUE_AMT_F_C,
sum(mv.bucket1_pdue_amt_g) BUCKET1_PDUE_AMT_G,
sum(mv.bucket2_pdue_amt_g) BUCKET2_PDUE_AMT_G,
sum(mv.bucket3_pdue_amt_g) BUCKET3_PDUE_AMT_G,
sum(mv.bucket4_pdue_amt_g) BUCKET4_PDUE_AMT_G,
sum(mv.bucket5_pdue_amt_g) BUCKET5_PDUE_AMT_G,
sum(mv.bucket6_pdue_amt_g) BUCKET6_PDUE_AMT_G,
sum(mv.bucket7_pdue_amt_g) BUCKET7_PDUE_AMT_G,
sum(mv.bucket8_pdue_amt_g) BUCKET8_PDUE_AMT_G,
sum(mv.bucket9_pdue_amt_g) BUCKET9_PDUE_AMT_G,
sum(mv.bucket10_pdue_amt_g) BUCKET10_PDUE_AMT_G,
count(mv.bucket1_pdue_amt_g) BUCKET1_PDUE_AMT_G_C,
count(mv.bucket2_pdue_amt_g) BUCKET2_PDUE_AMT_G_C,
count(mv.bucket3_pdue_amt_g) BUCKET3_PDUE_AMT_G_C,
count(mv.bucket4_pdue_amt_g) BUCKET4_PDUE_AMT_G_C,
count(mv.bucket5_pdue_amt_g) BUCKET5_PDUE_AMT_G_C,
count(mv.bucket6_pdue_amt_g) BUCKET6_PDUE_AMT_G_C,
count(mv.bucket7_pdue_amt_g) BUCKET7_PDUE_AMT_G_C,
count(mv.bucket8_pdue_amt_g) BUCKET8_PDUE_AMT_G_C,
count(mv.bucket9_pdue_amt_g) BUCKET9_PDUE_AMT_G_C,
count(mv.bucket10_pdue_amt_g) BUCKET10_PDUE_AMT_G_C,
sum(mv.bucket1_pdue_amt_g1) BUCKET1_PDUE_AMT_G1,
sum(mv.bucket2_pdue_amt_g1) BUCKET2_PDUE_AMT_G1,
sum(mv.bucket3_pdue_amt_g1) BUCKET3_PDUE_AMT_G1,
sum(mv.bucket4_pdue_amt_g1) BUCKET4_PDUE_AMT_G1,
sum(mv.bucket5_pdue_amt_g1) BUCKET5_PDUE_AMT_G1,
sum(mv.bucket6_pdue_amt_g1) BUCKET6_PDUE_AMT_G1,
sum(mv.bucket7_pdue_amt_g1) BUCKET7_PDUE_AMT_G1,
sum(mv.bucket8_pdue_amt_g1) BUCKET8_PDUE_AMT_G1,
sum(mv.bucket9_pdue_amt_g1) BUCKET9_PDUE_AMT_G1,
sum(mv.bucket10_pdue_amt_g1) BUCKET10_PDUE_AMT_G1,
count(mv.bucket1_pdue_amt_g1) BUCKET1_PDUE_AMT_G1_C,
count(mv.bucket2_pdue_amt_g1) BUCKET2_PDUE_AMT_G1_C,
count(mv.bucket3_pdue_amt_g1) BUCKET3_PDUE_AMT_G1_C,
count(mv.bucket4_pdue_amt_g1) BUCKET4_PDUE_AMT_G1_C,
count(mv.bucket5_pdue_amt_g1) BUCKET5_PDUE_AMT_G1_C,
count(mv.bucket6_pdue_amt_g1) BUCKET6_PDUE_AMT_G1_C,
count(mv.bucket7_pdue_amt_g1) BUCKET7_PDUE_AMT_G1_C,
count(mv.bucket8_pdue_amt_g1) BUCKET8_PDUE_AMT_G1_C,
count(mv.bucket9_pdue_amt_g1) BUCKET9_PDUE_AMT_G1_C,
count(mv.bucket10_pdue_amt_g1) BUCKET10_PDUE_AMT_G1_C,
sum(mv.bucket1_line_cnt_p) BUCKET1_LINE_CNT_P,
sum(mv.bucket2_line_cnt_p) BUCKET2_LINE_CNT_P,
sum(mv.bucket3_line_cnt_p) BUCKET3_LINE_CNT_P,
sum(mv.bucket4_line_cnt_p) BUCKET4_LINE_CNT_P,
sum(mv.bucket5_line_cnt_p) BUCKET5_LINE_CNT_P,
sum(mv.bucket6_line_cnt_p) BUCKET6_LINE_CNT_P,
sum(mv.bucket7_line_cnt_p) BUCKET7_LINE_CNT_P,
sum(mv.bucket8_line_cnt_p) BUCKET8_LINE_CNT_P,
sum(mv.bucket9_line_cnt_p) BUCKET9_LINE_CNT_P,
sum(mv.bucket10_line_cnt_p) BUCKET10_LINE_CNT_P,
count(mv.bucket1_line_cnt_p) BUCKET1_LINE_CNT_P_C,
count(mv.bucket2_line_cnt_p) BUCKET2_LINE_CNT_P_C,
count(mv.bucket3_line_cnt_p) BUCKET3_LINE_CNT_P_C,
count(mv.bucket4_line_cnt_p) BUCKET4_LINE_CNT_P_C,
count(mv.bucket5_line_cnt_p) BUCKET5_LINE_CNT_P_C,
count(mv.bucket6_line_cnt_p) BUCKET6_LINE_CNT_P_C,
count(mv.bucket7_line_cnt_p) BUCKET7_LINE_CNT_P_C,
count(mv.bucket8_line_cnt_p) BUCKET8_LINE_CNT_P_C,
count(mv.bucket9_line_cnt_p) BUCKET9_LINE_CNT_P_C,
count(mv.bucket10_line_cnt_p) BUCKET10_LINE_CNT_P_C,
sum(mv.bucket1_days_late_p) BUCKET1_DAYS_LATE_P,
sum(mv.bucket2_days_late_p) BUCKET2_DAYS_LATE_P,
sum(mv.bucket3_days_late_p) BUCKET3_DAYS_LATE_P,
sum(mv.bucket4_days_late_p) BUCKET4_DAYS_LATE_P,
sum(mv.bucket5_days_late_p) BUCKET5_DAYS_LATE_P,
sum(mv.bucket6_days_late_p) BUCKET6_DAYS_LATE_P,
sum(mv.bucket7_days_late_p) BUCKET7_DAYS_LATE_P,
sum(mv.bucket8_days_late_p) BUCKET8_DAYS_LATE_P,
sum(mv.bucket9_days_late_p) BUCKET9_DAYS_LATE_P,
sum(mv.bucket10_days_late_p) BUCKET10_DAYS_LATE_P,
count(mv.bucket1_days_late_p) BUCKET1_DAYS_LATE_P_C,
count(mv.bucket2_days_late_p) BUCKET2_DAYS_LATE_P_C,
count(mv.bucket3_days_late_p) BUCKET3_DAYS_LATE_P_C,
count(mv.bucket4_days_late_p) BUCKET4_DAYS_LATE_P_C,
count(mv.bucket5_days_late_p) BUCKET5_DAYS_LATE_P_C,
count(mv.bucket6_days_late_p) BUCKET6_DAYS_LATE_P_C,
count(mv.bucket7_days_late_p) BUCKET7_DAYS_LATE_P_C,
count(mv.bucket8_days_late_p) BUCKET8_DAYS_LATE_P_C,
count(mv.bucket9_days_late_p) BUCKET9_DAYS_LATE_P_C,
count(mv.bucket10_days_late_p) BUCKET10_DAYS_LATE_P_C,
sum(mv.bucket1_qty_p) BUCKET1_QTY_P,
sum(mv.bucket2_qty_p) BUCKET2_QTY_P,
sum(mv.bucket3_qty_p) BUCKET3_QTY_P,
sum(mv.bucket4_qty_p) BUCKET4_QTY_P,
sum(mv.bucket5_qty_p) BUCKET5_QTY_P,
sum(mv.bucket6_qty_p) BUCKET6_QTY_P,
sum(mv.bucket7_qty_p) BUCKET7_QTY_P,
sum(mv.bucket8_qty_p) BUCKET8_QTY_P,
sum(mv.bucket9_qty_p) BUCKET9_QTY_P,
sum(mv.bucket10_qty_p) BUCKET10_QTY_P,
count(mv.bucket1_qty_p) BUCKET1_QTY_P_C,
count(mv.bucket2_qty_p) BUCKET2_QTY_P_C,
count(mv.bucket3_qty_p) BUCKET3_QTY_P_C,
count(mv.bucket4_qty_p) BUCKET4_QTY_P_C,
count(mv.bucket5_qty_p) BUCKET5_QTY_P_C,
count(mv.bucket6_qty_p) BUCKET6_QTY_P_C,
count(mv.bucket7_qty_p) BUCKET7_QTY_P_C,
count(mv.bucket8_qty_p) BUCKET8_QTY_P_C,
count(mv.bucket9_qty_p) BUCKET9_QTY_P_C,
count(mv.bucket10_qty_p) BUCKET10_QTY_P_C,
sum(mv.bucket1_pdue_amt_f_p) BUCKET1_PDUE_AMT_F_P,
sum(mv.bucket2_pdue_amt_f_p) BUCKET2_PDUE_AMT_F_P,
sum(mv.bucket3_pdue_amt_f_p) BUCKET3_PDUE_AMT_F_P,
sum(mv.bucket4_pdue_amt_f_p) BUCKET4_PDUE_AMT_F_P,
sum(mv.bucket5_pdue_amt_f_p) BUCKET5_PDUE_AMT_F_P,
sum(mv.bucket6_pdue_amt_f_p) BUCKET6_PDUE_AMT_F_P,
sum(mv.bucket7_pdue_amt_f_p) BUCKET7_PDUE_AMT_F_P,
sum(mv.bucket8_pdue_amt_f_p) BUCKET8_PDUE_AMT_F_P,
sum(mv.bucket9_pdue_amt_f_p) BUCKET9_PDUE_AMT_F_P,
sum(mv.bucket10_pdue_amt_f_p) BUCKET10_PDUE_AMT_F_P,
count(mv.bucket1_pdue_amt_f_p) BUCKET1_PDUE_AMT_F_P_C,
count(mv.bucket2_pdue_amt_f_p) BUCKET2_PDUE_AMT_F_P_C,
count(mv.bucket3_pdue_amt_f_p) BUCKET3_PDUE_AMT_F_P_C,
count(mv.bucket4_pdue_amt_f_p) BUCKET4_PDUE_AMT_F_P_C,
count(mv.bucket5_pdue_amt_f_p) BUCKET5_PDUE_AMT_F_P_C,
count(mv.bucket6_pdue_amt_f_p) BUCKET6_PDUE_AMT_F_P_C,
count(mv.bucket7_pdue_amt_f_p) BUCKET7_PDUE_AMT_F_P_C,
count(mv.bucket8_pdue_amt_f_p) BUCKET8_PDUE_AMT_F_P_C,
count(mv.bucket9_pdue_amt_f_p) BUCKET9_PDUE_AMT_F_P_C,
count(mv.bucket10_pdue_amt_f_p) BUCKET10_PDUE_AMT_F_P_C,
sum(mv.bucket1_pdue_amt_g_p) BUCKET1_PDUE_AMT_G_P,
sum(mv.bucket2_pdue_amt_g_p) BUCKET2_PDUE_AMT_G_P,
sum(mv.bucket3_pdue_amt_g_p) BUCKET3_PDUE_AMT_G_P,
sum(mv.bucket4_pdue_amt_g_p) BUCKET4_PDUE_AMT_G_P,
sum(mv.bucket5_pdue_amt_g_p) BUCKET5_PDUE_AMT_G_P,
sum(mv.bucket6_pdue_amt_g_p) BUCKET6_PDUE_AMT_G_P,
sum(mv.bucket7_pdue_amt_g_p) BUCKET7_PDUE_AMT_G_P,
sum(mv.bucket8_pdue_amt_g_p) BUCKET8_PDUE_AMT_G_P,
sum(mv.bucket9_pdue_amt_g_p) BUCKET9_PDUE_AMT_G_P,
sum(mv.bucket10_pdue_amt_g_p) BUCKET10_PDUE_AMT_G_P,
count(mv.bucket1_pdue_amt_g_p) BUCKET1_PDUE_AMT_G_P_C,
count(mv.bucket2_pdue_amt_g_p) BUCKET2_PDUE_AMT_G_P_C,
count(mv.bucket3_pdue_amt_g_p) BUCKET3_PDUE_AMT_G_P_C,
count(mv.bucket4_pdue_amt_g_p) BUCKET4_PDUE_AMT_G_P_C,
count(mv.bucket5_pdue_amt_g_p) BUCKET5_PDUE_AMT_G_P_C,
count(mv.bucket6_pdue_amt_g_p) BUCKET6_PDUE_AMT_G_P_C,
count(mv.bucket7_pdue_amt_g_p) BUCKET7_PDUE_AMT_G_P_C,
count(mv.bucket8_pdue_amt_g_p) BUCKET8_PDUE_AMT_G_P_C,
count(mv.bucket9_pdue_amt_g_p) BUCKET9_PDUE_AMT_G_P_C,
count(mv.bucket10_pdue_amt_g_p) BUCKET10_PDUE_AMT_G_P_C,
sum(mv.bucket1_pdue_amt_g1_p) BUCKET1_PDUE_AMT_G1_P,
sum(mv.bucket2_pdue_amt_g1_p) BUCKET2_PDUE_AMT_G1_P,
sum(mv.bucket3_pdue_amt_g1_p) BUCKET3_PDUE_AMT_G1_P,
sum(mv.bucket4_pdue_amt_g1_p) BUCKET4_PDUE_AMT_G1_P,
sum(mv.bucket5_pdue_amt_g1_p) BUCKET5_PDUE_AMT_G1_P,
sum(mv.bucket6_pdue_amt_g1_p) BUCKET6_PDUE_AMT_G1_P,
sum(mv.bucket7_pdue_amt_g1_p) BUCKET7_PDUE_AMT_G1_P,
sum(mv.bucket8_pdue_amt_g1_p) BUCKET8_PDUE_AMT_G1_P,
sum(mv.bucket9_pdue_amt_g1_p) BUCKET9_PDUE_AMT_G1_P,
sum(mv.bucket10_pdue_amt_g1_p) BUCKET10_PDUE_AMT_G1_P,
count(mv.bucket1_pdue_amt_g1_p) BUCKET1_PDUE_AMT_G1_P_C,
count(mv.bucket2_pdue_amt_g1_p) BUCKET2_PDUE_AMT_G1_P_C,
count(mv.bucket3_pdue_amt_g1_p) BUCKET3_PDUE_AMT_G1_P_C,
count(mv.bucket4_pdue_amt_g1_p) BUCKET4_PDUE_AMT_G1_P_C,
count(mv.bucket5_pdue_amt_g1_p) BUCKET5_PDUE_AMT_G1_P_C,
count(mv.bucket6_pdue_amt_g1_p) BUCKET6_PDUE_AMT_G1_P_C,
count(mv.bucket7_pdue_amt_g1_p) BUCKET7_PDUE_AMT_G1_P_C,
count(mv.bucket8_pdue_amt_g1_p) BUCKET8_PDUE_AMT_G1_P_C,
count(mv.bucket9_pdue_amt_g1_p) BUCKET9_PDUE_AMT_G1_P_C,
count(mv.bucket10_pdue_amt_g1_p) BUCKET10_PDUE_AMT_G1_P_C,
count(*) CNT
FROM isc_dbi_cfm_008_mv mv
WHERE mv.item_category_id is NULL
GROUP BY mv.inv_org_id,
mv.time_snapshot_date_id,
mv.late_schedule_flag,
mv.late_promise_flag