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.GL_BIS_ALERTS_PKG dependencies on BISBV_DIMENSION_LEVELS

Line 45: bisbv_dimension_levels dl1,

41: workflow_item_type wf_item_type,
42: workflow_process_short_name wf_process
43: FROM bis_indicators ind,
44: bisbv_target_levels tl,
45: bisbv_dimension_levels dl1,
46: bisbv_dimension_levels dl2
47: WHERE ind.short_name = c_gl_revenue_pm
48: AND tl.measure_id = ind.indicator_id
49: AND dl1.dimension_level_id = tl.dimension1_level_id

Line 46: bisbv_dimension_levels dl2

42: workflow_process_short_name wf_process
43: FROM bis_indicators ind,
44: bisbv_target_levels tl,
45: bisbv_dimension_levels dl1,
46: bisbv_dimension_levels dl2
47: WHERE ind.short_name = c_gl_revenue_pm
48: AND tl.measure_id = ind.indicator_id
49: AND dl1.dimension_level_id = tl.dimension1_level_id
50: AND dl2.dimension_level_id = tl.dimension2_level_id

Line 443: FROM bisbv_dimension_levels dl

439: -- character to number conversion error
440: IF p_dim1_id = '-1' THEN
441: SELECT dl.dimension_level_name, dl.dimension_level_name
442: INTO l_dim1_value, l_dim1_name
443: FROM bisbv_dimension_levels dl
444: WHERE dl.dimension_level_short_name = c_t_gl_companys;
445: ELSE
446: l_dim1_value := p_dim1_id;
447: SELECT dl.dimension_level_name

Line 449: FROM bisbv_dimension_levels dl

445: ELSE
446: l_dim1_value := p_dim1_id;
447: SELECT dl.dimension_level_name
448: INTO l_dim1_name
449: FROM bisbv_dimension_levels dl
450: WHERE dl.dimension_level_short_name = c_gl_company;
451: END IF;
452:
453: --for bug 2166758: change -1 to '-1' to avoid

Line 459: FROM bisbv_dimension_levels dl

455: -- character to number conversion error
456: IF p_dim2_id = '-1' THEN
457: SELECT dl.dimension_level_name, dl.dimension_level_name
458: INTO l_dim2_value, l_dim2_name
459: FROM bisbv_dimension_levels dl
460: WHERE dl.dimension_level_short_name = c_t_gl_sms;
461: ELSE
462: l_dim2_value := p_dim2_id;
463: SELECT dl.dimension_level_name

Line 465: FROM bisbv_dimension_levels dl

461: ELSE
462: l_dim2_value := p_dim2_id;
463: SELECT dl.dimension_level_name
464: INTO l_dim2_name
465: FROM bisbv_dimension_levels dl
466: WHERE dl.dimension_level_short_name = c_gl_sm;
467: END IF;
468:
469: IF p_type = 'ABOVE' THEN

Line 897: bisbv_dimension_levels dl,

893:
894: CURSOR c_segment1_num IS
895: SELECT sg.segment_num
896: FROM bisbv_target_levels tl,
897: bisbv_dimension_levels dl,
898: gl_sets_of_books sob,
899: bis_flex_mappings_v fm,
900: fnd_id_flex_segments sg
901: WHERE tl.target_level_id = p_target_rec.target_level_id

Line 917: bisbv_dimension_levels dl,

913:
914: CURSOR c_segment2_num IS
915: SELECT sg.segment_num
916: FROM bisbv_target_levels tl,
917: bisbv_dimension_levels dl,
918: gl_sets_of_books sob,
919: bis_flex_mappings_v fm,
920: fnd_id_flex_segments sg
921: WHERE tl.target_level_id = p_target_rec.target_level_id