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 BIS_LEVELS

Line 462: FROM BIS_LEVELS lt

458: , lt.LEVEL_VALUES_VIEW_NAME
459: INTO l_time_level
460: , l_org_level
461: , l_view_name
462: FROM BIS_LEVELS lt
463: , BIS_LEVELS lo
464: , BIS_TARGET_LEVELS tl
465: WHERE tl.Target_level_id = p_Target_Level_id
466: AND lt.Level_ID = tl.Time_Level_id

Line 463: , BIS_LEVELS lo

459: INTO l_time_level
460: , l_org_level
461: , l_view_name
462: FROM BIS_LEVELS lt
463: , BIS_LEVELS lo
464: , BIS_TARGET_LEVELS tl
465: WHERE tl.Target_level_id = p_Target_Level_id
466: AND lt.Level_ID = tl.Time_Level_id
467: AND lo.Level_ID = tl.org_Level_id;

Line 1195: ELSIF ( UPPER(p_table_name) = 'BIS_LEVELS_TL') THEN

1191: WHERE dim.short_name = p_key_value
1192: AND dim_tl.dimension_id = dim.dimension_id
1193: AND dim_tl.language = USERENV('LANG');
1194:
1195: ELSIF ( UPPER(p_table_name) = 'BIS_LEVELS_TL') THEN
1196: SELECT lev_tl.last_update_date, lev_tl.last_updated_by INTO l_db_last_update_date, l_db_last_updated_by
1197: FROM bis_levels_tl lev_tl, bis_levels lev
1198: WHERE lev.short_name = p_key_value
1199: AND lev.level_id = lev_tl.level_id

Line 1197: FROM bis_levels_tl lev_tl, bis_levels lev

1193: AND dim_tl.language = USERENV('LANG');
1194:
1195: ELSIF ( UPPER(p_table_name) = 'BIS_LEVELS_TL') THEN
1196: SELECT lev_tl.last_update_date, lev_tl.last_updated_by INTO l_db_last_update_date, l_db_last_updated_by
1197: FROM bis_levels_tl lev_tl, bis_levels lev
1198: WHERE lev.short_name = p_key_value
1199: AND lev.level_id = lev_tl.level_id
1200: AND USERENV('LANG') = lev_tl.language;
1201:

Line 1202: ELSIF ( UPPER(p_table_name) = 'BIS_LEVELS') THEN

1198: WHERE lev.short_name = p_key_value
1199: AND lev.level_id = lev_tl.level_id
1200: AND USERENV('LANG') = lev_tl.language;
1201:
1202: ELSIF ( UPPER(p_table_name) = 'BIS_LEVELS') THEN
1203: SELECT last_update_date, last_updated_by INTO l_db_last_update_date, l_db_last_updated_by
1204: FROM bis_levels
1205: WHERE short_name = p_key_value;
1206:

Line 1204: FROM bis_levels

1200: AND USERENV('LANG') = lev_tl.language;
1201:
1202: ELSIF ( UPPER(p_table_name) = 'BIS_LEVELS') THEN
1203: SELECT last_update_date, last_updated_by INTO l_db_last_update_date, l_db_last_updated_by
1204: FROM bis_levels
1205: WHERE short_name = p_key_value;
1206:
1207: ELSIF ( UPPER(p_table_name) = 'BSC_SYS_DIM_GROUPS_VL') THEN
1208: SELECT last_update_date, last_updated_by INTO l_db_last_update_date, l_db_last_updated_by

Line 1263: l_dim_object_name bis_levels_vl.name%TYPE;

1259: ) RETURN VARCHAR2
1260: IS
1261: l_dim_object_names VARCHAR2(2000);
1262: l_dim_object_sht_names VARCHAR2(2000);
1263: l_dim_object_name bis_levels_vl.name%TYPE;
1264: l_dim_object_sht_name bis_levels_vl.short_name%TYPE;
1265: TYPE refCursorType IS REF CURSOR ;
1266: c_dim_object_rec refCursorType;
1267:

Line 1264: l_dim_object_sht_name bis_levels_vl.short_name%TYPE;

1260: IS
1261: l_dim_object_names VARCHAR2(2000);
1262: l_dim_object_sht_names VARCHAR2(2000);
1263: l_dim_object_name bis_levels_vl.name%TYPE;
1264: l_dim_object_sht_name bis_levels_vl.short_name%TYPE;
1265: TYPE refCursorType IS REF CURSOR ;
1266: c_dim_object_rec refCursorType;
1267:
1268: l_dim_objects_sql VARCHAR2(1000) :=

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 1529: FROM bis_levels

1525: )
1526: IS
1527: CURSOR c_view_name IS
1528: SELECT level_values_view_name
1529: FROM bis_levels
1530: WHERE short_name = p_dim_object;
1531: l_view_name_rec c_view_name%ROWTYPE;
1532:
1533: CURSOR c_all_enabled IS

Line 2446: l_dim_level bis_levels.short_name%TYPE;

2442:
2443: l_dim_plus_dimlevel VARCHAR2(100);
2444: l_pos NUMBER;
2445: l_dim bis_indicators.short_name%TYPE;
2446: l_dim_level bis_levels.short_name%TYPE;
2447: l_num NUMBER;
2448:
2449: CURSOR c_dim_plus_dimlevel_rel_cursor(l_dim VARCHAR2, l_dim_level VARCHAR2) IS
2450: SELECT 1

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