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]

APPS.FII_PMV_HELPER_TABLES_C dependencies on FII_UDD1_HIERARCHIES

Line 518: from fii_UDD1_hierarchies,

514:
515: select NEXT_LEVEL_VALUE_ID,
516: subtree_freq,
517: 'FII_USER_DEFINED_1'
518: from fii_UDD1_hierarchies,
519: (select h.PARENT_VALUE_ID root_id,
520: count(*) subtree_freq
521: from fii_UDD1_hierarchies h
522: group by h.PARENT_VALUE_ID) g

Line 521: from fii_UDD1_hierarchies h

517: 'FII_USER_DEFINED_1'
518: from fii_UDD1_hierarchies,
519: (select h.PARENT_VALUE_ID root_id,
520: count(*) subtree_freq
521: from fii_UDD1_hierarchies h
522: group by h.PARENT_VALUE_ID) g
523: where parent_VALUE_id = g.root_id
524: and PARENT_VALUE_ID <> NEXT_LEVEL_VALUE_ID
525: group by PARENT_VALUE_ID,

Line 811: update fii_udd1_hierarchies f

807:
808: ELSIF (p_dim_short_name = 'FII_USER_DEFINED_1') THEN
809: -- For UD1
810: g_phase := 'Updating the aggregate_next_level flag for first two levels in UD1';
811: update fii_udd1_hierarchies f
812: set aggregate_next_level_flag = 'Y'
813: where aggregate_next_level_flag <> 'Y'
814: and next_level in (1,2);
815:

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

813: where aggregate_next_level_flag <> 'Y'
814: and next_level in (1,2);
815:
816: IF (FIIDIM_Debug) THEN
817: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows into FII_UDD1_HIERARCHIES');
818: END IF;
819:
820: g_phase := 'Updating the User Defined Dimension 1 pmv helper table for the newly aggregated nodes';
821: update fii_udd1_pmv_agrt_nodes f

Line 823: from fii_udd1_hierarchies

819:
820: g_phase := 'Updating the User Defined Dimension 1 pmv helper table for the newly aggregated nodes';
821: update fii_udd1_pmv_agrt_nodes f
822: set aggregated_flag = (select aggregate_next_level_flag
823: from fii_udd1_hierarchies
824: where next_level_value_id = f.udd1_value_id
825: and parent_level = next_level)
826: where aggregated_flag <> (select aggregate_next_level_flag
827: from fii_udd1_hierarchies

Line 827: from fii_udd1_hierarchies

823: from fii_udd1_hierarchies
824: where next_level_value_id = f.udd1_value_id
825: and parent_level = next_level)
826: where aggregated_flag <> (select aggregate_next_level_flag
827: from fii_udd1_hierarchies
828: where next_level_value_id = f.udd1_value_id
829: and parent_level = next_level);
830:
831: IF (FIIDIM_Debug) THEN

Line 835: g_phase := 'gather_table_stats for FII_UDD1_HIERARCHIES';

831: IF (FIIDIM_Debug) THEN
832: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows into FII_UDD1_PMV_AGRT_NODES');
833: END IF;
834:
835: g_phase := 'gather_table_stats for FII_UDD1_HIERARCHIES';
836: FND_STATS.gather_table_stats
837: (ownname => g_schema_name,
838: tabname => 'FII_UDD1_HIERARCHIES');
839:

Line 838: tabname => 'FII_UDD1_HIERARCHIES');

834:
835: g_phase := 'gather_table_stats for FII_UDD1_HIERARCHIES';
836: FND_STATS.gather_table_stats
837: (ownname => g_schema_name,
838: tabname => 'FII_UDD1_HIERARCHIES');
839:
840: -- Bug 4200473. Not to analyze MLOG in incremental run.
841: -- As per performance teams suggestions.
842:

Line 843: -- g_phase := 'gather_table_stats for MLOG$_FII_UDD1_HIERARCHIES';

839:
840: -- Bug 4200473. Not to analyze MLOG in incremental run.
841: -- As per performance teams suggestions.
842:
843: -- g_phase := 'gather_table_stats for MLOG$_FII_UDD1_HIERARCHIES';
844: -- FND_STATS.gather_table_stats
845: -- (ownname => g_schema_name,
846: -- tabname => 'MLOG$_FII_UDD1_HIERARCHIES');
847:

Line 846: -- tabname => 'MLOG$_FII_UDD1_HIERARCHIES');

842:
843: -- g_phase := 'gather_table_stats for MLOG$_FII_UDD1_HIERARCHIES';
844: -- FND_STATS.gather_table_stats
845: -- (ownname => g_schema_name,
846: -- tabname => 'MLOG$_FII_UDD1_HIERARCHIES');
847:
848: END IF;
849:
850: IF (FIIDIM_Debug) THEN

Line 975: g_phase := 'In IF Update fii_udd1_hierarchies and set the aggregate_next_level_flag';

971: -- For UDD1 Dimension
972:
973: ELSIF (p_dim_short_name = 'FII_USER_DEFINED_1') THEN
974: IF (G_PROGRAM_MODE = 'INCRE') THEN
975: g_phase := 'In IF Update fii_udd1_hierarchies and set the aggregate_next_level_flag';
976: update fii_udd1_hierarchies f
977: set aggregate_next_level_flag = (select aggregated_flag
978: from fii_udd1_pmv_agrt_nodes
979: where UDD1_VALUE_ID = f.next_level_value_id)

Line 976: update fii_udd1_hierarchies f

972:
973: ELSIF (p_dim_short_name = 'FII_USER_DEFINED_1') THEN
974: IF (G_PROGRAM_MODE = 'INCRE') THEN
975: g_phase := 'In IF Update fii_udd1_hierarchies and set the aggregate_next_level_flag';
976: update fii_udd1_hierarchies f
977: set aggregate_next_level_flag = (select aggregated_flag
978: from fii_udd1_pmv_agrt_nodes
979: where UDD1_VALUE_ID = f.next_level_value_id)
980: where aggregate_next_level_flag <> (select aggregated_flag

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

981: from fii_udd1_pmv_agrt_nodes
982: where UDD1_VALUE_ID = f.next_level_value_id);
983:
984: IF (FIIDIM_Debug) THEN
985: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows into FII_UDD1_HIERARCHIES');
986: END IF;
987:
988: ELSE
989: g_phase := 'In ELSE Update fii_udd1_hierarchies and set the aggregate_next_level_flag';

Line 989: g_phase := 'In ELSE Update fii_udd1_hierarchies and set the aggregate_next_level_flag';

985: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows into FII_UDD1_HIERARCHIES');
986: END IF;
987:
988: ELSE
989: g_phase := 'In ELSE Update fii_udd1_hierarchies and set the aggregate_next_level_flag';
990: update fii_udd1_hierarchies f
991: set aggregate_next_level_flag = (select aggregated_flag
992: from fii_udd1_pmv_agrt_nodes
993: where UDD1_VALUE_ID = f.next_level_value_id);

Line 990: update fii_udd1_hierarchies f

986: END IF;
987:
988: ELSE
989: g_phase := 'In ELSE Update fii_udd1_hierarchies and set the aggregate_next_level_flag';
990: update fii_udd1_hierarchies f
991: set aggregate_next_level_flag = (select aggregated_flag
992: from fii_udd1_pmv_agrt_nodes
993: where UDD1_VALUE_ID = f.next_level_value_id);
994:

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

992: from fii_udd1_pmv_agrt_nodes
993: where UDD1_VALUE_ID = f.next_level_value_id);
994:
995: IF (FIIDIM_Debug) THEN
996: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows into FII_UDD1_HIERARCHIES');
997: END IF;
998:
999: END IF;
1000:

Line 1002: from fii_udd1_hierarchies

998:
999: END IF;
1000:
1001: select max(next_level) into l_max_agrt_level
1002: from fii_udd1_hierarchies
1003: where aggregate_next_level_flag = 'Y';
1004:
1005: END IF;
1006:

Line 1110: from FII_UDD1_HIERARCHIES f1

1106:
1107: UPDATE FII_UDD1_PMV_AGRT_NODES
1108: set for_viewby_flag = 'Y'
1109: WHERE udd1_value_id in ( select next_level_value_id
1110: from FII_UDD1_HIERARCHIES f1
1111: where (f1.is_leaf_flag = 'Y' and f1.aggregate_next_level_flag = 'Y')
1112: or exists ( select aggregate_next_level_flag
1113: from FII_UDD1_HIERARCHIES f2
1114: where f1.next_level_value_id = f2.parent_value_id

Line 1113: from FII_UDD1_HIERARCHIES f2

1109: WHERE udd1_value_id in ( select next_level_value_id
1110: from FII_UDD1_HIERARCHIES f1
1111: where (f1.is_leaf_flag = 'Y' and f1.aggregate_next_level_flag = 'Y')
1112: or exists ( select aggregate_next_level_flag
1113: from FII_UDD1_HIERARCHIES f2
1114: where f1.next_level_value_id = f2.parent_value_id
1115: and f2.aggregate_next_level_flag = 'Y'
1116: and f2.parent_value_id <> f2.next_level_value_id));
1117:

Line 1251: from fii_udd1_hierarchies

1247: FII_USER_ID,
1248: SYSDATE,
1249: FII_USER_ID,
1250: FII_LOGIN_ID
1251: from fii_udd1_hierarchies
1252: where parent_level= next_level
1253: ) ;
1254:
1255: IF (FIIDIM_Debug) THEN

Line 1511: from fii_udd1_hierarchies

1507: FII_USER_ID,
1508: SYSDATE,
1509: FII_USER_ID,
1510: FII_LOGIN_ID
1511: from fii_udd1_hierarchies
1512: where parent_level= next_level
1513: minus
1514: select udd1_value_id, 'N', 'N',
1515: SYSDATE,