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_PROCESSUNIT_PVT dependencies on AHL_MR_INTERVALS

Line 3606: --FROM ahl_mr_intervals INT, cs_counters_v CTR, cs_counters_v CN

3602: INT.start_value, INT.stop_value, INT.counter_id,
3603: INT.interval_value, INT.tolerance_after, INT.tolerance_before,
3604: INT.earliest_due_value -- added for bug# 6358940.
3605: --Replaced cs_counters_v with cs_counters to fix perf bug# 3786647.
3606: --FROM ahl_mr_intervals INT, cs_counters_v CTR, cs_counters_v CN
3607: --replaced cs_counters CTR with csi_counter_template_vl
3608: --and cs_counters CN with csi_counters_vl CN to fix bug# 5918525.
3609: FROM ahl_mr_intervals INT, csi_counter_template_vl CTR --, csi_counters_vl CN
3610: WHERE INT.counter_id = CTR.counter_id AND

Line 3609: FROM ahl_mr_intervals INT, csi_counter_template_vl CTR --, csi_counters_vl CN

3605: --Replaced cs_counters_v with cs_counters to fix perf bug# 3786647.
3606: --FROM ahl_mr_intervals INT, cs_counters_v CTR, cs_counters_v CN
3607: --replaced cs_counters CTR with csi_counter_template_vl
3608: --and cs_counters CN with csi_counters_vl CN to fix bug# 5918525.
3609: FROM ahl_mr_intervals INT, csi_counter_template_vl CTR --, csi_counters_vl CN
3610: WHERE INT.counter_id = CTR.counter_id AND
3611: --CTR.name = CN.name AND -- bug# 5918525.
3612: --CTR.name = CN.counter_template_name AND -- removed for perf fix.
3613: CTR.name = p_counter_name AND

Line 3652: FROM ahl_mr_intervals int, csi_counter_template_vl ctr

3648:
3649: -- added for performance fix bug# 6893404.
3650: CURSOR get_interval_ctr_name(p_mr_effectivity_id IN NUMBER) IS
3651: SELECT DISTINCT name counter_name
3652: FROM ahl_mr_intervals int, csi_counter_template_vl ctr
3653: WHERE int.mr_effectivity_id = p_mr_effectivity_id
3654: AND int.counter_id = ctr.counter_id;
3655:
3656: --

Line 5281: FROM ahl_mr_intervals INT, cs_counters_v CTR, cs_counters_v CN

5277: p_counter_value IN NUMBER) IS
5278: /*
5279: SELECT INT.start_value, INT.stop_value,
5280: INT.interval_value
5281: FROM ahl_mr_intervals INT, cs_counters_v CTR, cs_counters_v CN
5282: WHERE INT.counter_id = CTR.counter_id AND
5283: CTR.name = CN.name AND
5284: INT.mr_effectivity_id = p_mr_effectivity_id AND
5285: CN.counter_id = p_counter_id AND

Line 5301: AHL_MR_INTERVALS INT,

5297: INT.START_VALUE,
5298: INT.STOP_VALUE,
5299: INT.INTERVAL_VALUE
5300: FROM
5301: AHL_MR_INTERVALS INT,
5302: CSI_COUNTER_TEMPLATE_VL CTR,
5303: --CSI_COUNTER_TEMPLATE_VL CN --bug# 5918525
5304: csi_counters_vl CN
5305: WHERE

Line 5412: FROM ahl_mr_intervals INT, cs_counters_v CTR, cs_counters_v CN

5408: p_counter_id IN NUMBER,
5409: p_stop_date IN DATE) IS
5410: /* SELECT INT.start_date, INT.stop_date,
5411: INT.interval_value
5412: FROM ahl_mr_intervals INT, cs_counters_v CTR, cs_counters_v CN
5413: WHERE INT.counter_id = CTR.counter_id AND
5414: CTR.name = CN.name AND
5415: INT.mr_effectivity_id = p_mr_effectivity_id AND
5416: CN.counter_id = p_counter_id AND

Line 5430: AHL_MR_INTERVALS INT,

5426: INT.START_DATE,
5427: INT.STOP_DATE,
5428: INT.INTERVAL_VALUE
5429: FROM
5430: AHL_MR_INTERVALS INT,
5431: CSI_COUNTER_TEMPLATE_VL CTR,
5432: --CSI_COUNTER_TEMPLATE_VL CN --bug# 5918525
5433: csi_counters_vl CN
5434: WHERE

Line 5542: --FROM ahl_mr_intervals INT, cs_counters_v CTR, cs_counters_v CN

5538: SELECT INT.mr_interval_id, INT.start_date, INT.stop_date,
5539: INT.start_value, INT.stop_value, INT.counter_id,
5540: INT.interval_value, INT.tolerance_after, INT.tolerance_before
5541: -- Replaced cs_counters_v with cs_counters to fix perf bug# 3786647.
5542: --FROM ahl_mr_intervals INT, cs_counters_v CTR, cs_counters_v CN
5543: FROM ahl_mr_intervals INT, cs_counters CTR, cs_counters CN
5544: WHERE INT.counter_id = CTR.counter_id AND
5545: CTR.name = CN.name AND
5546: INT.mr_effectivity_id = p_mr_effectivity_id AND

Line 5543: FROM ahl_mr_intervals INT, cs_counters CTR, cs_counters CN

5539: INT.start_value, INT.stop_value, INT.counter_id,
5540: INT.interval_value, INT.tolerance_after, INT.tolerance_before
5541: -- Replaced cs_counters_v with cs_counters to fix perf bug# 3786647.
5542: --FROM ahl_mr_intervals INT, cs_counters_v CTR, cs_counters_v CN
5543: FROM ahl_mr_intervals INT, cs_counters CTR, cs_counters CN
5544: WHERE INT.counter_id = CTR.counter_id AND
5545: CTR.name = CN.name AND
5546: INT.mr_effectivity_id = p_mr_effectivity_id AND
5547: CN.counter_id = p_counter_id AND

Line 5571: AHL_MR_INTERVALS INT,

5567: INT.TOLERANCE_AFTER,
5568: INT.TOLERANCE_BEFORE,
5569: INT.EARLIEST_DUE_VALUE
5570: FROM
5571: AHL_MR_INTERVALS INT,
5572: CSI_COUNTER_TEMPLATE_VL CTR --,
5573: --CSI_COUNTER_TEMPLATE_VL CN --bug# 5918525
5574: --csi_counters_vl CN
5575: WHERE

Line 5596: --FROM ahl_mr_intervals INT, cs_counters_v CTR, cs_counters_v CN

5592:
5593: /*SELECT INT.mr_interval_id, INT.start_date, INT.stop_date,
5594: INT.tolerance_after, INT.tolerance_before, INT.interval_value
5595: -- Replaced cs_counters_v with cs_counters to fix perf bug# 3786647.
5596: --FROM ahl_mr_intervals INT, cs_counters_v CTR, cs_counters_v CN
5597: FROM ahl_mr_intervals INT, cs_counters CTR, cs_counters CN
5598: WHERE INT.counter_id = CTR.counter_id AND
5599: CTR.name = CN.name AND
5600: INT.mr_effectivity_id = p_mr_effectivity_id AND

Line 5597: FROM ahl_mr_intervals INT, cs_counters CTR, cs_counters CN

5593: /*SELECT INT.mr_interval_id, INT.start_date, INT.stop_date,
5594: INT.tolerance_after, INT.tolerance_before, INT.interval_value
5595: -- Replaced cs_counters_v with cs_counters to fix perf bug# 3786647.
5596: --FROM ahl_mr_intervals INT, cs_counters_v CTR, cs_counters_v CN
5597: FROM ahl_mr_intervals INT, cs_counters CTR, cs_counters CN
5598: WHERE INT.counter_id = CTR.counter_id AND
5599: CTR.name = CN.name AND
5600: INT.mr_effectivity_id = p_mr_effectivity_id AND
5601: CN.counter_id = p_counter_id AND

Line 5622: AHL_MR_INTERVALS INT,

5618: INT.TOLERANCE_BEFORE,
5619: INT.INTERVAL_VALUE,
5620: INT.EARLIEST_DUE_VALUE
5621: FROM
5622: AHL_MR_INTERVALS INT,
5623: CSI_COUNTER_TEMPLATE_VL CTR --,
5624: --CSI_COUNTER_TEMPLATE_VL CN --bug# 5918525
5625: --csi_counters_vl CN
5626: WHERE

Line 6911: FROM ahl_mr_intervals_v

6907:
6908: -- get all intervals for an effectivity.
6909: CURSOR ahl_mr_interval_csr (p_mr_effectivity_id IN NUMBER) IS
6910: SELECT start_value, stop_value, counter_id, counter_name, mr_interval_id
6911: FROM ahl_mr_intervals_v
6912: WHERE mr_effectivity_id = p_mr_effectivity_id;
6913:
6914: l_effectivity_rec ahl_program_eff_csr%ROWTYPE;
6915: