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_FIN_CAT_MAINTAIN_PKG dependencies on FII_FULL_FIN_ITEM_HIERS

Line 1120: FROM FII_FULL_FIN_ITEM_HIERS fh

1116: (parent_fin_cat_id,
1117: child_fin_cat_id)
1118: SELECT fh.parent_fin_cat_id,
1119: fh.child_fin_cat_id
1120: FROM FII_FULL_FIN_ITEM_HIERS fh
1121: WHERE fh.parent_fin_cat_id IN
1122: (SELECT ph.parent_fin_cat_id
1123: FROM FII_FIN_ITEM_HIERARCHIES ph
1124: WHERE ph.is_leaf_flag = 'Y');

Line 1336: FII_FULL_FIN_ITEM_HIERS hier

1332: fcn.fin_cat_type_code,
1333: hier.child_fin_cat_id,
1334: 'N'
1335: from FII_FC_TYPE_NORM_ASSIGN fcn,
1336: FII_FULL_FIN_ITEM_HIERS hier
1337: where fcn.fin_category_id = hier.parent_fin_cat_id;
1338:
1339: l_sql_rowcount := SQL%ROWCOUNT;
1340:

Line 1405: -- FII_FULL_FIN_ITEM_HIERS hier

1401: --UPDATE FII_FC_TYPE_ASSGNS_GT tab1
1402: -- SET tab1.TOP_NODE_FLAG = 'Y'
1403: -- WHERE 1 = (select count(*)
1404: -- from FII_FC_TYPE_ASSGNS_GT tab2,
1405: -- FII_FULL_FIN_ITEM_HIERS hier
1406: -- where tab2.fin_cat_type_code = tab1.fin_cat_type_code
1407: -- and hier.child_fin_cat_id = tab1.fin_category_id
1408: -- and hier.parent_fin_cat_id = tab2.fin_category_id );
1409:

Line 1416: FII_FULL_FIN_ITEM_HIERS hier,

1412: WHERE (tab1.fin_cat_type_code,tab1.fin_category_id) IN
1413: (select /*+ ordered parallel(hier) */
1414: tab3.fin_cat_type_code,tab3.fin_category_id
1415: from FII_FC_TYPE_ASSGNS_GT tab3,
1416: FII_FULL_FIN_ITEM_HIERS hier,
1417: FII_FC_TYPE_ASSGNS_GT tab2
1418: where tab2.fin_cat_type_code = tab3.fin_cat_type_code
1419: and hier.child_fin_cat_id = tab3.fin_category_id
1420: and hier.parent_fin_cat_id = tab2.fin_category_id

Line 1586: FII_UTIL.truncate_table ('FII_FULL_FIN_ITEM_HIERS', 'FII', g_retcode);

1582: FII_MESSAGE.Func_Ent(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.'||
1583: 'Handle_Unenabled_DIM');
1584: END IF;
1585:
1586: FII_UTIL.truncate_table ('FII_FULL_FIN_ITEM_HIERS', 'FII', g_retcode);
1587: FII_UTIL.truncate_table ('FII_FIN_ITEM_HIERARCHIES', 'FII', g_retcode);
1588: FII_UTIL.truncate_table ('FII_FIN_CAT_MAPPINGS', 'FII', g_retcode);
1589: FII_UTIL.truncate_table ('FII_FIN_CAT_TYPE_ASSGNS', 'FII', g_retcode);
1590: FII_UTIL.truncate_table ('FII_FIN_ITEM_LEAF_HIERS', 'FII', g_retcode);

Line 1646: FII_UTIL.truncate_table ('FII_FULL_FIN_ITEM_HIERS', 'FII', g_retcode);

1642:
1643: --Copy TMP hierarchy table to the final dimension table
1644: g_phase := 'Copy TMP hierarchy table to the final full dimension table';
1645:
1646: FII_UTIL.truncate_table ('FII_FULL_FIN_ITEM_HIERS', 'FII', g_retcode);
1647:
1648: INSERT /*+ APPEND */ INTO FII_FULL_FIN_ITEM_HIERS (
1649: parent_level,
1650: parent_fin_cat_id,

Line 1648: INSERT /+ APPEND / INTO FII_FULL_FIN_ITEM_HIERS (

1644: g_phase := 'Copy TMP hierarchy table to the final full dimension table';
1645:
1646: FII_UTIL.truncate_table ('FII_FULL_FIN_ITEM_HIERS', 'FII', g_retcode);
1647:
1648: INSERT /*+ APPEND */ INTO FII_FULL_FIN_ITEM_HIERS (
1649: parent_level,
1650: parent_fin_cat_id,
1651: next_level,
1652: next_level_fin_cat_id,

Line 1683: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_FULL_FIN_ITEM_HIERS');

1679: FII_LOGIN_ID
1680: FROM FII_FIN_ITEM_HIER_GT;
1681:
1682: IF (FIIDIM_Debug) THEN
1683: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_FULL_FIN_ITEM_HIERS');
1684: END IF;
1685:
1686: commit;
1687:

Line 1691: g_phase := 'gather_table_stats for FII_FULL_FIN_ITEM_HIERS';

1687:
1688: --Call FND_STATS to collect statistics after re-populating the tables.
1689: --for the full table since it will be used in the program later
1690:
1691: g_phase := 'gather_table_stats for FII_FULL_FIN_ITEM_HIERS';
1692:
1693: FND_STATS.gather_table_stats
1694: (ownname => g_schema_name,
1695: tabname => 'FII_FULL_FIN_ITEM_HIERS');

Line 1695: tabname => 'FII_FULL_FIN_ITEM_HIERS');

1691: g_phase := 'gather_table_stats for FII_FULL_FIN_ITEM_HIERS';
1692:
1693: FND_STATS.gather_table_stats
1694: (ownname => g_schema_name,
1695: tabname => 'FII_FULL_FIN_ITEM_HIERS');
1696:
1697: --==============================================================--
1698:
1699: --Delete LVS records from FII_FIN_ITEM_HIER_GT for pruned hierarchy table for Expense Analysis

Line 2090: --FII_FULL_FIN_ITEM_HIERS does not require an incremental refresh.

2086:
2087: --Copy TMP hierarchy table to the final dimension table
2088: g_phase := 'Copy TMP hierarchy table to the final full dimension table';
2089:
2090: --FII_FULL_FIN_ITEM_HIERS does not require an incremental refresh.
2091: FII_UTIL.truncate_table ('FII_FULL_FIN_ITEM_HIERS', 'FII', g_retcode);
2092:
2093: INSERT /*+ APPEND */ INTO FII_FULL_FIN_ITEM_HIERS (
2094: parent_level,

Line 2091: FII_UTIL.truncate_table ('FII_FULL_FIN_ITEM_HIERS', 'FII', g_retcode);

2087: --Copy TMP hierarchy table to the final dimension table
2088: g_phase := 'Copy TMP hierarchy table to the final full dimension table';
2089:
2090: --FII_FULL_FIN_ITEM_HIERS does not require an incremental refresh.
2091: FII_UTIL.truncate_table ('FII_FULL_FIN_ITEM_HIERS', 'FII', g_retcode);
2092:
2093: INSERT /*+ APPEND */ INTO FII_FULL_FIN_ITEM_HIERS (
2094: parent_level,
2095: parent_fin_cat_id,

Line 2093: INSERT /+ APPEND / INTO FII_FULL_FIN_ITEM_HIERS (

2089:
2090: --FII_FULL_FIN_ITEM_HIERS does not require an incremental refresh.
2091: FII_UTIL.truncate_table ('FII_FULL_FIN_ITEM_HIERS', 'FII', g_retcode);
2092:
2093: INSERT /*+ APPEND */ INTO FII_FULL_FIN_ITEM_HIERS (
2094: parent_level,
2095: parent_fin_cat_id,
2096: next_level,
2097: next_level_fin_cat_id,

Line 2130: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_FULL_FIN_ITEM_HIERS');

2126:
2127: commit;
2128:
2129: IF (FIIDIM_Debug) THEN
2130: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_FULL_FIN_ITEM_HIERS');
2131: END IF;
2132:
2133: --Call FND_STATS to collect statistics after re-populating the tables.
2134: --for the full table since it will be used later in the program

Line 2136: g_phase := 'gather_table_stats for FII_FULL_FIN_ITEM_HIERS';

2132:
2133: --Call FND_STATS to collect statistics after re-populating the tables.
2134: --for the full table since it will be used later in the program
2135:
2136: g_phase := 'gather_table_stats for FII_FULL_FIN_ITEM_HIERS';
2137:
2138: FND_STATS.gather_table_stats
2139: (ownname => g_schema_name,
2140: tabname => 'FII_FULL_FIN_ITEM_HIERS');

Line 2140: tabname => 'FII_FULL_FIN_ITEM_HIERS');

2136: g_phase := 'gather_table_stats for FII_FULL_FIN_ITEM_HIERS';
2137:
2138: FND_STATS.gather_table_stats
2139: (ownname => g_schema_name,
2140: tabname => 'FII_FULL_FIN_ITEM_HIERS');
2141:
2142: --==============================================================--
2143:
2144: --Delete LVS records from FII_FIN_ITEM_HIER_GT for pruned hierarchy table for Expense Analysis