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 3943: -- Fix for bug# 6956784. Replace CS_COUNTERS with csi_counter_template_vl.

3939: CURSOR get_unmatched_counter(p_mr_effectivity_id IN NUMBER,
3940: p_instance_id IN NUMBER,
3941: p_unit_effectivity_id IN NUMBER)
3942: IS
3943: -- Fix for bug# 6956784. Replace CS_COUNTERS with csi_counter_template_vl.
3944: -- select distinct name counter_name from cs_counters co, ahl_mr_intervals mr
3945: select distinct name counter_name from csi_counter_template_vl co, ahl_mr_intervals mr
3946: where co.counter_id = mr.counter_id
3947: and mr.mr_effectivity_id = p_mr_effectivity_id

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

3941: p_unit_effectivity_id IN NUMBER)
3942: IS
3943: -- Fix for bug# 6956784. Replace CS_COUNTERS with csi_counter_template_vl.
3944: -- select distinct name counter_name from cs_counters co, ahl_mr_intervals mr
3945: select distinct name counter_name from csi_counter_template_vl co, ahl_mr_intervals mr
3946: where co.counter_id = mr.counter_id
3947: and mr.mr_effectivity_id = p_mr_effectivity_id
3948: intersect
3949: /* Fix for bug# 6956784. Replace CS_COUNTERS with CSI_COUNTERS_VL.

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

4018: END IF;
4019: END IF;
4020:
4021: -- Counters for the given MR
4022: -- Modified from cs_counters_v to csi_counter_template_vl for R12 bug# 6080133.
4023: --l_fmp_sql := ' select distinct name counter_name from cs_counters_v co, ahl_mr_intervals mr';
4024: l_fmp_sql := ' select distinct name counter_name from csi_counter_template_vl co, ahl_mr_intervals mr';
4025: l_fmp_sql := l_fmp_sql || ' where co.counter_id = mr.counter_id and';
4026: l_fmp_sql := l_fmp_sql || ' mr.mr_effectivity_id in ' || l_fmp_eff;

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

4020:
4021: -- Counters for the given MR
4022: -- Modified from cs_counters_v to csi_counter_template_vl for R12 bug# 6080133.
4023: --l_fmp_sql := ' select distinct name counter_name from cs_counters_v co, ahl_mr_intervals mr';
4024: l_fmp_sql := ' select distinct name counter_name from csi_counter_template_vl co, ahl_mr_intervals mr';
4025: l_fmp_sql := l_fmp_sql || ' where co.counter_id = mr.counter_id and';
4026: l_fmp_sql := l_fmp_sql || ' mr.mr_effectivity_id in ' || l_fmp_eff;
4027:
4028: -- Counters for the given item instance