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_FIN_ITEM_LEAF_HIERS

Line 363: from FII_FIN_ITEM_LEAF_HIERS,

359: select
360: NEXT_LEVEL_FIN_CAT_ID,
361: subtree_freq,
362: 'GL_FII_FIN_ITEM'
363: from FII_FIN_ITEM_LEAF_HIERS,
364: (select h.PARENT_FIN_CAT_ID root_id,
365: count(*) subtree_freq
366: from FII_FIN_ITEM_LEAF_HIERS h
367: group by h.PARENT_FIN_CAT_ID) g

Line 366: from FII_FIN_ITEM_LEAF_HIERS h

362: 'GL_FII_FIN_ITEM'
363: from FII_FIN_ITEM_LEAF_HIERS,
364: (select h.PARENT_FIN_CAT_ID root_id,
365: count(*) subtree_freq
366: from FII_FIN_ITEM_LEAF_HIERS h
367: group by h.PARENT_FIN_CAT_ID) g
368: where parent_fin_cat_id = g.root_id
369: and (PARENT_FIN_CAT_ID <> NEXT_LEVEL_FIN_CAT_ID
370: Or NEXT_LEVEL_FIN_CAT_ID = G_FC_TOP_NODE_ID )

Line 654: from fii_fin_cat_type_assgns, fii_fin_item_leaf_hiers

650: -- we need to take care that the level just below the top nodes is aggregated for FC.
651:
652: g_phase := 'Get the lowest level at which the top node is defined for Revenue';
653: select max(child_level) into l_max_level
654: from fii_fin_cat_type_assgns, fii_fin_item_leaf_hiers
655: where top_node_flag = 'Y'
656: and fin_category_id = child_fin_Cat_id
657: and parent_level = child_level
658: and fin_cat_type_code = 'R';

Line 665: update fii_fin_item_leaf_hiers f

661: -- atleast one level below the top nodes in FC. The top nodes here would refer to the
662: -- top nodes of Revenue/Expenses.
663:
664: g_phase := 'Updating the aggregate_next_level flag for Revenue';
665: update fii_fin_item_leaf_hiers f
666: set aggregate_next_level_flag = 'Y'
667: where aggregate_next_level_flag <> 'Y'
668: and (next_level in (1,2)
669: or (next_level <= l_max_level + 1

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

671: from fii_fin_cat_type_assgns
672: where fin_cat_type_code = 'R')));
673:
674: IF (FIIDIM_Debug) THEN
675: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows into FII_FIN_ITEM_LEAF_HIERS');
676: END IF;
677:
678: g_phase := 'Get the lowest level at which the top node is defined for Expense';
679: select max(child_level) into l_max_level

Line 680: from fii_fin_cat_type_assgns, fii_fin_item_leaf_hiers

676: END IF;
677:
678: g_phase := 'Get the lowest level at which the top node is defined for Expense';
679: select max(child_level) into l_max_level
680: from fii_fin_cat_type_assgns, fii_fin_item_leaf_hiers
681: where top_node_flag = 'Y'
682: and fin_category_id = child_fin_Cat_id
683: and parent_level = child_level
684: and fin_cat_type_code = 'EXP';

Line 687: update fii_fin_item_leaf_hiers f

683: and parent_level = child_level
684: and fin_cat_type_code = 'EXP';
685:
686: g_phase := 'Updating the aggregate_next_level flag for Expense';
687: update fii_fin_item_leaf_hiers f
688: set aggregate_next_level_flag = 'Y'
689: where aggregate_next_level_flag <> 'Y'
690: and (f.next_level <= l_max_level + 1
691: and f.next_level_fin_cat_id in (select fin_category_id

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

692: from fii_fin_cat_type_assgns
693: where fin_cat_type_code = 'EXP'));
694:
695: IF (FIIDIM_Debug) THEN
696: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows into FII_FIN_ITEM_LEAF_HIERS');
697: END IF;
698:
699: g_phase := 'Updating the FC pmv helper table for the newly aggregated nodes';
700: update fii_fc_pmv_agrt_nodes f

Line 702: from fii_fin_item_leaf_hiers

698:
699: g_phase := 'Updating the FC pmv helper table for the newly aggregated nodes';
700: update fii_fc_pmv_agrt_nodes f
701: set aggregated_flag = (select aggregate_next_level_flag
702: from fii_fin_item_leaf_hiers
703: where next_level_fin_cat_id = f.fin_category_id
704: and parent_level = next_level)
705: where aggregated_flag <> (select aggregate_next_level_flag
706: from fii_fin_item_leaf_hiers

Line 706: from fii_fin_item_leaf_hiers

702: from fii_fin_item_leaf_hiers
703: where next_level_fin_cat_id = f.fin_category_id
704: and parent_level = next_level)
705: where aggregated_flag <> (select aggregate_next_level_flag
706: from fii_fin_item_leaf_hiers
707: where next_level_fin_cat_id = f.fin_category_id
708: and parent_level = next_level);
709:
710: IF (FIIDIM_Debug) THEN

Line 714: g_phase := 'gather_table_stats for FII_FIN_ITEM_LEAF_HIERS';

710: IF (FIIDIM_Debug) THEN
711: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows into FII_FC_PMV_AGRT_NODES');
712: END IF;
713:
714: g_phase := 'gather_table_stats for FII_FIN_ITEM_LEAF_HIERS';
715: FND_STATS.gather_table_stats
716: (ownname => g_schema_name,
717: tabname => 'FII_FIN_ITEM_LEAF_HIERS');
718:

Line 717: tabname => 'FII_FIN_ITEM_LEAF_HIERS');

713:
714: g_phase := 'gather_table_stats for FII_FIN_ITEM_LEAF_HIERS';
715: FND_STATS.gather_table_stats
716: (ownname => g_schema_name,
717: tabname => 'FII_FIN_ITEM_LEAF_HIERS');
718:
719: -- Bug 4200473. Not to analyze MLOG in incremental run.
720: -- As per performance teams suggestions.
721:

Line 872: g_phase := 'In IF Update fii_fin_item_leaf_hiers and set the aggregate_next_level_flag';

868:
869: -- For FC Dimension
870: IF (p_dim_short_name = 'GL_FII_FIN_ITEM') THEN
871: IF (G_PROGRAM_MODE = 'INCRE') THEN
872: g_phase := 'In IF Update fii_fin_item_leaf_hiers and set the aggregate_next_level_flag';
873: update FII_FIN_ITEM_LEAF_HIERS f
874: set aggregate_next_level_flag = (select aggregated_flag
875: from fii_fc_pmv_agrt_nodes
876: where fin_category_id = f.next_level_fin_cat_id)

Line 873: update FII_FIN_ITEM_LEAF_HIERS f

869: -- For FC Dimension
870: IF (p_dim_short_name = 'GL_FII_FIN_ITEM') THEN
871: IF (G_PROGRAM_MODE = 'INCRE') THEN
872: g_phase := 'In IF Update fii_fin_item_leaf_hiers and set the aggregate_next_level_flag';
873: update FII_FIN_ITEM_LEAF_HIERS f
874: set aggregate_next_level_flag = (select aggregated_flag
875: from fii_fc_pmv_agrt_nodes
876: where fin_category_id = f.next_level_fin_cat_id)
877: where aggregate_next_level_flag <> (select aggregated_flag

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

878: from fii_fc_pmv_agrt_nodes
879: where fin_category_id = f.next_level_fin_cat_id);
880:
881: IF (FIIDIM_Debug) THEN
882: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows into FII_FIN_ITEM_LEAF_HIERS');
883: END IF;
884:
885: ELSE
886: g_phase := 'In ELSE Update FII_FIN_ITEM_LEAF_HIERS and set the aggregate_next_level_flag';

Line 886: g_phase := 'In ELSE Update FII_FIN_ITEM_LEAF_HIERS and set the aggregate_next_level_flag';

882: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows into FII_FIN_ITEM_LEAF_HIERS');
883: END IF;
884:
885: ELSE
886: g_phase := 'In ELSE Update FII_FIN_ITEM_LEAF_HIERS and set the aggregate_next_level_flag';
887: update FII_FIN_ITEM_LEAF_HIERS f
888: set aggregate_next_level_flag = (select aggregated_flag
889: from fii_fc_pmv_agrt_nodes
890: where fin_category_id = f.next_level_fin_cat_id);

Line 887: update FII_FIN_ITEM_LEAF_HIERS f

883: END IF;
884:
885: ELSE
886: g_phase := 'In ELSE Update FII_FIN_ITEM_LEAF_HIERS and set the aggregate_next_level_flag';
887: update FII_FIN_ITEM_LEAF_HIERS f
888: set aggregate_next_level_flag = (select aggregated_flag
889: from fii_fc_pmv_agrt_nodes
890: where fin_category_id = f.next_level_fin_cat_id);
891:

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

889: from fii_fc_pmv_agrt_nodes
890: where fin_category_id = f.next_level_fin_cat_id);
891:
892: IF (FIIDIM_Debug) THEN
893: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows into FII_FIN_ITEM_LEAF_HIERS');
894: END IF;
895:
896: END IF;
897:

Line 900: --from fii_fin_item_leaf_hiers

896: END IF;
897:
898: -- Bug 4235853
899: --select max(next_level) into l_max_agrt_level
900: --from fii_fin_item_leaf_hiers
901: --where aggregate_next_level_flag = 'Y';
902:
903: -- For Company Dimension
904:

Line 1055: from FII_FIN_ITEM_LEAF_HIERS f1

1051:
1052: UPDATE FII_FC_PMV_AGRT_NODES
1053: set for_viewby_flag = 'Y'
1054: WHERE fin_category_id in ( select next_level_fin_cat_id
1055: from FII_FIN_ITEM_LEAF_HIERS f1
1056: where (f1.is_leaf_flag = 'Y' and f1.aggregate_next_level_flag = 'Y')
1057: or exists ( select aggregate_next_level_flag
1058: from FII_FIN_ITEM_LEAF_HIERS f2
1059: where f1.next_level_fin_cat_id = f2.parent_fin_cat_id

Line 1058: from FII_FIN_ITEM_LEAF_HIERS f2

1054: WHERE fin_category_id in ( select next_level_fin_cat_id
1055: from FII_FIN_ITEM_LEAF_HIERS f1
1056: where (f1.is_leaf_flag = 'Y' and f1.aggregate_next_level_flag = 'Y')
1057: or exists ( select aggregate_next_level_flag
1058: from FII_FIN_ITEM_LEAF_HIERS f2
1059: where f1.next_level_fin_cat_id = f2.parent_fin_cat_id
1060: and f2.aggregate_next_level_flag = 'Y'
1061: and f2.parent_fin_cat_id <> f2.next_level_fin_cat_id));
1062: IF (FIIDIM_Debug) THEN

Line 1177: from FII_FIN_ITEM_LEAF_HIERS

1173: FII_USER_ID,
1174: SYSDATE,
1175: FII_USER_ID,
1176: FII_LOGIN_ID
1177: from FII_FIN_ITEM_LEAF_HIERS
1178: where parent_level= next_level
1179: ) ;
1180:
1181: IF (FIIDIM_Debug) THEN

Line 1415: from FII_FIN_ITEM_LEAF_HIERS

1411: FII_USER_ID,
1412: SYSDATE,
1413: FII_USER_ID,
1414: FII_LOGIN_ID
1415: from FII_FIN_ITEM_LEAF_HIERS
1416: where parent_level= next_level
1417: minus
1418: select fin_category_id, 'N', 'N',
1419: SYSDATE,