MATERIALIZED VIEW: APPS.FII_AP_LIA_IB_MV

Source

select /* 12.0: bug#4526784 */ f.org_id org_id,
        f.supplier_id supplier_id,
        f.time_id,
        f.period_type_id,
        grouping_id(f.org_id, f.supplier_id, f.time_id, f.period_type_id) gid,
        count(*) count_all,
        sum(f.open_amt_b) open_amt_b,
        count(f.open_amt_b) open_amt_b_cnt,
        sum(f.open_amt_prim_g) open_amt_prim_g,
        count(f.open_amt_prim_g) open_amt_prim_g_cnt,
        sum(f.open_amt_sec_g) open_amt_sec_g,
        count(f.open_amt_sec_g) open_amt_sec_g_cnt,
        sum(f.open_count) open_count,
        count(f.open_count) open_count_cnt,
        sum(f.open_due_count) open_due_count,
        count(f.open_due_count) open_due_count_cnt,
        sum(f.open_past_due_amt_b) open_past_due_amt_b,
        count(f.open_past_due_amt_b) open_past_due_amt_b_cnt,
        sum(f.open_past_due_amt_prim_g) open_past_due_amt_prim_g,
        count(f.open_past_due_amt_prim_g) open_past_due_amt_prim_g_cnt,
        sum(f.open_past_due_amt_sec_g) open_past_due_amt_sec_g,
        count(f.open_past_due_amt_sec_g) open_past_due_amt_sec_g_cnt,
        sum(f.open_past_due_count) open_past_due_count,
        count(f.open_past_due_count) open_past_due_count_cnt,
        sum(f.open_payment_amt_b) open_payment_amt_b,
        count(f.open_payment_amt_b) open_payment_amt_b_cnt,
        sum(f.open_payment_amt_prim_g) open_payment_amt_prim_g,
        count(f.open_payment_amt_prim_g) open_payment_amt_prim_g_cnt,
        sum(f.open_payment_amt_sec_g) open_payment_amt_sec_g,
        count(f.open_payment_amt_sec_g) open_payment_amt_sec_g_cnt,
        sum(f.open_discount_offered_b) open_discount_offered_b,
        count(f.open_discount_offered_b) open_discount_offered_b_cnt,
        sum(f.open_discount_offered_prim_g) open_discount_offered_prim_g,
        count(f.open_discount_offered_prim_g) open_dis_offered_prim_g_cnt,
        sum(f.open_discount_offered_sec_g) open_discount_offered_sec_g,
        count(f.open_discount_offered_sec_g) open_dis_offered_sec_g_cnt,
        sum(f.open_discount_remaining_b) open_discount_remaining_b,
        count(f.open_discount_remaining_b) open_dis_remaining_b_cnt,
        sum(f.open_discount_remaining_prim_g) open_discount_remaining_prim_g,
        count(f.open_discount_remaining_prim_g) open_dis_remaining_prim_g_cnt,
        sum(f.open_discount_remaining_sec_g) open_discount_remaining_sec_g,
        count(f.open_discount_remaining_sec_g) open_dis_remaining_sec_g_cnt,
        sum(f.open_discount_taken_b) open_discount_taken_b,
        count(f.open_discount_taken_b) open_dis_taken_b_cnt,
        sum(f.open_discount_taken_prim_g) open_discount_taken_prim_g,
        count(f.open_discount_taken_prim_g) open_dis_taken_prim_g_cnt,
        sum(f.open_discount_taken_sec_g) open_discount_taken_sec_g,
        count(f.open_discount_taken_sec_g) open_dis_taken_sec_g_cnt,
        sum(f.open_discount_lost_b) open_discount_lost_b,
        count(f.open_discount_lost_b) open_dis_lost_b_cnt,
        sum(f.open_discount_lost_prim_g) open_discount_lost_prim_g,
        count(f.open_discount_lost_prim_g) open_dis_lost_prim_g_cnt,
        sum(f.open_discount_lost_sec_g) open_discount_lost_sec_g,
        count(f.open_discount_lost_sec_g) open_dis_lost_sec_g_cnt,
        sum(f.open_due_bucket1_b) open_due_bucket1_b,
        count(f.open_due_bucket1_b) open_due_bkt1_b_cnt,
        sum(f.open_due_bucket1_prim_g) open_due_bucket1_prim_g,
        count(f.open_due_bucket1_prim_g) open_due_bkt1_prim_g_cnt,
        sum(f.open_due_bucket1_sec_g) open_due_bucket1_sec_g,
        count(f.open_due_bucket1_sec_g) open_due_bkt1_sec_g_cnt,
        sum(f.open_due_bucket1_count) open_due_bucket1_count,
        count(f.open_due_bucket1_count) open_due_bkt1_count_cnt,
        sum(f.open_due_bucket2_b) open_due_bucket2_b,
        count(f.open_due_bucket2_b) open_due_bkt2_b_cnt,
        sum(f.open_due_bucket2_prim_g) open_due_bucket2_prim_g,
        count(f.open_due_bucket2_prim_g) open_due_bkt2_prim_g_cnt,
        sum(f.open_due_bucket2_sec_g) open_due_bucket2_sec_g,
        count(f.open_due_bucket2_sec_g) open_due_bkt2_sec_g_cnt,
        sum(f.open_due_bucket2_count) open_due_bucket2_count,
        count(f.open_due_bucket2_count) open_due_bkt2_count_cnt,
        sum(f.open_due_bucket3_b) open_due_bucket3_b,
        count(f.open_due_bucket3_b) open_due_bkt3_b_cnt,
        sum(f.open_due_bucket3_prim_g) open_due_bucket3_prim_g,
        count(f.open_due_bucket3_prim_g) open_due_bkt3_prim_g_cnt,
        sum(f.open_due_bucket3_sec_g) open_due_bucket3_sec_g,
        count(f.open_due_bucket3_sec_g) open_due_bkt3_sec_g_cnt,
        sum(f.open_due_bucket3_count) open_due_bucket3_count,
        count(f.open_due_bucket3_count) open_due_bkt3_count_cnt,
        sum(f.open_past_due_bucket1_b) open_past_due_bucket1_b,
        count(f.open_past_due_bucket1_b) open_past_due_bkt1_b_cnt,
        sum(f.open_past_due_bucket1_prim_g) open_past_due_bucket1_prim_g,
        count(f.open_past_due_bucket1_prim_g) open_past_due_bkt1_prim_g_cnt,
        sum(f.open_past_due_bucket1_sec_g) open_past_due_bucket1_sec_g,
        count(f.open_past_due_bucket1_sec_g) open_past_due_bkt1_sec_g_cnt,
        sum(f.open_past_due_bucket1_count) open_past_due_bucket1_count,
        count(f.open_past_due_bucket1_count) open_past_due_bkt1_count_cnt,
        sum(f.open_past_due_bucket2_b) open_past_due_bucket2_b,
        count(f.open_past_due_bucket2_b) open_past_due_bkt2_b_cnt,
        sum(f.open_past_due_bucket2_prim_g) open_past_due_bucket2_prim_g,
        count(f.open_past_due_bucket2_prim_g) open_past_due_bkt2_prim_g_cnt,
        sum(f.open_past_due_bucket2_sec_g) open_past_due_bucket2_sec_g,
        count(f.open_past_due_bucket2_sec_g) open_past_due_bkt2_sec_g_cnt,
        sum(f.open_past_due_bucket2_count) open_past_due_bucket2_count,
        count(f.open_past_due_bucket2_count) open_past_due_bkt2_count_cnt,
        sum(f.open_past_due_bucket3_b) open_past_due_bucket3_b,
        count(f.open_past_due_bucket3_b) open_past_due_bkt3_b_cnt,
        sum(f.open_past_due_bucket3_prim_g) open_past_due_bucket3_prim_g,
        count(f.open_past_due_bucket3_prim_g) open_past_due_bkt3_prim_g_cnt,
        sum(f.open_past_due_bucket3_sec_g) open_past_due_bucket3_sec_g,
        count(f.open_past_due_bucket3_sec_g) open_past_due_bkt3_sec_g_cnt,
        sum(f.open_past_due_bucket3_count) open_past_due_bucket3_count,
        count(f.open_past_due_bucket3_count) open_past_due_bkt3_count_cnt,
        sum(f.on_time_payment_amt_b) on_time_payment_amt_b,
        count(f.on_time_payment_amt_b) on_time_payment_amt_b_cnt,
        sum(f.on_time_payment_amt_prim_g) on_time_payment_amt_prim_g,
        count(f.on_time_payment_amt_prim_g) on_time_payment_amt_prim_g_cnt,
        sum(f.on_time_payment_amt_sec_g) on_time_payment_amt_sec_g,
        count(f.on_time_payment_amt_sec_g) on_time_payment_amt_sec_g_cnt,
        sum(f.late_payment_amt_b) late_payment_amt_b,
        count(f.late_payment_amt_b) late_payment_amt_b_cnt,
        sum(f.late_payment_amt_prim_g) late_payment_amt_prim_g,
        count(f.late_payment_amt_prim_g) late_payment_amt_prim_g_cnt,
        sum(f.late_payment_amt_sec_g) late_payment_amt_sec_g,
        count(f.late_payment_amt_sec_g) late_payment_amt_sec_g_cnt,
        sum(wt_open_due_amt_b)  wt_open_due_amt_b,
        count(wt_open_due_amt_b)  wt_open_due_amt_b_cnt,
        sum(wt_open_due_amt_prim_g)  wt_open_due_amt_prim_g,
        count(wt_open_due_amt_prim_g)  wt_open_due_amt_prim_g_cnt,
        sum(wt_open_due_amt_sec_g)   wt_open_due_amt_sec_g,
        count(wt_open_due_amt_sec_g)   wt_open_due_amt_sec_g_cnt,
        sum(wt_open_past_due_amt_b)  wt_open_past_due_amt_b,
        count(wt_open_past_due_amt_b)  wt_open_past_due_amt_b_cnt,
        sum(wt_open_past_due_amt_prim_g) wt_open_past_due_amt_prim_g,
        count(wt_open_past_due_amt_prim_g) wt_op_past_due_amt_prim_g_cnt,
        sum(wt_open_past_due_amt_sec_g)  wt_open_past_due_amt_sec_g,
        count(wt_open_past_due_amt_sec_g)  wt_open_past_due_amt_sec_g_cnt
  from FII_AP_LIA_I_MV f
  group by
           grouping sets (
                        (org_id, supplier_id, time_id, period_type_id),
                        (org_id, time_id, period_type_id)
                        )