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_PRD_DF_PVT dependencies on CSI_COUNTERS_VL

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

409:
410: -- to check whether MR or any of its children has resettable counters
411: CURSOR reset_counter_csr(p_unit_effectivity_id IN NUMBER) IS
412: --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
413: /* In R12, modified to use csi_counters_vl instead of csi_cp_counters_v.
414: SELECT 'x' from csi_cp_counters_v CP, AHL_MR_INTERVALS_V MRI,AHL_MR_EFFECTIVITIES MRE, AHL_UNIT_EFFECTIVITIES_B UE
415: WHERE CP.customer_product_id = UE.csi_item_instance_id
416: AND CP.counter_name = MRI.counter_name
417: AND MRI.reset_value IS NOT NULL

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

437:
438: );
439: */
440: SELECT 'x'
441: from csi_counter_associations ca, csi_counters_vl CP, AHL_MR_INTERVALS_V MRI,
442: AHL_MR_EFFECTIVITIES MRE, AHL_UNIT_EFFECTIVITIES_B UE
443: WHERE CA.source_object_id = UE.csi_item_instance_id
444: AND ca.source_object_code = 'CP'
445: AND CP.counter_template_name = MRI.counter_name

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

448: AND MRE.mr_header_id = UE.mr_header_id
449: AND UE.unit_effectivity_id = p_unit_effectivity_id
450: UNION
451: SELECT 'x'
452: from csi_counter_associations ca, csi_counters_vl CP, AHL_MR_INTERVALS_V MRI,
453: AHL_MR_EFFECTIVITIES MRE, AHL_UNIT_EFFECTIVITIES_B UE
454: WHERE CA.source_object_id = UE.csi_item_instance_id
455: AND ca.source_object_code = 'CP'
456: AND CP.counter_template_name = MRI.counter_name

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

5021: AND VST.unit_effectivity_id = p_unit_effectivity_id;
5022:
5023: -- to check whether MR or any of its children has resettable counters
5024: CURSOR reset_counter_csr(p_unit_effectivity_id IN NUMBER) IS
5025: /* In R12, modified to use csi_counters_vl instead of csi_cp_counters_v.
5026: SELECT 'x' from csi_cp_counters_v CP, AHL_MR_INTERVALS_V MRI, AHL_MR_EFFECTIVITIES MRE, AHL_UNIT_EFFECTIVITIES_B UE
5027: WHERE CP.customer_product_id = UE.csi_item_instance_id
5028: AND CP.counter_name = MRI.counter_name
5029: AND MRI.reset_value IS NOT NULL

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

5049: );
5050: */
5051:
5052: SELECT 'x'
5053: from csi_counter_associations ca, csi_counters_vl CP, AHL_MR_INTERVALS_V MRI,
5054: AHL_MR_EFFECTIVITIES MRE, AHL_UNIT_EFFECTIVITIES_B UE
5055: WHERE CA.source_object_id = UE.csi_item_instance_id
5056: AND ca.source_object_code = 'CP'
5057: AND CP.counter_template_name = MRI.counter_name

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

5060: AND MRE.mr_header_id = UE.mr_header_id
5061: AND UE.unit_effectivity_id = p_unit_effectivity_id
5062: UNION
5063: SELECT 'x'
5064: from csi_counter_associations ca, csi_counters_vl CP, AHL_MR_INTERVALS_V MRI,
5065: AHL_MR_EFFECTIVITIES MRE, AHL_UNIT_EFFECTIVITIES_B UE
5066: WHERE CA.source_object_id = UE.csi_item_instance_id
5067: AND ca.source_object_code = 'CP'
5068: AND CP.counter_template_name = MRI.counter_name