MATERIALIZED VIEW: APPS.FII_GL_AGRT_SUM2_MV

Source

SELECT b.time_id		      TIME_ID,         b.period_type_id	      PERIOD_TYPE_ID,         b.ledger_id    	      LEDGER_ID,         b.fin_cat_type_code          fin_cat_type_code,        fin.PARENT_FIN_CAT_ID	      PARENT_FIN_CATEGORY_ID,         fin.NEXT_LEVEL_FIN_CAT_ID    FIN_CATEGORY_ID,         com.PARENT_COMPANY_ID	      PARENT_COMPANY_DIM_ID,         com.NEXT_LEVEL_COMPANY_ID    COMPANY_DIM_ID,         cc.PARENT_CC_ID	      PARENT_COST_CENTER_DIM_ID,         cc.NEXT_LEVEL_CC_ID          COST_CENTER_DIM_ID,         SUM(b.ACTUAL_B)              ACTUAL_B,         SUM(b.PRIM_ACTUAL_G)         PRIM_ACTUAL_G,         SUM(b.SEC_ACTUAL_G)          SEC_ACTUAL_G,         SUM(b.PRIM_BUDGET_G)         PRIM_BUDGET_G,         SUM(b.SEC_BUDGET_G)          SEC_BUDGET_G,         SUM(b.PRIM_FORECAST_G)       PRIM_FORECAST_G,         SUM(b.SEC_FORECAST_G)        SEC_FORECAST_G,         count(b.ACTUAL_B)            ACTUAL_BCT,         count(b.PRIM_ACTUAL_G)       PRIM_ACTUAL_GCT,         count(b.SEC_ACTUAL_G)        SEC_ACTUAL_GCT,         count(b.PRIM_BUDGET_G)       PRIM_BUDGET_GCT,         count(b.SEC_BUDGET_G)        SEC_BUDGET_GCT,         count(b.PRIM_FORECAST_G)      PRIM_FORECAST_GCT,         count(b.SEC_FORECAST_G)      SEC_FORECAST_GCT,         count(*)                     CT   FROM  fii_gl_base_map2_mv           b,         FII.FII_FIN_ITEM_LEAF_HIERS  fin,         FII.FII_COMPANY_HIERARCHIES  com,         FII.FII_COST_CTR_HIERARCHIES cc   WHERE b.fin_category_id     = fin.child_fin_cat_id   AND   b.company_dim_id      = com.child_company_id   AND   b.cost_center_dim_id  = cc.child_cc_id   GROUP BY         b.time_id,		               b.period_type_id,	               b.ledger_id,    	               b.fin_cat_type_code,                  fin.PARENT_FIN_CAT_ID,	               fin.NEXT_LEVEL_FIN_CAT_ID,            com.PARENT_COMPANY_ID,	               com.NEXT_LEVEL_COMPANY_ID,            cc.PARENT_CC_ID,	               cc.NEXT_LEVEL_CC_ID