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.

[Home] [Help]

APPS.AHL_UMP_PROCESSUNIT_PVT dependencies on CSI_COUNTERS_VL

Line 2331: from csi_counter_associations cca, csi_counters_vl cc

2327: ORDER BY uom_code;
2328:
2329: SELECT cc.counter_id, cc.uom_code,
2330: cc.counter_template_name counter_name
2331: from csi_counter_associations cca, csi_counters_vl cc
2332: where cca.counter_id = cc.counter_id
2333: AND source_object_code = 'CP'
2334: AND source_object_id = p_csi_instance_id;
2335: */

Line 2346: FROM csi_counter_associations cca, csi_counters_vl cc

2342: where ccr.counter_id = cc.counter_id
2343: and value_timestamp = (select max(value_timestamp) from csi_counter_readings rd
2344: where counter_id = cc.counter_id
2345: and nvl(disabled_flag,'N') = 'N')) net_reading
2346: FROM csi_counter_associations cca, csi_counters_vl cc
2347: WHERE cca.counter_id = cc.counter_id
2348: AND source_object_code = 'CP'
2349: AND source_object_id = p_csi_item_instance_id;
2350: */

Line 2359: FROM csi_counter_associations cca, csi_counters_vl cc

2355: (select ccr.net_reading
2356: from csi_counter_readings ccr
2357: where ccr.counter_value_id = cc.CTR_VAL_MAX_SEQ_NO
2358: and nvl(ccr.disabled_flag,'N') = 'N')
2359: FROM csi_counter_associations cca, csi_counters_vl cc
2360: WHERE cca.counter_id = cc.counter_id
2361: AND source_object_code = 'CP'
2362: AND source_object_id = p_csi_instance_id;
2363:

Line 2494: --Changed the usage of CS_COUNTERS_V to CSI_COUNTERS_VL

2490:
2491: --Priyan
2492: --Query being changed due to performance related fixes
2493: --Refer Bug # 4918744
2494: --Changed the usage of CS_COUNTERS_V to CSI_COUNTERS_VL
2495:
2496: SELECT
2497: UA.COUNTER_ID,
2498: UA.COUNTER_VALUE,

Line 2504: CSI_COUNTERS_VL CS

2500: --CS.NAME COUNTER_NAME
2501: CS.COUNTER_TEMPLATE_NAME COUNTER_NAME
2502: FROM
2503: AHL_UNIT_ACCOMPLISHMNTS UA,
2504: CSI_COUNTERS_VL CS
2505: WHERE
2506: UA.COUNTER_ID = CS.COUNTER_ID AND
2507: UA.UNIT_EFFECTIVITY_ID = P_UNIT_EFFECTIVITY_ID
2508: ORDER BY

Line 2521: from csi_counter_associations cca, csi_counters_vl cc

2517: ORDER BY uom_code;
2518: */
2519: SELECT cc.counter_id, cc.uom_code,
2520: cc.counter_template_name counter_name
2521: from csi_counter_associations cca, csi_counters_vl cc
2522: where cca.counter_id = cc.counter_id
2523: AND source_object_code = 'CP'
2524: AND source_object_id = p_csi_instance_id;
2525:

Line 3608: --and cs_counters CN with csi_counters_vl CN to fix bug# 5918525.

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.
3612: --CTR.name = CN.counter_template_name AND -- removed for perf fix.

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 5304: csi_counters_vl CN

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
5308: CTR.NAME = CN.counter_template_name AND

Line 5433: csi_counters_vl CN

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
5437: AND CTR.NAME = CN.counter_template_name

Line 5574: --csi_counters_vl CN

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
5578: --AND CTR.NAME = CN.counter_template_name

Line 5625: --csi_counters_vl CN

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
5629: --AND CTR.NAME = CN.counter_template_name

Line 8411: CSI_COUNTERS_VL CC,

8407: * counter groups in CS_CSI_COUNTER_GROUPS.
8408: SELECT --DISTINCT
8409: CCR.NET_READING
8410: FROM
8411: CSI_COUNTERS_VL CC,
8412: --CS_COUNTER_GROUPS CCA,
8413: --priyan
8414: --changes for Bug #5207990.
8415: CS_CSI_COUNTER_GROUPS CCA,

Line 8502: CSI_COUNTERS_VL CC,

8498:
8499: SELECT --DISTINCT
8500: CCR.VALUE_TIMESTAMP
8501: FROM
8502: CSI_COUNTERS_VL CC,
8503: --CS_COUNTER_GROUPS CCA,
8504: --priyan
8505: --Refer Bug # 5207990 for changes.
8506: CS_CSI_COUNTER_GROUPS CCA,