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.

APPS.FII_PMV_HELPER_TABLES_C dependencies on FII_COST_CTR_HIERARCHIES

Line 466: from fii_COST_CTR_hierarchies,

462: select
463: NEXT_LEVEL_CC_ID,
464: subtree_freq,
465: 'HRI_CL_ORGCC'
466: from fii_COST_CTR_hierarchies,
467: (select h.PARENT_CC_ID root_id,
468: count(*) subtree_freq
469: from fii_COST_CTR_hierarchies h
470: group by h.PARENT_CC_ID) g

Line 469: from fii_COST_CTR_hierarchies h

465: 'HRI_CL_ORGCC'
466: from fii_COST_CTR_hierarchies,
467: (select h.PARENT_CC_ID root_id,
468: count(*) subtree_freq
469: from fii_COST_CTR_hierarchies h
470: group by h.PARENT_CC_ID) g
471: where parent_CC_id = g.root_id
472: and PARENT_CC_ID <> NEXT_LEVEL_CC_ID
473: group by PARENT_CC_ID,

Line 730: update fii_cost_ctr_hierarchies f

726:
727: ELSIF (p_dim_short_name = 'HRI_CL_ORGCC') THEN
728: -- For CC
729: g_phase := 'Updating the aggregate_next_level flag for first two levels in CC';
730: update fii_cost_ctr_hierarchies f
731: set aggregate_next_level_flag = 'Y'
732: where aggregate_next_level_flag <> 'Y'
733: and next_level in (1,2);
734:

Line 737: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows into FII_COST_CTR_HIERARCHIES');

733: and next_level in (1,2);
734:
735:
736: IF (FIIDIM_Debug) THEN
737: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows into FII_COST_CTR_HIERARCHIES');
738: END IF;
739:
740: g_phase := 'Updating the Cost Center pmv helper table for the newly aggregated nodes';
741: update fii_cc_pmv_agrt_nodes f

Line 743: from fii_cost_ctr_hierarchies

739:
740: g_phase := 'Updating the Cost Center pmv helper table for the newly aggregated nodes';
741: update fii_cc_pmv_agrt_nodes f
742: set aggregated_flag = (select aggregate_next_level_flag
743: from fii_cost_ctr_hierarchies
744: where next_level_cc_id = f.cost_center_id
745: and parent_level = next_level)
746: where aggregated_flag <> (select aggregate_next_level_flag
747: from fii_cost_ctr_hierarchies

Line 747: from fii_cost_ctr_hierarchies

743: from fii_cost_ctr_hierarchies
744: where next_level_cc_id = f.cost_center_id
745: and parent_level = next_level)
746: where aggregated_flag <> (select aggregate_next_level_flag
747: from fii_cost_ctr_hierarchies
748: where next_level_cc_id = f.cost_center_id
749: and parent_level = next_level);
750:
751: IF (FIIDIM_Debug) THEN

Line 755: g_phase := 'gather_table_stats for FII_COST_CTR_HIERARCHIES';

751: IF (FIIDIM_Debug) THEN
752: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows into FII_CC_PMV_AGRT_NODES');
753: END IF;
754:
755: g_phase := 'gather_table_stats for FII_COST_CTR_HIERARCHIES';
756: FND_STATS.gather_table_stats
757: (ownname => g_schema_name,
758: tabname => 'FII_COST_CTR_HIERARCHIES');
759:

Line 758: tabname => 'FII_COST_CTR_HIERARCHIES');

754:
755: g_phase := 'gather_table_stats for FII_COST_CTR_HIERARCHIES';
756: FND_STATS.gather_table_stats
757: (ownname => g_schema_name,
758: tabname => 'FII_COST_CTR_HIERARCHIES');
759:
760: -- Bug 4200473. Not to analyze MLOG in incremental run.
761: -- As per performance teams suggestions.
762:

Line 941: g_phase := 'In IF Update fii_cost_ctr_hierarchies and set the aggregate_next_level_flag';

937: -- For CC Dimension
938:
939: ELSIF (p_dim_short_name = 'HRI_CL_ORGCC') THEN
940: IF (G_PROGRAM_MODE = 'INCRE') THEN
941: g_phase := 'In IF Update fii_cost_ctr_hierarchies and set the aggregate_next_level_flag';
942: update fii_cost_ctr_hierarchies f
943: set aggregate_next_level_flag = (select aggregated_flag
944: from fii_cc_pmv_agrt_nodes
945: where cost_center_id = f.next_level_cc_id)

Line 942: update fii_cost_ctr_hierarchies f

938:
939: ELSIF (p_dim_short_name = 'HRI_CL_ORGCC') THEN
940: IF (G_PROGRAM_MODE = 'INCRE') THEN
941: g_phase := 'In IF Update fii_cost_ctr_hierarchies and set the aggregate_next_level_flag';
942: update fii_cost_ctr_hierarchies f
943: set aggregate_next_level_flag = (select aggregated_flag
944: from fii_cc_pmv_agrt_nodes
945: where cost_center_id = f.next_level_cc_id)
946: where aggregate_next_level_flag <> (select aggregated_flag

Line 951: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows into FII_COST_CTR_HIERARCHIES');

947: from fii_cc_pmv_agrt_nodes
948: where cost_center_id = f.next_level_cc_id);
949:
950: IF (FIIDIM_Debug) THEN
951: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows into FII_COST_CTR_HIERARCHIES');
952: END IF;
953:
954: ELSE
955: g_phase := 'In ELSE Update fii_cost_ctr_hierarchies and set the aggregate_next_level_flag';

Line 955: g_phase := 'In ELSE Update fii_cost_ctr_hierarchies and set the aggregate_next_level_flag';

951: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows into FII_COST_CTR_HIERARCHIES');
952: END IF;
953:
954: ELSE
955: g_phase := 'In ELSE Update fii_cost_ctr_hierarchies and set the aggregate_next_level_flag';
956: update fii_cost_ctr_hierarchies f
957: set aggregate_next_level_flag = (select aggregated_flag
958: from fii_cc_pmv_agrt_nodes
959: where cost_center_id = f.next_level_cc_id);

Line 956: update fii_cost_ctr_hierarchies f

952: END IF;
953:
954: ELSE
955: g_phase := 'In ELSE Update fii_cost_ctr_hierarchies and set the aggregate_next_level_flag';
956: update fii_cost_ctr_hierarchies f
957: set aggregate_next_level_flag = (select aggregated_flag
958: from fii_cc_pmv_agrt_nodes
959: where cost_center_id = f.next_level_cc_id);
960:

Line 962: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows into FII_COST_CTR_HIERARCHIES');

958: from fii_cc_pmv_agrt_nodes
959: where cost_center_id = f.next_level_cc_id);
960:
961: IF (FIIDIM_Debug) THEN
962: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows into FII_COST_CTR_HIERARCHIES');
963: END IF;
964:
965: END IF;
966:

Line 968: from fii_cost_ctr_hierarchies

964:
965: END IF;
966:
967: select max(next_level) into l_max_agrt_level
968: from fii_cost_ctr_hierarchies
969: where aggregate_next_level_flag = 'Y';
970:
971: -- For UDD1 Dimension
972:

Line 1092: from FII_COST_CTR_HIERARCHIES f1

1088:
1089: UPDATE FII_CC_PMV_AGRT_NODES
1090: set for_viewby_flag = 'Y'
1091: WHERE cost_center_id in ( select next_level_cc_id
1092: from FII_COST_CTR_HIERARCHIES f1
1093: where (f1.is_leaf_flag = 'Y' and f1.aggregate_next_level_flag = 'Y')
1094: or exists ( select aggregate_next_level_flag
1095: from FII_COST_CTR_HIERARCHIES f2
1096: where f1.next_level_cc_id = f2.parent_cc_id

Line 1095: from FII_COST_CTR_HIERARCHIES f2

1091: WHERE cost_center_id in ( select next_level_cc_id
1092: from FII_COST_CTR_HIERARCHIES f1
1093: where (f1.is_leaf_flag = 'Y' and f1.aggregate_next_level_flag = 'Y')
1094: or exists ( select aggregate_next_level_flag
1095: from FII_COST_CTR_HIERARCHIES f2
1096: where f1.next_level_cc_id = f2.parent_cc_id
1097: and f2.aggregate_next_level_flag = 'Y'
1098: and f2.parent_cc_id <> f2.next_level_cc_id));
1099:

Line 1226: from fii_cost_ctr_hierarchies

1222: FII_USER_ID,
1223: SYSDATE,
1224: FII_USER_ID,
1225: FII_LOGIN_ID
1226: from fii_cost_ctr_hierarchies
1227: where parent_level= next_level
1228: ) ;
1229:
1230: IF (FIIDIM_Debug) THEN

Line 1479: from fii_cost_ctr_hierarchies

1475: FII_USER_ID,
1476: SYSDATE,
1477: FII_USER_ID,
1478: FII_LOGIN_ID
1479: from fii_cost_ctr_hierarchies
1480: where parent_level= next_level
1481: minus
1482: select cost_center_id, 'N', 'N',
1483: SYSDATE,