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_EA_UTIL_PKG dependencies on FII_FIN_CAT_TYPE_ASSGNS

Line 541: FROM fii_fin_cat_type_assgns a, fii_fin_item_leaf_hiers b

537: -- fix for bug 4127077. The following cursor checks for the presence of any top node which is also a leaf node
538:
539: CURSOR get_leaf_top_nodes(g_fin_cat_type VARCHAR2) IS
540: SELECT a.fin_category_id
541: FROM fii_fin_cat_type_assgns a, fii_fin_item_leaf_hiers b
542: WHERE a.FIN_CAT_TYPE_CODE = g_fin_cat_type
543: AND a.TOP_NODE_FLAG = 'Y'
544: and a.fin_category_id = b.CHILD_FIN_CAT_ID
545: and b.is_leaf_flag = 'Y';

Line 565: FROM fii_fin_cat_type_assgns a

561: p_nonaggrt_viewby_id := 'cc_hier.parent_cc_id';
562: WHEN 'FINANCIAL ITEM+GL_FII_FIN_ITEM' THEN
563: IF g_fin_category_id = 'All' THEN
564: SELECT count(*) INTO g_fin_cat_top_node_count
565: FROM fii_fin_cat_type_assgns a
566: WHERE a.FIN_CAT_TYPE_CODE = g_fin_cat_type
567: AND a.TOP_NODE_FLAG = 'Y';
568:
569: IF g_top_node_is_leaf = 'Y' THEN

Line 1198: FROM fii_fin_cat_type_assgns a

1194:
1195:
1196: IF g_view_by <> 'FINANCIAL ITEM+GL_FII_FIN_ITEM' THEN
1197: l_aggrt_cat_join := 'EXISTS ( SELECT 1
1198: FROM fii_fin_cat_type_assgns a
1199: , fii_fin_item_leaf_hiers b
1200: WHERE a.FIN_CAT_TYPE_CODE = :g_fin_cat_type
1201: AND a.TOP_NODE_FLAG = ''Y''
1202: and a.fin_category_id = b.CHILD_FIN_CAT_ID

Line 1209: FROM fii_fin_cat_type_assgns a

1205: ) and (child_level <> parent_level AND child_level = parent_level+1)';
1206:
1207: ELSIF g_top_node_is_leaf = 'N' THEN
1208: l_aggrt_cat_join := 'EXISTS ( SELECT 1
1209: FROM fii_fin_cat_type_assgns a
1210: , fii_fin_item_leaf_hiers b
1211: WHERE a.FIN_CAT_TYPE_CODE = :g_fin_cat_type
1212: AND a.TOP_NODE_FLAG = ''Y''
1213: and a.fin_category_id = b.CHILD_FIN_CAT_ID

Line 1219: FROM fii_fin_cat_type_assgns a

1215: AND a.fin_Category_id = fin_hier.parent_fin_cat_id
1216: ) and (child_level = parent_level OR child_level = parent_level+1)';
1217: ELSE
1218: l_aggrt_cat_join := 'EXISTS ( SELECT 1
1219: FROM fii_fin_cat_type_assgns a
1220: , fii_fin_item_leaf_hiers b
1221: WHERE a.FIN_CAT_TYPE_CODE = :g_fin_cat_type
1222: AND a.TOP_NODE_FLAG = ''Y''
1223: and a.fin_category_id = b.CHILD_FIN_CAT_ID

Line 1237: FROM fii_fin_cat_type_assgns a

1233: IF g_if_trend_sum_mv = 'N' THEN
1234: IF g_fin_cat_top_node_count = 1 THEN
1235:
1236: SELECT a.fin_category_id INTO g_category_id
1237: FROM fii_fin_cat_type_assgns a
1238: WHERE a.FIN_CAT_TYPE_CODE = g_fin_cat_type
1239: and a.TOP_NODE_FLAG = 'Y';
1240:
1241: l_nonaggrt_cat_join := 'EXISTS ( SELECT 1

Line 1242: FROM fii_fin_cat_type_assgns a

1238: WHERE a.FIN_CAT_TYPE_CODE = g_fin_cat_type
1239: and a.TOP_NODE_FLAG = 'Y';
1240:
1241: l_nonaggrt_cat_join := 'EXISTS ( SELECT 1
1242: FROM fii_fin_cat_type_assgns a
1243: , fii_fin_item_leaf_hiers b
1244: WHERE a.FIN_CAT_TYPE_CODE = :g_fin_cat_type
1245: AND a.TOP_NODE_FLAG = ''Y''
1246: and a.fin_category_id = b.CHILD_FIN_CAT_ID

Line 1252: FROM fii_fin_cat_type_assgns a

1248: AND a.fin_Category_id = fin_hier.parent_fin_cat_id
1249: ) and (child_level = parent_level OR child_level = parent_level+1)';
1250: ELSE
1251: l_nonaggrt_cat_join := 'EXISTS ( SELECT 1
1252: FROM fii_fin_cat_type_assgns a
1253: , fii_fin_item_leaf_hiers b
1254: WHERE a.FIN_CAT_TYPE_CODE = :g_fin_cat_type
1255: AND a.TOP_NODE_FLAG = ''Y''
1256: and a.fin_category_id = b.CHILD_FIN_CAT_ID