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 4623: --FROM ahl_mr_intervals INT, cs_counters_v CTR, cs_counters_v CN

4619: INT.interval_value, INT.tolerance_after, INT.tolerance_before,
4620: INT.earliest_due_value, -- added for bug# 6358940.
4621: INT.calc_duedate_rule_code -- added for ER 7415856
4622: --Replaced cs_counters_v with cs_counters to fix perf bug# 3786647.
4623: --FROM ahl_mr_intervals INT, cs_counters_v CTR, cs_counters_v CN
4624: --replaced cs_counters CTR with csi_counter_template_vl
4625: --and cs_counters CN with csi_counters_vl CN to fix bug# 5918525.
4626: FROM ahl_mr_intervals INT, csi_counter_template_vl CTR --, csi_counters_vl CN
4627: WHERE INT.counter_id = CTR.counter_id AND

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

4622: --Replaced cs_counters_v with cs_counters to fix perf bug# 3786647.
4623: --FROM ahl_mr_intervals INT, cs_counters_v CTR, cs_counters_v CN
4624: --replaced cs_counters CTR with csi_counter_template_vl
4625: --and cs_counters CN with csi_counters_vl CN to fix bug# 5918525.
4626: FROM ahl_mr_intervals INT, csi_counter_template_vl CTR --, csi_counters_vl CN
4627: WHERE INT.counter_id = CTR.counter_id AND
4628: --CTR.name = CN.name AND -- bug# 5918525.
4629: --CTR.name = CN.counter_template_name AND -- removed for perf fix.
4630: CTR.name = p_counter_name AND

Line 4671: FROM ahl_mr_intervals int, csi_counter_template_vl ctr

4667:
4668: -- added for performance fix bug# 6893404.
4669: CURSOR get_interval_ctr_name(p_mr_effectivity_id IN NUMBER) IS
4670: SELECT DISTINCT name counter_name
4671: FROM ahl_mr_intervals int, csi_counter_template_vl ctr
4672: WHERE int.mr_effectivity_id = p_mr_effectivity_id
4673: AND int.counter_id = ctr.counter_id;
4674:
4675: --

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

6543: p_counter_value IN NUMBER) IS
6544: /*
6545: SELECT INT.start_value, INT.stop_value,
6546: INT.interval_value
6547: FROM ahl_mr_intervals INT, cs_counters_v CTR, cs_counters_v CN
6548: WHERE INT.counter_id = CTR.counter_id AND
6549: CTR.name = CN.name AND
6550: INT.mr_effectivity_id = p_mr_effectivity_id AND
6551: CN.counter_id = p_counter_id AND

Line 6567: AHL_MR_INTERVALS INT,

6563: INT.START_VALUE,
6564: INT.STOP_VALUE,
6565: INT.INTERVAL_VALUE
6566: FROM
6567: AHL_MR_INTERVALS INT,
6568: CSI_COUNTER_TEMPLATE_VL CTR,
6569: --CSI_COUNTER_TEMPLATE_VL CN --bug# 5918525
6570: csi_counters_vl CN
6571: WHERE

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

6674: p_counter_id IN NUMBER,
6675: p_stop_date IN DATE) IS
6676: /* SELECT INT.start_date, INT.stop_date,
6677: INT.interval_value
6678: FROM ahl_mr_intervals INT, cs_counters_v CTR, cs_counters_v CN
6679: WHERE INT.counter_id = CTR.counter_id AND
6680: CTR.name = CN.name AND
6681: INT.mr_effectivity_id = p_mr_effectivity_id AND
6682: CN.counter_id = p_counter_id AND

Line 6696: AHL_MR_INTERVALS INT,

6692: INT.START_DATE,
6693: INT.STOP_DATE,
6694: INT.INTERVAL_VALUE
6695: FROM
6696: AHL_MR_INTERVALS INT,
6697: CSI_COUNTER_TEMPLATE_VL CTR,
6698: --CSI_COUNTER_TEMPLATE_VL CN --bug# 5918525
6699: csi_counters_vl CN
6700: WHERE

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

6804: SELECT INT.mr_interval_id, INT.start_date, INT.stop_date,
6805: INT.start_value, INT.stop_value, INT.counter_id,
6806: INT.interval_value, INT.tolerance_after, INT.tolerance_before
6807: -- Replaced cs_counters_v with cs_counters to fix perf bug# 3786647.
6808: --FROM ahl_mr_intervals INT, cs_counters_v CTR, cs_counters_v CN
6809: FROM ahl_mr_intervals INT, cs_counters CTR, cs_counters CN
6810: WHERE INT.counter_id = CTR.counter_id AND
6811: CTR.name = CN.name AND
6812: INT.mr_effectivity_id = p_mr_effectivity_id AND

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

6805: INT.start_value, INT.stop_value, INT.counter_id,
6806: INT.interval_value, INT.tolerance_after, INT.tolerance_before
6807: -- Replaced cs_counters_v with cs_counters to fix perf bug# 3786647.
6808: --FROM ahl_mr_intervals INT, cs_counters_v CTR, cs_counters_v CN
6809: FROM ahl_mr_intervals INT, cs_counters CTR, cs_counters CN
6810: WHERE INT.counter_id = CTR.counter_id AND
6811: CTR.name = CN.name AND
6812: INT.mr_effectivity_id = p_mr_effectivity_id AND
6813: CN.counter_id = p_counter_id AND

Line 6838: AHL_MR_INTERVALS INT,

6834: INT.TOLERANCE_BEFORE,
6835: INT.EARLIEST_DUE_VALUE,
6836: INT.CALC_DUEDATE_RULE_CODE -- added for ER 7415856
6837: FROM
6838: AHL_MR_INTERVALS INT,
6839: CSI_COUNTER_TEMPLATE_VL CTR --,
6840: --CSI_COUNTER_TEMPLATE_VL CN --bug# 5918525
6841: --csi_counters_vl CN
6842: WHERE

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

6859:
6860: /*SELECT INT.mr_interval_id, INT.start_date, INT.stop_date,
6861: INT.tolerance_after, INT.tolerance_before, INT.interval_value
6862: -- Replaced cs_counters_v with cs_counters to fix perf bug# 3786647.
6863: --FROM ahl_mr_intervals INT, cs_counters_v CTR, cs_counters_v CN
6864: FROM ahl_mr_intervals INT, cs_counters CTR, cs_counters CN
6865: WHERE INT.counter_id = CTR.counter_id AND
6866: CTR.name = CN.name AND
6867: INT.mr_effectivity_id = p_mr_effectivity_id AND

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

6860: /*SELECT INT.mr_interval_id, INT.start_date, INT.stop_date,
6861: INT.tolerance_after, INT.tolerance_before, INT.interval_value
6862: -- Replaced cs_counters_v with cs_counters to fix perf bug# 3786647.
6863: --FROM ahl_mr_intervals INT, cs_counters_v CTR, cs_counters_v CN
6864: FROM ahl_mr_intervals INT, cs_counters CTR, cs_counters CN
6865: WHERE INT.counter_id = CTR.counter_id AND
6866: CTR.name = CN.name AND
6867: INT.mr_effectivity_id = p_mr_effectivity_id AND
6868: CN.counter_id = p_counter_id AND

Line 6890: AHL_MR_INTERVALS INT,

6886: INT.INTERVAL_VALUE,
6887: INT.EARLIEST_DUE_VALUE,
6888: INT.CALC_DUEDATE_RULE_CODE -- added for ER 7415856
6889: FROM
6890: AHL_MR_INTERVALS INT,
6891: CSI_COUNTER_TEMPLATE_VL CTR --,
6892: --CSI_COUNTER_TEMPLATE_VL CN --bug# 5918525
6893: --csi_counters_vl CN
6894: WHERE

Line 8381: FROM ahl_mr_intervals_v

8377:
8378: -- get all intervals for an effectivity.
8379: CURSOR ahl_mr_interval_csr (p_mr_effectivity_id IN NUMBER) IS
8380: SELECT start_value, stop_value, counter_id, counter_name, mr_interval_id
8381: FROM ahl_mr_intervals_v
8382: WHERE mr_effectivity_id = p_mr_effectivity_id;
8383:
8384: l_effectivity_rec ahl_program_eff_csr%ROWTYPE;
8385: