MATERIALIZED VIEW: APPS.BIM_I_BGT_CAB_MV

Source

SELECT /* Dummy Comment */ a.transaction_create_date transaction_create_date
      ,a.fund_id fund_id
      ,a.parent_fund_id parent_fund_id
      ,b.object_id category_id
      ,b.parent_object_id parent_category_id
      ,b.leaf_node_flag leaf_node_flag
      ,sum(a.original_budget) original_budget
      ,count(a.original_budget) original_budget_c
      ,sum(a.holdback_amt) holdback
      ,count(a.holdback_amt) holdback_c
      ,sum(a.transfer_in) transfer_in
      ,count(a.transfer_in) transfer_in_c
      ,sum(a.transfer_out) transfer_out
      ,count(a.transfer_out) transfer_out_c
      ,sum(a.accrual) accrual
      ,count(a.accrual) accrual_c
      ,sum(a.committed) committed
      ,count(a.committed) committed_c
      ,sum(a.planned) planned
      ,count(a.planned) planned_c
      ,sum(a.utilized) utilized
      ,count(a.utilized) utilized_c
      ,sum(a.original_budget_s) original_budget_s
      ,count(a.original_budget_s) original_budget_s_c
      ,sum(holdback_amt_s) holdback_s
      ,count(holdback_amt_s) holdback_s_c
      ,sum(a.transfer_in_s) transfer_in_s
      ,count(a.transfer_in_s) transfer_in_s_c
      ,sum(a.transfer_out_s) transfer_out_s
      ,count(a.transfer_out_s) transfer_out_s_c
      ,sum(a.accrual_s) accrual_s
      ,count(a.accrual_s) accrual_s_c
      ,sum(a.committed_s) committed_s
      ,count(a.committed_s) committed_s_c
      ,sum(a.planned_s) planned_s
      ,count(a.planned_s) planned_s_c
      ,sum(a.utilized_s) utilized_s
      ,count(a.utilized_s) utilized_s_c
      ,count(*) count_all
FROM BIM.BIM_I_BUDGET_FACTS a,
     BIM.BIM_I_BUDGETS_DENORM b
WHERE b.object_type='CATEGORY'
AND a.category_id = b.child_denorm_id
group by a.transaction_create_date,b.object_id,b.parent_object_id,a.fund_id, a.parent_fund_id,b.leaf_node_flag