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.
MATERIALIZED VIEW: APPS.FII_GL_BASE_MAP_MV

Source


SELECT /* 12.0: bug#4526784 */       'ACTUAL'                    UMARKER,         b.time_id		      TIME_ID,         b.period_type_id	      PERIOD_TYPE_ID,         b.ledger_id                  LEDGER_ID,         b.posted_date    	      POSTED_DATE,         NULL    	              BUDGET_VERSION_DATE,         c.PARENT_FIN_CAT_ID	      FIN_CATEGORY_ID,         m.PARENT_COMPANY_DIM_ID      COMPANY_DIM_ID,         m.PARENT_COST_CENTER_DIM_ID  COST_CENTER_DIM_ID,         ud1.PARENT_USER_DIM1_ID      USER_DIM1_ID,         ud2.PARENT_USER_DIM2_ID      USER_DIM2_ID,         SUM(DECODE(a.fin_cat_type_code, 'R', b.amount_b, -b.amount_b)) ACTUAL_B,         SUM(DECODE(a.fin_cat_type_code, 'R', b.prim_amount_g,                                               -b.prim_amount_g))         PRIM_ACTUAL_G,         SUM(DECODE(a.fin_cat_type_code, 'R', b.sec_amount_g,                                               -b.sec_amount_g))          SEC_ACTUAL_G,  SUM(DECODE(a.fin_cat_type_code, 'R', b.committed_amount_prim, -b.committed_amount_prim)) COMMITTED_AMOUNT_PRIM,  SUM(DECODE(a.fin_cat_type_code, 'R', b.obligated_amount_prim, -b.obligated_amount_prim)) OBLIGATED_AMOUNT_PRIM,  SUM(DECODE(a.fin_cat_type_code, 'R', b.other_amount_prim, -b.other_amount_prim))         OTHER_AMOUNT_PRIM,         to_number(null)              PRIM_BUDGET_G,         to_number(null)              SEC_BUDGET_G,         to_number(null)              PRIM_FORECAST_G,         to_number(null)              SEC_FORECAST_G,         to_number(null)              BASELINE_AMOUNT_PRIM,         count(DECODE(a.fin_cat_type_code, 'R', b.amount_b, -b.amount_b))           ACTUAL_BCT,         count(DECODE(a.fin_cat_type_code, 'R', b.prim_amount_g, -b.prim_amount_g)) PRIM_ACTUAL_GCT,         count(DECODE(a.fin_cat_type_code, 'R', b.sec_amount_g,  -b.sec_amount_g))  SEC_ACTUAL_GCT,  count(DECODE(a.fin_cat_type_code, 'R', b.committed_amount_prim, -b.committed_amount_prim)) COMMITTED_AMOUNT_PRIMCT,  count(DECODE(a.fin_cat_type_code, 'R', b.obligated_amount_prim, -b.obligated_amount_prim)) OBLIGATED_AMOUNT_PRIMCT,  count(DECODE(a.fin_cat_type_code, 'R', b.other_amount_prim, -b.other_amount_prim))         OTHER_AMOUNT_PRIMCT,         count(to_number(null)) PRIM_BUDGET_GCT,         count(to_number(null)) SEC_BUDGET_GCT,         count(to_number(null)) PRIM_FORECAST_GCT,         count(to_number(null)) SEC_FORECAST_GCT,         count(to_number(null)) BASELINE_AMOUNT_PRIMCT,         count(*) CT   FROM  FII.FII_GL_JE_SUMMARY_B     b,         FII.FII_COM_CC_DIM_MAPS     m,         FII.FII_UDD1_MAPPINGS       ud1,         FII.FII_UDD2_MAPPINGS       ud2,         FII.FII_FIN_CAT_LEAF_MAPS   c,         FII.FII_FIN_CAT_TYPE_ASSGNS a   WHERE b.company_id      = m.child_company_id   AND   b.cost_center_id  = m.child_cost_center_id   AND   b.fin_category_id = c.child_fin_cat_id   AND   b.user_dim1_id    = ud1.child_user_dim1_id   AND   b.user_dim2_id    = ud2.child_user_dim2_id   AND   a.fin_category_id = b.fin_category_id   AND   a.fin_cat_type_code in ('R', 'EXP')   GROUP BY         b.time_id,         b.period_type_id,         b.ledger_id,         b.posted_date,         c.PARENT_FIN_CAT_ID,         m.PARENT_COMPANY_DIM_ID,         m.PARENT_COST_CENTER_DIM_ID,         ud1.PARENT_USER_DIM1_ID,         ud2.PARENT_USER_DIM2_ID    UNION ALL  SELECT  /* 12.0: bug#4526784 */      'CARRY'                     UMARKER,         b.time_id		      TIME_ID,         b.period_type_id	      PERIOD_TYPE_ID,         b.ledger_id                  LEDGER_ID,         b.posted_date    	      POSTED_DATE,         NULL    	              BUDGET_VERSION_DATE,         c.PARENT_FIN_CAT_ID	      FIN_CATEGORY_ID,         m.PARENT_COMPANY_DIM_ID      COMPANY_DIM_ID,         m.PARENT_COST_CENTER_DIM_ID  COST_CENTER_DIM_ID,         ud1.PARENT_USER_DIM1_ID      USER_DIM1_ID,         ud2.PARENT_USER_DIM2_ID      USER_DIM2_ID,         to_number(null)                            ACTUAL_B,         to_number(null)                            PRIM_ACTUAL_G,         to_number(null)                            SEC_ACTUAL_G,  SUM(DECODE(a.fin_cat_type_code, 'R', b.committed_amount_prim, -b.committed_amount_prim)) COMMITTED_AMOUNT_PRIM,  SUM(DECODE(a.fin_cat_type_code, 'R', b.obligated_amount_prim, -b.obligated_amount_prim)) OBLIGATED_AMOUNT_PRIM,  SUM(DECODE(a.fin_cat_type_code, 'R', b.other_amount_prim, -b.other_amount_prim))         OTHER_AMOUNT_PRIM,         to_number(null)              PRIM_BUDGET_G,         to_number(null)              SEC_BUDGET_G,         to_number(null)              PRIM_FORECAST_G,         to_number(null)              SEC_FORECAST_G,         to_number(null)              BASELINE_AMOUNT_PRIM,         count(to_number(null))       ACTUAL_BCT,         count(to_number(null))       PRIM_ACTUAL_GCT,         count(to_number(null))       SEC_ACTUAL_GCT,  count(DECODE(a.fin_cat_type_code, 'R', b.committed_amount_prim, -b.committed_amount_prim)) COMMITTED_AMOUNT_PRIMCT,  count(DECODE(a.fin_cat_type_code, 'R', b.obligated_amount_prim, -b.obligated_amount_prim)) OBLIGATED_AMOUNT_PRIMCT,  count(DECODE(a.fin_cat_type_code, 'R', b.other_amount_prim, -b.other_amount_prim))         OTHER_AMOUNT_PRIMCT,         count(to_number(null)) PRIM_BUDGET_GCT,         count(to_number(null)) SEC_BUDGET_GCT,         count(to_number(null)) PRIM_FORECAST_GCT,         count(to_number(null)) SEC_FORECAST_GCT,         count(to_number(null)) BASELINE_AMOUNT_PRIMCT,         count(*) CT   FROM  FII.FII_GL_ENC_CARRYFWD_F   b,         FII.FII_COM_CC_DIM_MAPS     m,         FII.FII_UDD1_MAPPINGS       ud1,         FII.FII_UDD2_MAPPINGS       ud2,         FII.FII_FIN_CAT_LEAF_MAPS   c,         FII.FII_FIN_CAT_TYPE_ASSGNS a   WHERE b.company_id      = m.child_company_id   AND   b.cost_center_id  = m.child_cost_center_id   AND   b.fin_category_id = c.child_fin_cat_id   AND   b.user_dim1_id    = ud1.child_user_dim1_id   AND   b.user_dim2_id    = ud2.child_user_dim2_id   AND   a.fin_category_id = b.fin_category_id   AND   a.fin_cat_type_code in ('R', 'EXP')   GROUP BY         b.time_id,         b.period_type_id,         b.ledger_id,         b.posted_date,         c.PARENT_FIN_CAT_ID,         m.PARENT_COMPANY_DIM_ID,         m.PARENT_COST_CENTER_DIM_ID,         ud1.PARENT_USER_DIM1_ID,         ud2.PARENT_USER_DIM2_ID    UNION ALL  SELECT /* 12.0: bug#4526784 */ /*+ USE_HASH(b ud2 ud1 c m) */        'BUDGET'                   UMARKER,         b.time_id		      TIME_ID,         b.period_type_id	      PERIOD_TYPE_ID,         NULL            	      LEDGER_ID,         b.posted_date    	      POSTED_DATE,         b.version_date               BUDGET_VERSION_DATE,         c.PARENT_FIN_CAT_ID	      FIN_CATEGORY_ID,         m.PARENT_COMPANY_DIM_ID      COMPANY_DIM_ID,         m.PARENT_COST_CENTER_DIM_ID  COST_CENTER_DIM_ID,         ud1.PARENT_USER_DIM1_ID      USER_DIM1_ID,         ud2.PARENT_USER_DIM2_ID      USER_DIM2_ID,         to_number(null)              ACTUAL_B,         to_number(null)              PRIM_ACTUAL_G,         to_number(null)              SEC_ACTUAL_G,  to_number(null) COMMITTED_AMOUNT_PRIM,  to_number(null) OBLIGATED_AMOUNT_PRIM,  to_number(null) OTHER_AMOUNT_PRIM,         sum(decode(plan_type_code, 'B', prim_amount_g, to_number(null)))   PRIM_BUDGET_G,        sum(decode(plan_type_code, 'B', sec_amount_g, to_number(null)))    SEC_BUDGET_G,        sum(decode(plan_type_code, 'F', prim_amount_g, to_number(null)))   PRIM_FORECAST_G,        sum(decode(plan_type_code, 'F', sec_amount_g, to_number(null)))    SEC_FORECAST_G, sum(BASELINE_AMOUNT_PRIM)             BASELINE_AMOUNT_PRIM,         count(to_number(null))       ACTUAL_BCT,         count(to_number(null))       PRIM_ACTUAL_GCT,         count(to_number(null))       SEC_ACTUAL_GCT,  count(to_number(null)) COMMITTED_AMOUNT_PRIMCT,  count(to_number(null)) OBLIGATED_AMOUNT_PRIMCT,  count(to_number(null)) OTHER_AMOUNT_PRIMCT,         count(decode(plan_type_code, 'B', prim_amount_g, to_number(null))) PRIM_BUDGET_GCT,         count(decode(plan_type_code, 'B', sec_amount_g, to_number(null))) SEC_BUDGET_GCT,         count(decode(plan_type_code, 'F', prim_amount_g, to_number(null))) PRIM_FORECAST_GCT,         count(decode(plan_type_code, 'F', sec_amount_g, to_number(null))) SEC_FORECAST_GCT,  count(BASELINE_AMOUNT_PRIM) BASELINE_AMOUNT_PRIMCT,         count(*) CT   FROM  FII.FII_BUDGET_BASE         b,         FII.FII_COM_CC_DIM_MAPS     m,         FII.FII_UDD1_MAPPINGS       ud1,         FII.FII_UDD2_MAPPINGS       ud2,         FII.FII_FIN_CAT_LEAF_MAPS   c   WHERE b.company_id      = m.child_company_id   AND   b.cost_center_id  = m.child_cost_center_id   AND   b.fin_category_id = c.child_fin_cat_id   AND   b.user_dim1_id    = ud1.child_user_dim1_id   AND   b.user_dim2_id    = ud2.child_user_dim2_id   GROUP BY         b.time_id,                       b.period_type_id,	          b.version_date,                  b.posted_date,                  c.PARENT_FIN_CAT_ID,             m.PARENT_COMPANY_DIM_ID,         m.PARENT_COST_CENTER_DIM_ID,         ud1.PARENT_USER_DIM1_ID,         ud2.PARENT_USER_DIM2_ID