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.AHL_UMP_UNITMAINT_PVT dependencies on CSI_COUNTER_TEMPLATE_VL

Line 3630: -- Fix for bug# 6956784. Replace CS_COUNTERS with csi_counter_template_vl.

3626: CURSOR get_unmatched_counter(p_mr_effectivity_id IN NUMBER,
3627: p_instance_id IN NUMBER,
3628: p_unit_effectivity_id IN NUMBER)
3629: IS
3630: -- Fix for bug# 6956784. Replace CS_COUNTERS with csi_counter_template_vl.
3631: -- select distinct name counter_name from cs_counters co, ahl_mr_intervals mr
3632: select distinct name counter_name from csi_counter_template_vl co, ahl_mr_intervals mr
3633: where co.counter_id = mr.counter_id
3634: and mr.mr_effectivity_id = p_mr_effectivity_id

Line 3632: select distinct name counter_name from csi_counter_template_vl co, ahl_mr_intervals mr

3628: p_unit_effectivity_id IN NUMBER)
3629: IS
3630: -- Fix for bug# 6956784. Replace CS_COUNTERS with csi_counter_template_vl.
3631: -- select distinct name counter_name from cs_counters co, ahl_mr_intervals mr
3632: select distinct name counter_name from csi_counter_template_vl co, ahl_mr_intervals mr
3633: where co.counter_id = mr.counter_id
3634: and mr.mr_effectivity_id = p_mr_effectivity_id
3635: intersect
3636: /* Fix for bug# 6956784. Replace CS_COUNTERS with CSI_COUNTERS_VL.

Line 3709: -- Modified from cs_counters_v to csi_counter_template_vl for R12 bug# 6080133.

3705: END IF;
3706: END IF;
3707:
3708: -- Counters for the given MR
3709: -- Modified from cs_counters_v to csi_counter_template_vl for R12 bug# 6080133.
3710: --l_fmp_sql := ' select distinct name counter_name from cs_counters_v co, ahl_mr_intervals mr';
3711: l_fmp_sql := ' select distinct name counter_name from csi_counter_template_vl co, ahl_mr_intervals mr';
3712: l_fmp_sql := l_fmp_sql || ' where co.counter_id = mr.counter_id and';
3713: l_fmp_sql := l_fmp_sql || ' mr.mr_effectivity_id in ' || l_fmp_eff;

Line 3711: l_fmp_sql := ' select distinct name counter_name from csi_counter_template_vl co, ahl_mr_intervals mr';

3707:
3708: -- Counters for the given MR
3709: -- Modified from cs_counters_v to csi_counter_template_vl for R12 bug# 6080133.
3710: --l_fmp_sql := ' select distinct name counter_name from cs_counters_v co, ahl_mr_intervals mr';
3711: l_fmp_sql := ' select distinct name counter_name from csi_counter_template_vl co, ahl_mr_intervals mr';
3712: l_fmp_sql := l_fmp_sql || ' where co.counter_id = mr.counter_id and';
3713: l_fmp_sql := l_fmp_sql || ' mr.mr_effectivity_id in ' || l_fmp_eff;
3714:
3715: -- Counters for the given item instance