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_ITEM_LEAF_HIERS

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 1030: FROM fii_fin_item_leaf_hiers fin_hier, fnd_flex_values_tl viewby_dim

1026: l_fin_cat_sql := 'SELECT NULL, NULL, NULL, NULL FROM dual';
1027: ELSIF g_view_by = 'FINANCIAL ITEM+GL_FII_FIN_ITEM' THEN
1028: IF g_top_node_is_leaf = 'Y' THEN
1029: l_fin_cat_sql := 'SELECT fin_hier.parent_fin_cat_id, fin_hier.next_level_fin_cat_id, fin_hier.next_level_fin_cat_sort_order, viewby_dim.description
1030: FROM fii_fin_item_leaf_hiers fin_hier, fnd_flex_values_tl viewby_dim
1031: WHERE viewby_dim.flex_value_id = fin_hier.next_level_fin_cat_id
1032: and viewby_dim.language = userenv(''LANG'')
1033: and '||l_cat_join;
1034: ELSIF (g_fin_cat_top_node_count = 1 or g_fin_cat_top_node_count = 0) THEN

Line 1036: FROM fii_fin_item_leaf_hiers fin_hier, fnd_flex_values_tl viewby_dim

1032: and viewby_dim.language = userenv(''LANG'')
1033: and '||l_cat_join;
1034: ELSIF (g_fin_cat_top_node_count = 1 or g_fin_cat_top_node_count = 0) THEN
1035: l_fin_cat_sql := 'SELECT fin_hier.parent_fin_cat_id, fin_hier.next_level_fin_cat_id, fin_hier.next_level_fin_cat_sort_order, viewby_dim.description
1036: FROM fii_fin_item_leaf_hiers fin_hier, fnd_flex_values_tl viewby_dim
1037: WHERE viewby_dim.flex_value_id = fin_hier.next_level_fin_cat_id
1038: and viewby_dim.language = userenv(''LANG'')
1039: and '||l_cat_join;
1040: ELSE

Line 1042: FROM fii_fin_item_leaf_hiers fin_hier, fnd_flex_values_tl viewby_dim

1038: and viewby_dim.language = userenv(''LANG'')
1039: and '||l_cat_join;
1040: ELSE
1041: l_fin_cat_sql := 'SELECT fin_hier.parent_fin_cat_id, fin_hier.next_level_fin_cat_id, fin_hier.next_level_fin_cat_sort_order, viewby_dim.description
1042: FROM fii_fin_item_leaf_hiers fin_hier, fnd_flex_values_tl viewby_dim
1043: WHERE viewby_dim.flex_value_id = fin_hier.parent_fin_cat_id
1044: and viewby_dim.language = userenv(''LANG'')
1045: and '||l_cat_join;
1046: END IF;

Line 1049: FROM fii_fin_item_leaf_hiers fin_hier

1045: and '||l_cat_join;
1046: END IF;
1047: ELSE
1048: l_fin_cat_sql := 'SELECT fin_hier.parent_fin_cat_id, fin_hier.next_level_fin_cat_id, NULL,NULL
1049: FROM fii_fin_item_leaf_hiers fin_hier
1050: WHERE '||l_cat_join;
1051: END IF;
1052: -- fetch all records FOR Category in category's table of records
1053:

Line 1199: , fii_fin_item_leaf_hiers b

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
1203: and a.fin_category_id <> b.PARENT_FIN_CAT_ID

Line 1210: , fii_fin_item_leaf_hiers b

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
1214: and a.fin_category_id <> b.PARENT_FIN_CAT_ID

Line 1220: , fii_fin_item_leaf_hiers b

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
1224: and a.fin_category_id <> b.PARENT_FIN_CAT_ID

Line 1243: , fii_fin_item_leaf_hiers b

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
1247: and a.fin_category_id <> b.PARENT_FIN_CAT_ID

Line 1253: , fii_fin_item_leaf_hiers b

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
1257: and a.fin_category_id <> b.PARENT_FIN_CAT_ID

Line 1284: FROM fii_fin_item_leaf_hiers

1280:
1281: IF g_fin_cat_is_leaf = 'Y' THEN
1282:
1283: SELECT parent_fin_cat_id INTO g_parent_fin_category_id
1284: FROM fii_fin_item_leaf_hiers
1285: WHERE child_fin_cat_id = g_fin_category_id
1286: and parent_level=child_level-1;
1287: l_aggrt_cat_join := 'parent_fin_cat_id = '||g_parent_fin_category_id||'
1288: and child_fin_cat_id = '||g_fin_category_id;

Line 1296: FROM fii_fin_item_leaf_hiers

1292:
1293: END IF;
1294: ELSE -- we can pick up the parent category directly
1295: SELECT parent_fin_cat_id INTO g_parent_fin_category_id
1296: FROM fii_fin_item_leaf_hiers
1297: WHERE child_fin_cat_id = g_fin_category_id
1298: and parent_level=child_level-1;
1299: l_aggrt_cat_join := 'parent_fin_cat_id = '||g_parent_fin_category_id||'
1300: and child_fin_cat_id = '||g_fin_category_id;

Line 1304: FROM fii_fin_item_leaf_hiers

1300: and child_fin_cat_id = '||g_fin_category_id;
1301: END IF;
1302:
1303: SELECT is_leaf_flag INTO l_leaf_flag
1304: FROM fii_fin_item_leaf_hiers
1305: WHERE parent_fin_cat_id=g_fin_category_id
1306: and parent_fin_cat_id = child_fin_cat_id;
1307:
1308: IF l_leaf_flag = 'Y' THEN

Line 2038: FROM fii_fin_item_leaf_hiers

2034: g_id := NVL(g_category_id,-9999);
2035:
2036: IF g_fin_cat_top_node_count = 1 or g_fin_cat_top_node_count = 0 THEN
2037: SELECT is_leaf_flag INTO g_fin_cat_is_leaf
2038: FROM fii_fin_item_leaf_hiers
2039: WHERE parent_fin_cat_id = p_id
2040: and parent_fin_cat_id = child_fin_cat_id;
2041: END IF;
2042: