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_UTILITIES_PVT dependencies on BIS_DIMENSIONS

Line 2576: FROM bis_indicator_dimensions x, bis_dimensions y, bis_target_levels z

2572: )
2573: IS
2574: CURSOR c_seq(p_targetlevel_id in NUMBER, p_dim IN VARCHAR2) IS
2575: SELECT x.sequence_no
2576: FROM bis_indicator_dimensions x, bis_dimensions y, bis_target_levels z
2577: WHERE x.dimension_id = y.dimension_id
2578: AND y.short_name like p_dim
2579: AND x.indicator_id = z.indicator_id
2580: AND ((z.target_level_id = p_targetlevel_id and p_targetlevel_id is not null) OR

Line 2789: FROM bis_indicator_dimensions x, bis_dimensions y, bis_target_levels z

2785: )
2786: IS
2787: CURSOR c_seq(p_targetlevel_id in NUMBER, p_dim IN VARCHAR2) IS
2788: SELECT x.sequence_no
2789: FROM bis_indicator_dimensions x, bis_dimensions y, bis_target_levels z
2790: WHERE x.dimension_id = y.dimension_id
2791: AND y.short_name like p_dim
2792: AND x.indicator_id = z.indicator_id
2793: AND z.target_level_id = p_targetlevel_id;

Line 2983: FROM bis_indicator_dimensions x, bis_dimensions y, bis_target_levels z

2979: )
2980: IS
2981: CURSOR c_seq(p_targetlevel_id in NUMBER, p_dim IN VARCHAR2) IS
2982: SELECT x.sequence_no
2983: FROM bis_indicator_dimensions x, bis_dimensions y, bis_target_levels z
2984: WHERE x.dimension_id = y.dimension_id
2985: AND y.short_name like p_dim
2986: AND x.indicator_id = z.indicator_id
2987: AND ((z.target_level_id = p_targetlevel_id and p_targetlevel_id is not null) OR

Line 3083: FROM bis_indicator_dimensions x, bis_dimensions y, bis_target_levels z

3079: )
3080: IS
3081: CURSOR c_seq(p_targetlevel_id in NUMBER, p_dim IN VARCHAR2) IS
3082: SELECT x.sequence_no
3083: FROM bis_indicator_dimensions x, bis_dimensions y, bis_target_levels z
3084: WHERE x.dimension_id = y.dimension_id
3085: AND y.short_name like p_dim
3086: AND x.indicator_id = z.indicator_id
3087: AND ((z.target_level_id = p_targetlevel_id and p_targetlevel_id is not null) OR

Line 3527: from bis_dimensions where dimension_id in

3523: 'EDW_ORGA_OPER_UNIT', 'EDW_ORGA_ORG');
3524:
3525: select short_name
3526: into l_dim_short_name
3527: from bis_dimensions where dimension_id in
3528: (select dimension_id from bis_levels where short_name = l_level_short_name);
3529:
3530:
3531: exception