[Home] [Help]
MATERIALIZED VIEW: APPS.FII_GL_MGMT_CCC_MV
Source
SELECT /* 12.0: bug#4526784 */ b.time_id, b.period_type_id, b.manager_id, b.cost_center_org_id, sum(actual_b) ACTUAL_B, sum(prim_actual_g) PRIM_ACTUAL_G, sum(sec_actual_g) SEC_ACTUAL_G, b.line_of_business_id, fin.parent_fin_cat_id PARENT_FIN_CATEGORY_ID, fin.next_level_fin_cat_id FIN_CATEGORY_ID, sum(prim_budget_g) PRIM_BUDGET_G, sum(sec_budget_g) SEC_BUDGET_G, sum(prim_forecast_g) PRIM_FORECAST_G, sum(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(prim_budget_g) PRIM_BUDGET_GCT, count(sec_budget_g) SEC_BUDGET_GCT, count(prim_forecast_g) PRIM_FORECAST_GCT, count(sec_forecast_g) SEC_FORECAST_GCT, count(*) CT FROM fii_gl_base_mv b, FII.FII_FIN_ITEM_HIERARCHIES fin where b.fin_category_id = fin.CHILD_fin_cat_id and fin.is_leaf_flag = 'N' GROUP BY b.time_id, b.period_type_id, b.manager_id, b.cost_center_org_id, b.line_of_business_id, fin.parent_fin_cat_id, fin.next_level_fin_cat_id