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.BIS_UTIL dependencies on BSC_SYS_DIM_LEVELS_B

Line 1212: ELSIF ( UPPER(p_table_name) = 'BSC_SYS_DIM_LEVELS_B') THEN

1208: SELECT last_update_date, last_updated_by INTO l_db_last_update_date, l_db_last_updated_by
1209: FROM bsc_sys_dim_groups_vl
1210: WHERE short_name = p_key_value;
1211:
1212: ELSIF ( UPPER(p_table_name) = 'BSC_SYS_DIM_LEVELS_B') THEN
1213: SELECT last_update_date, last_updated_by INTO l_db_last_update_date, l_db_last_updated_by
1214: FROM bsc_sys_dim_levels_b
1215: WHERE short_name = p_key_value;
1216:

Line 1214: FROM bsc_sys_dim_levels_b

1210: WHERE short_name = p_key_value;
1211:
1212: ELSIF ( UPPER(p_table_name) = 'BSC_SYS_DIM_LEVELS_B') THEN
1213: SELECT last_update_date, last_updated_by INTO l_db_last_update_date, l_db_last_updated_by
1214: FROM bsc_sys_dim_levels_b
1215: WHERE short_name = p_key_value;
1216:
1217: END IF;
1218:

Line 1270: FROM bis_dimensions bis_dim, bsc_sys_dim_groups_vl bsc_dim, bis_levels_vl bis_lvl, bsc_sys_dim_levels_b bsc_lvl, bsc_sys_dim_levels_by_group lvl_by_grp

1266: c_dim_object_rec refCursorType;
1267:
1268: l_dim_objects_sql VARCHAR2(1000) :=
1269: 'SELECT bis_lvl.short_name, bis_lvl.name
1270: FROM bis_dimensions bis_dim, bsc_sys_dim_groups_vl bsc_dim, bis_levels_vl bis_lvl, bsc_sys_dim_levels_b bsc_lvl, bsc_sys_dim_levels_by_group lvl_by_grp
1271: WHERE bis_dim.dim_grp_id = bsc_dim.dim_group_id
1272: AND bis_lvl.short_name = bsc_lvl.short_name
1273: AND bsc_dim.dim_group_id = lvl_by_grp.dim_group_id
1274: AND bsc_lvl.dim_level_id = lvl_by_grp.dim_level_id

Line 1326: FROM bsc_sys_dim_levels_b

1322: i NUMBER;
1323: BEGIN
1324:
1325: SELECT level_table_name INTO l_dim_bsc_table
1326: FROM bsc_sys_dim_levels_b
1327: WHERE short_name = p_dim_object;
1328:
1329: l_sql_stmt := ' DELETE FROM ' || l_dim_bsc_table;
1330: EXECUTE IMMEDIATE l_sql_stmt;

Line 1535: FROM bsc_sys_dim_levels_b bsc_lvl, bis_dimensions bis_dim, bsc_sys_dim_levels_by_group lvl_by_grp

1531: l_view_name_rec c_view_name%ROWTYPE;
1532:
1533: CURSOR c_all_enabled IS
1534: SELECT total_flag
1535: FROM bsc_sys_dim_levels_b bsc_lvl, bis_dimensions bis_dim, bsc_sys_dim_levels_by_group lvl_by_grp
1536: WHERE bsc_lvl.dim_level_id = lvl_by_grp.dim_level_id
1537: AND bis_dim.dim_grp_id = lvl_by_grp.dim_group_id
1538: AND bsc_lvl.short_name = p_dim_object
1539: AND bis_dim.short_name = p_dimension;

Line 2451: FROM bsc_sys_dim_groups_vl sys_dim_group, bsc_sys_dim_levels_vl sys_dim_levels, bsc_sys_dim_levels_by_group sys_dim_level_group, bis_levels bis_level, bis_dimensions bis_dim

2447: l_num NUMBER;
2448:
2449: CURSOR c_dim_plus_dimlevel_rel_cursor(l_dim VARCHAR2, l_dim_level VARCHAR2) IS
2450: SELECT 1
2451: FROM bsc_sys_dim_groups_vl sys_dim_group, bsc_sys_dim_levels_vl sys_dim_levels, bsc_sys_dim_levels_by_group sys_dim_level_group, bis_levels bis_level, bis_dimensions bis_dim
2452: WHERE sys_dim_group.dim_group_id = sys_dim_level_group.dim_group_id
2453: AND sys_dim_levels.dim_level_id = sys_dim_level_group.dim_level_id
2454: AND sys_dim_group.dim_group_id = bis_dim.dim_grp_id
2455: AND sys_dim_levels.short_name = bis_level.short_name

Line 2751: bsc_sys_dim_levels_by_group dim_lev_by_group,

2747: l_dim_names VARCHAR2(5000);
2748: CURSOR c_dimensions IS
2749: SELECT dim_group.name
2750: FROM
2751: bsc_sys_dim_levels_by_group dim_lev_by_group,
2752: bsc_sys_dim_levels_vl dim_lev,
2753: bsc_sys_dim_groups_vl dim_group
2754: WHERE
2755: dim_lev.short_name=p_dim_lev_short_name