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 CSI_COUNTER_TEMPLATE_VL

Line 3607: --replaced cs_counters CTR with csi_counter_template_vl

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
3611: --CTR.name = CN.name AND -- bug# 5918525.

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 5302: CSI_COUNTER_TEMPLATE_VL CTR,

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
5306: INT.COUNTER_ID = CTR.COUNTER_ID AND

Line 5303: --CSI_COUNTER_TEMPLATE_VL CN --bug# 5918525

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
5306: INT.COUNTER_ID = CTR.COUNTER_ID AND
5307: --CTR.NAME = CN.NAME AND -- bug# 5918525

Line 5423: --Changes the usage of CS_COUNTERS_V to CSI_COUNTER_TEMPLATE_VL

5419:
5420: --Priyan
5421: --Query being changed due to performance related fixes
5422: --Refer Bug # 4918744
5423: --Changes the usage of CS_COUNTERS_V to CSI_COUNTER_TEMPLATE_VL
5424:
5425: SELECT
5426: INT.START_DATE,
5427: INT.STOP_DATE,

Line 5431: CSI_COUNTER_TEMPLATE_VL CTR,

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
5435: INT.COUNTER_ID = CTR.COUNTER_ID

Line 5432: --CSI_COUNTER_TEMPLATE_VL CN --bug# 5918525

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
5435: INT.COUNTER_ID = CTR.COUNTER_ID
5436: --AND CTR.NAME = CN.NAME --bug# 5918525

Line 5555: --Changes the usage of CS_COUNTERS_V to CSI_COUNTER_TEMPLATE_VL

5551:
5552: --Priyan
5553: --Query being changed due to performance related fixes
5554: --Refer Bug # 4918744
5555: --Changes the usage of CS_COUNTERS_V to CSI_COUNTER_TEMPLATE_VL
5556: -- select first row only.
5557: SELECT *
5558: FROM (
5559: SELECT

Line 5572: CSI_COUNTER_TEMPLATE_VL CTR --,

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
5576: INT.COUNTER_ID = CTR.COUNTER_ID

Line 5573: --CSI_COUNTER_TEMPLATE_VL CN --bug# 5918525

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
5576: INT.COUNTER_ID = CTR.COUNTER_ID
5577: -- AND CTR.NAME = CN.NAME --bug# 5918525

Line 5609: --Changes the usage of CS_COUNTERS_V to CSI_COUNTER_TEMPLATE_VL

5605:
5606: --Priyan
5607: --Query being changed due to performance related fixes
5608: --Refer Bug # 4918744
5609: --Changes the usage of CS_COUNTERS_V to CSI_COUNTER_TEMPLATE_VL
5610: -- select first row only.
5611: SELECT *
5612: FROM (
5613: SELECT

Line 5623: CSI_COUNTER_TEMPLATE_VL CTR --,

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
5627: INT.COUNTER_ID = CTR.COUNTER_ID

Line 5624: --CSI_COUNTER_TEMPLATE_VL CN --bug# 5918525

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
5627: INT.COUNTER_ID = CTR.COUNTER_ID
5628: --AND CTR.NAME = CN.NAME --bug# 5918525