[Home] [Help]
444:
445: );
446: */
447: SELECT 'x'
448: from csi_counter_associations ca, csi_counters_vl CP, AHL_MR_INTERVALS_V MRI,
449: AHL_MR_EFFECTIVITIES MRE, AHL_UNIT_EFFECTIVITIES_B UE
450: WHERE CA.source_object_id = UE.csi_item_instance_id
451: AND ca.source_object_code = 'CP'
452: AND CP.counter_template_name = MRI.counter_name
455: AND MRE.mr_header_id = UE.mr_header_id
456: AND UE.unit_effectivity_id = p_unit_effectivity_id
457: UNION
458: SELECT 'x'
459: from csi_counter_associations ca, csi_counters_vl CP, AHL_MR_INTERVALS_V MRI,
460: AHL_MR_EFFECTIVITIES MRE, AHL_UNIT_EFFECTIVITIES_B UE
461: WHERE CA.source_object_id = UE.csi_item_instance_id
462: AND ca.source_object_code = 'CP'
463: AND CP.counter_template_name = MRI.counter_name
5432: );
5433: */
5434:
5435: SELECT 'x'
5436: from csi_counter_associations ca, csi_counters_vl CP, AHL_MR_INTERVALS_V MRI,
5437: AHL_MR_EFFECTIVITIES MRE, AHL_UNIT_EFFECTIVITIES_B UE
5438: WHERE CA.source_object_id = UE.csi_item_instance_id
5439: AND ca.source_object_code = 'CP'
5440: AND CP.counter_template_name = MRI.counter_name
5443: AND MRE.mr_header_id = UE.mr_header_id
5444: AND UE.unit_effectivity_id = p_unit_effectivity_id
5445: UNION
5446: SELECT 'x'
5447: from csi_counter_associations ca, csi_counters_vl CP, AHL_MR_INTERVALS_V MRI,
5448: AHL_MR_EFFECTIVITIES MRE, AHL_UNIT_EFFECTIVITIES_B UE
5449: WHERE CA.source_object_id = UE.csi_item_instance_id
5450: AND ca.source_object_code = 'CP'
5451: AND CP.counter_template_name = MRI.counter_name
6170: FROM csi_counter_readings ccr
6171: WHERE ccr.counter_value_id = cc.CTR_VAL_MAX_SEQ_NO
6172: AND NVL(ccr.disabled_flag,'N') = 'N'
6173: ) net_reading
6174: FROM CSI_COUNTER_ASSOCIATIONS CCA,
6175: CSI_COUNTERS_VL CC
6176: WHERE CCA.COUNTER_ID = CC.COUNTER_ID
6177: AND CCA.SOURCE_OBJECT_ID = p_csi_item_instance_id
6178: AND CCA.SOURCE_OBJECT_CODE = 'CP'