APPS.AHL_PRD_DF_PVT dependencies on CSI_COUNTERS_VL

Line 420: /* In R12, modified to use csi_counters_vl instead of csi_cp_counters_v.

416:
417: -- to check whether MR or any of its children has resettable counters
418: CURSOR reset_counter_csr(p_unit_effectivity_id IN NUMBER) IS
419: --SELECT 'x' from csi_cp_counters_v CP, AHL_MR_INTERVALS_V MRI,AHL_MR_EFFECTIVITIES_APP_V MRE, AHL_UNIT_EFFECTIVITIES_APP_V UE
420: /* In R12, modified to use csi_counters_vl instead of csi_cp_counters_v.
421: SELECT 'x' from csi_cp_counters_v CP, AHL_MR_INTERVALS_V MRI,AHL_MR_EFFECTIVITIES MRE, AHL_UNIT_EFFECTIVITIES_B UE
422: WHERE CP.customer_product_id = UE.csi_item_instance_id
423: AND CP.counter_name = MRI.counter_name
424: AND MRI.reset_value IS NOT NULL

Line 448: from csi_counter_associations ca, csi_counters_vl CP, AHL_MR_INTERVALS_V MRI,

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

Line 459: from csi_counter_associations ca, csi_counters_vl CP, AHL_MR_INTERVALS_V MRI,

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

Line 5408: /* In R12, modified to use csi_counters_vl instead of csi_cp_counters_v.

5404: AND VST.unit_effectivity_id = p_unit_effectivity_id;
5405:
5406: -- to check whether MR or any of its children has resettable counters
5407: CURSOR reset_counter_csr(p_unit_effectivity_id IN NUMBER) IS
5408: /* In R12, modified to use csi_counters_vl instead of csi_cp_counters_v.
5409: SELECT 'x' from csi_cp_counters_v CP, AHL_MR_INTERVALS_V MRI, AHL_MR_EFFECTIVITIES MRE, AHL_UNIT_EFFECTIVITIES_B UE
5410: WHERE CP.customer_product_id = UE.csi_item_instance_id
5411: AND CP.counter_name = MRI.counter_name
5412: AND MRI.reset_value IS NOT NULL

Line 5436: from csi_counter_associations ca, csi_counters_vl CP, AHL_MR_INTERVALS_V MRI,

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

Line 5447: from csi_counter_associations ca, csi_counters_vl CP, AHL_MR_INTERVALS_V MRI,

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

Line 6175: CSI_COUNTERS_VL CC

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'
6179: AND CC.COUNTER_TEMPLATE_NAME = p_ctr_template_name;

Line 6189: FROM csi_counters_vl cc

6185: FROM csi_counter_readings ccr
6186: WHERE ccr.counter_value_id = cc.CTR_VAL_MAX_SEQ_NO
6187: AND NVL(ccr.disabled_flag,'N') = 'N'
6188: )
6189: FROM csi_counters_vl cc
6190: WHERE cc.counter_id = p_counter_id;
6191:
6192: l_counter_name VARCHAR2(240);
6193: l_uom_code VARCHAR2(3);