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 4624: --replaced cs_counters CTR with csi_counter_template_vl

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

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

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

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

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

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

6685:
6686: --Priyan
6687: --Query being changed due to performance related fixes
6688: --Refer Bug # 4918744
6689: --Changes the usage of CS_COUNTERS_V to CSI_COUNTER_TEMPLATE_VL
6690:
6691: SELECT
6692: INT.START_DATE,
6693: INT.STOP_DATE,

Line 6697: CSI_COUNTER_TEMPLATE_VL CTR,

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

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

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

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

6817:
6818: --Priyan
6819: --Query being changed due to performance related fixes
6820: --Refer Bug # 4918744
6821: --Changes the usage of CS_COUNTERS_V to CSI_COUNTER_TEMPLATE_VL
6822: -- select first row only.
6823: SELECT *
6824: FROM (
6825: SELECT

Line 6839: CSI_COUNTER_TEMPLATE_VL CTR --,

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

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

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

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

6872:
6873: --Priyan
6874: --Query being changed due to performance related fixes
6875: --Refer Bug # 4918744
6876: --Changes the usage of CS_COUNTERS_V to CSI_COUNTER_TEMPLATE_VL
6877: -- select first row only.
6878: SELECT *
6879: FROM (
6880: SELECT

Line 6891: CSI_COUNTER_TEMPLATE_VL CTR --,

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

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

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