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_VL

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 2752: bsc_sys_dim_levels_vl dim_lev,

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
2756: AND dim_lev_by_group.dim_level_id = dim_lev.dim_level_id