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_VL

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