eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

MATERIALIZED VIEW: APPS.FII_GL_AGRT_SUM_MV

Source


SELECT /* 12.0: bug#4526784 */ /*+ USE_HASH(ud1) */        b.time_id		      TIME_ID,         b.period_type_id	      PERIOD_TYPE_ID,         b.ledger_id    	      LEDGER_ID,         b.posted_date                POSTED_DATE,         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,         ud1.PARENT_VALUE_ID	      PARENT_USER_DIM1_ID,         ud1.NEXT_LEVEL_VALUE_ID      USER_DIM1_ID,         b.USER_DIM2_ID               USER_DIM2_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,   SUM(b.COMMITTED_AMOUNT_PRIM) COMMITTED_AMOUNT_PRIM,    SUM(b.OBLIGATED_AMOUNT_PRIM) OBLIGATED_AMOUNT_PRIM,    SUM(b.OTHER_AMOUNT_PRIM)     OTHER_AMOUNT_PRIM,    SUM(b.BASELINE_AMOUNT_PRIM)  BASELINE_AMOUNT_PRIM,          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(b.COMMITTED_AMOUNT_PRIM) COMMITTED_AMOUNT_PRIMCT,    count(b.OBLIGATED_AMOUNT_PRIM) OBLIGATED_AMOUNT_PRIMCT,    count(b.OTHER_AMOUNT_PRIM)     OTHER_AMOUNT_PRIMCT,    count(b.BASELINE_AMOUNT_PRIM)  BASELINE_AMOUNT_PRIMCT,          count(*)                     CT   FROM  fii_gl_base_map_mv           b,         FII.FII_FIN_ITEM_LEAF_HIERS  fin,         FII.FII_COMPANY_HIERARCHIES  com,         FII.FII_COST_CTR_HIERARCHIES cc,         FII.FII_UDD1_HIERARCHIES     ud1   WHERE b.PERIOD_TYPE_ID in (32, 64, 128)   AND   b.fin_category_id     = fin.child_fin_cat_id   AND   fin.is_leaf_flag              = 'N'   AND   fin.aggregate_next_level_flag = 'Y'   AND   b.company_dim_id      = com.child_company_id   AND   com.is_leaf_flag              = 'N'   AND   com.aggregate_next_level_flag = 'Y'   AND   b.cost_center_dim_id  = cc.child_cc_id   AND   cc.is_leaf_flag              = 'N'   AND   cc.aggregate_next_level_flag = 'Y'   AND   b.user_dim1_id    = ud1.child_value_id   AND   ud1.is_leaf_flag              = 'N'   AND   ud1.aggregate_next_level_flag = 'Y'   GROUP BY         b.time_id,		               b.period_type_id,	               b.ledger_id,    	               b.posted_date,    	               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,                  ud1.PARENT_VALUE_ID,	               ud1.NEXT_LEVEL_VALUE_ID,              b.USER_DIM2_ID