[Home] [Help]
2956: ORDER BY uom_code;
2957:
2958: SELECT cc.counter_id, cc.uom_code,
2959: cc.counter_template_name counter_name
2960: from csi_counter_associations cca, csi_counters_vl cc
2961: where cca.counter_id = cc.counter_id
2962: AND source_object_code = 'CP'
2963: AND source_object_id = p_csi_instance_id;
2964: */
2971: where ccr.counter_id = cc.counter_id
2972: and value_timestamp = (select max(value_timestamp) from csi_counter_readings rd
2973: where counter_id = cc.counter_id
2974: and nvl(disabled_flag,'N') = 'N')) net_reading
2975: FROM csi_counter_associations cca, csi_counters_vl cc
2976: WHERE cca.counter_id = cc.counter_id
2977: AND source_object_code = 'CP'
2978: AND source_object_id = p_csi_item_instance_id;
2979: */
2984: (select ccr.net_reading
2985: from csi_counter_readings ccr
2986: where ccr.counter_value_id = cc.CTR_VAL_MAX_SEQ_NO
2987: and nvl(ccr.disabled_flag,'N') = 'N')
2988: FROM csi_counter_associations cca, csi_counters_vl cc
2989: WHERE cca.counter_id = cc.counter_id
2990: AND source_object_code = 'CP'
2991: AND source_object_id = p_csi_instance_id;
2992:
3122:
3123: --Priyan
3124: --Query being changed due to performance related fixes
3125: --Refer Bug # 4918744
3126: --Changed the usage of CS_COUNTERS_V to CSI_COUNTERS_VL
3127:
3128: SELECT
3129: UA.COUNTER_ID,
3130: UA.COUNTER_VALUE,
3132: --CS.NAME COUNTER_NAME
3133: CS.COUNTER_TEMPLATE_NAME COUNTER_NAME
3134: FROM
3135: AHL_UNIT_ACCOMPLISHMNTS UA,
3136: CSI_COUNTERS_VL CS
3137: WHERE
3138: UA.COUNTER_ID = CS.COUNTER_ID AND
3139: UA.UNIT_EFFECTIVITY_ID = P_UNIT_EFFECTIVITY_ID
3140: ORDER BY
3149: ORDER BY uom_code;
3150: */
3151: SELECT cc.counter_id, cc.uom_code,
3152: cc.counter_template_name counter_name
3153: from csi_counter_associations cca, csi_counters_vl cc
3154: where cca.counter_id = cc.counter_id
3155: AND source_object_code = 'CP'
3156: AND source_object_id = p_csi_instance_id;
3157:
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.
4629: --CTR.name = CN.counter_template_name AND -- removed for perf fix.
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
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
6574: CTR.NAME = CN.counter_template_name AND
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
6703: AND CTR.NAME = CN.counter_template_name
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
6845: --AND CTR.NAME = CN.counter_template_name
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
6897: --AND CTR.NAME = CN.counter_template_name
9893: * counter groups in CS_CSI_COUNTER_GROUPS.
9894: SELECT --DISTINCT
9895: CCR.NET_READING
9896: FROM
9897: CSI_COUNTERS_VL CC,
9898: --CS_COUNTER_GROUPS CCA,
9899: --priyan
9900: --changes for Bug #5207990.
9901: CS_CSI_COUNTER_GROUPS CCA,
9984:
9985: SELECT --DISTINCT
9986: CCR.VALUE_TIMESTAMP
9987: FROM
9988: CSI_COUNTERS_VL CC,
9989: --CS_COUNTER_GROUPS CCA,
9990: --priyan
9991: --Refer Bug # 5207990 for changes.
9992: CS_CSI_COUNTER_GROUPS CCA,
15961: CS.UOM_CODE,
15962: CS.COUNTER_TEMPLATE_NAME COUNTER_NAME
15963: FROM
15964: AHL_UNIT_ACCOMPLISHMNTS UA,
15965: CSI_COUNTERS_VL CS
15966: WHERE
15967: UA.COUNTER_ID = CS.COUNTER_ID AND
15968: UA.UNIT_EFFECTIVITY_ID = P_UNIT_EFFECTIVITY_ID
15969: ORDER BY
15972: -- Get instance counter details.
15973: CURSOR csi_cp_counters_csr (p_csi_instance_id IN NUMBER) IS
15974: SELECT cc.counter_id, cc.uom_code,
15975: cc.counter_template_name counter_name
15976: from csi_counter_associations cca, csi_counters_vl cc
15977: where cca.counter_id = cc.counter_id
15978: AND source_object_code = 'CP'
15979: AND source_object_id = p_csi_instance_id;
15980: