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_COMPANY_HIERARCHIES

Line 415: from fii_COMPANY_hierarchies,

411: select
412: NEXT_LEVEL_COMPANY_ID,
413: subtree_freq,
414: 'FII_COMPANIES'
415: from fii_COMPANY_hierarchies,
416: (select h.PARENT_COMPANY_ID root_id,
417: count(*) subtree_freq
418: from fii_COMPANY_hierarchies h
419: group by h.PARENT_COMPANY_ID) g

Line 418: from fii_COMPANY_hierarchies h

414: 'FII_COMPANIES'
415: from fii_COMPANY_hierarchies,
416: (select h.PARENT_COMPANY_ID root_id,
417: count(*) subtree_freq
418: from fii_COMPANY_hierarchies h
419: group by h.PARENT_COMPANY_ID) g
420: where parent_COMPANY_id = g.root_id
421: and PARENT_COMPANY_ID <> NEXT_LEVEL_COMPANY_ID
422: group by PARENT_COMPANY_ID,

Line 771: update fii_company_hierarchies f

767:
768: ELSIF (p_dim_short_name = 'FII_COMPANIES') THEN
769: -- For Company
770: g_phase := 'Updating the aggregate_next_level flag for first two levels in Company';
771: update fii_company_hierarchies f
772: set aggregate_next_level_flag = 'Y'
773: where aggregate_next_level_flag <> 'Y'
774: and next_level in (1,2);
775:

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

773: where aggregate_next_level_flag <> 'Y'
774: and next_level in (1,2);
775:
776: IF (FIIDIM_Debug) THEN
777: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows into FII_COMPANY_HIERARCHIES');
778: END IF;
779:
780: g_phase := 'Updating the Company pmv helper table for the newly aggregated nodes';
781: update fii_com_pmv_agrt_nodes f

Line 783: from fii_company_hierarchies

779:
780: g_phase := 'Updating the Company pmv helper table for the newly aggregated nodes';
781: update fii_com_pmv_agrt_nodes f
782: set aggregated_flag = (select aggregate_next_level_flag
783: from fii_company_hierarchies
784: where next_level_company_id = f.company_id
785: and parent_level = next_level)
786: where aggregated_flag <> (select aggregate_next_level_flag
787: from fii_company_hierarchies

Line 787: from fii_company_hierarchies

783: from fii_company_hierarchies
784: where next_level_company_id = f.company_id
785: and parent_level = next_level)
786: where aggregated_flag <> (select aggregate_next_level_flag
787: from fii_company_hierarchies
788: where next_level_company_id = f.company_id
789: and parent_level = next_level);
790:
791: IF (FIIDIM_Debug) THEN

Line 795: g_phase := 'gather_table_stats for FII_COMPANY_HIERARCHIES';

791: IF (FIIDIM_Debug) THEN
792: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows into FII_COM_PMV_AGRT_NODES');
793: END IF;
794:
795: g_phase := 'gather_table_stats for FII_COMPANY_HIERARCHIES';
796: FND_STATS.gather_table_stats
797: (ownname => g_schema_name,
798: tabname => 'FII_COMPANY_HIERARCHIES');
799:

Line 798: tabname => 'FII_COMPANY_HIERARCHIES');

794:
795: g_phase := 'gather_table_stats for FII_COMPANY_HIERARCHIES';
796: FND_STATS.gather_table_stats
797: (ownname => g_schema_name,
798: tabname => 'FII_COMPANY_HIERARCHIES');
799:
800: -- Bug 4200473. Not to analyze MLOG in incremental run.
801: -- As per performance teams suggestions.
802:

Line 907: g_phase := 'In IF Update fii_company_hierarchies and set the aggregate_next_level_flag';

903: -- For Company Dimension
904:
905: ELSIF (p_dim_short_name = 'FII_COMPANIES') THEN
906: IF (G_PROGRAM_MODE = 'INCRE') THEN
907: g_phase := 'In IF Update fii_company_hierarchies and set the aggregate_next_level_flag';
908: update FII_COMPANY_HIERARCHIES f
909: set aggregate_next_level_flag = (select aggregated_flag
910: from fii_com_pmv_agrt_nodes
911: where company_id = f.next_level_company_id)

Line 908: update FII_COMPANY_HIERARCHIES f

904:
905: ELSIF (p_dim_short_name = 'FII_COMPANIES') THEN
906: IF (G_PROGRAM_MODE = 'INCRE') THEN
907: g_phase := 'In IF Update fii_company_hierarchies and set the aggregate_next_level_flag';
908: update FII_COMPANY_HIERARCHIES f
909: set aggregate_next_level_flag = (select aggregated_flag
910: from fii_com_pmv_agrt_nodes
911: where company_id = f.next_level_company_id)
912: where aggregate_next_level_flag <> (select aggregated_flag

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

913: from fii_com_pmv_agrt_nodes
914: where company_id = f.next_level_company_id);
915:
916: IF (FIIDIM_Debug) THEN
917: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows into FII_COMPANY_HIERARCHIES');
918: END IF;
919:
920: ELSE
921: g_phase := 'In ELSE Update fii_company_hierarchies and set the aggregate_next_level_flag';

Line 921: g_phase := 'In ELSE Update fii_company_hierarchies and set the aggregate_next_level_flag';

917: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows into FII_COMPANY_HIERARCHIES');
918: END IF;
919:
920: ELSE
921: g_phase := 'In ELSE Update fii_company_hierarchies and set the aggregate_next_level_flag';
922: update fii_company_hierarchies f
923: set aggregate_next_level_flag = (select aggregated_flag
924: from fii_com_pmv_agrt_nodes
925: where company_id = f.next_level_company_id);

Line 922: update fii_company_hierarchies f

918: END IF;
919:
920: ELSE
921: g_phase := 'In ELSE Update fii_company_hierarchies and set the aggregate_next_level_flag';
922: update fii_company_hierarchies f
923: set aggregate_next_level_flag = (select aggregated_flag
924: from fii_com_pmv_agrt_nodes
925: where company_id = f.next_level_company_id);
926:

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

924: from fii_com_pmv_agrt_nodes
925: where company_id = f.next_level_company_id);
926:
927: IF (FIIDIM_Debug) THEN
928: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows into FII_COMPANY_HIERARCHIES');
929: END IF;
930:
931: END IF;
932:

Line 934: from fii_company_hierarchies

930:
931: END IF;
932:
933: select max(next_level) into l_max_agrt_level
934: from fii_company_hierarchies
935: where aggregate_next_level_flag = 'Y';
936:
937: -- For CC Dimension
938:

Line 1073: from FII_COMPANY_HIERARCHIES f1

1069:
1070: UPDATE FII_COM_PMV_AGRT_NODES
1071: set for_viewby_flag = 'Y'
1072: WHERE company_id in ( select next_level_company_id
1073: from FII_COMPANY_HIERARCHIES f1
1074: where (f1.is_leaf_flag = 'Y' and f1.aggregate_next_level_flag = 'Y')
1075: or exists ( select aggregate_next_level_flag
1076: from FII_COMPANY_HIERARCHIES f2
1077: where f1.next_level_company_id = f2.parent_company_id

Line 1076: from FII_COMPANY_HIERARCHIES f2

1072: WHERE company_id in ( select next_level_company_id
1073: from FII_COMPANY_HIERARCHIES f1
1074: where (f1.is_leaf_flag = 'Y' and f1.aggregate_next_level_flag = 'Y')
1075: or exists ( select aggregate_next_level_flag
1076: from FII_COMPANY_HIERARCHIES f2
1077: where f1.next_level_company_id = f2.parent_company_id
1078: and f2.aggregate_next_level_flag = 'Y'
1079: and f2.parent_company_id <> f2.next_level_company_id));
1080:

Line 1201: from fii_company_hierarchies

1197: FII_USER_ID,
1198: SYSDATE,
1199: FII_USER_ID,
1200: FII_LOGIN_ID
1201: from fii_company_hierarchies
1202: where parent_level= next_level
1203: );
1204:
1205: IF (FIIDIM_Debug) THEN

Line 1447: from fii_company_hierarchies

1443: FII_USER_ID,
1444: SYSDATE,
1445: FII_USER_ID,
1446: FII_LOGIN_ID
1447: from fii_company_hierarchies
1448: where parent_level= next_level
1449: minus
1450: select company_id, 'N', 'N',
1451: SYSDATE,