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.

APPS.AHL_PRD_DF_PVT dependencies on AHL_MR_EFFECTIVITIES

Line 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

408: l_manually_planned_flag VARCHAR2(1);
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

Line 414: SELECT 'x' from csi_cp_counters_v CP, AHL_MR_INTERVALS_V MRI,AHL_MR_EFFECTIVITIES MRE, AHL_UNIT_EFFECTIVITIES_B UE

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
418: AND MRI.mr_effectivity_id = MRE.mr_effectivity_id

Line 422: --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

418: AND MRI.mr_effectivity_id = MRE.mr_effectivity_id
419: AND MRE.mr_header_id = UE.mr_header_id
420: AND UE.unit_effectivity_id = p_unit_effectivity_id
421: UNION
422: --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
423: SELECT 'x' from csi_cp_counters_v CP, AHL_MR_INTERVALS_V MRI,AHL_MR_EFFECTIVITIES MRE, AHL_UNIT_EFFECTIVITIES_B UE
424: WHERE CP.customer_product_id = UE.csi_item_instance_id
425: AND CP.counter_name = MRI.counter_name
426: AND MRI.reset_value IS NOT NULL

Line 423: SELECT 'x' from csi_cp_counters_v CP, AHL_MR_INTERVALS_V MRI,AHL_MR_EFFECTIVITIES MRE, AHL_UNIT_EFFECTIVITIES_B UE

419: AND MRE.mr_header_id = UE.mr_header_id
420: AND UE.unit_effectivity_id = p_unit_effectivity_id
421: UNION
422: --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
423: SELECT 'x' from csi_cp_counters_v CP, AHL_MR_INTERVALS_V MRI,AHL_MR_EFFECTIVITIES MRE, AHL_UNIT_EFFECTIVITIES_B UE
424: WHERE CP.customer_product_id = UE.csi_item_instance_id
425: AND CP.counter_name = MRI.counter_name
426: AND MRI.reset_value IS NOT NULL
427: AND MRI.mr_effectivity_id = MRE.mr_effectivity_id

Line 442: AHL_MR_EFFECTIVITIES MRE, AHL_UNIT_EFFECTIVITIES_B UE

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
446: AND MRI.reset_value IS NOT NULL

Line 453: AHL_MR_EFFECTIVITIES MRE, AHL_UNIT_EFFECTIVITIES_B UE

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
457: AND MRI.reset_value IS NOT NULL

Line 5026: SELECT 'x' from csi_cp_counters_v CP, AHL_MR_INTERVALS_V MRI, AHL_MR_EFFECTIVITIES MRE, AHL_UNIT_EFFECTIVITIES_B UE

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
5030: AND MRI.mr_effectivity_id = MRE.mr_effectivity_id

Line 5034: SELECT 'x' from csi_cp_counters_v CP, AHL_MR_INTERVALS_V MRI, AHL_MR_EFFECTIVITIES MRE, AHL_UNIT_EFFECTIVITIES_B UE

5030: AND MRI.mr_effectivity_id = MRE.mr_effectivity_id
5031: AND MRE.mr_header_id = UE.mr_header_id
5032: AND UE.unit_effectivity_id = p_unit_effectivity_id
5033: UNION
5034: SELECT 'x' from csi_cp_counters_v CP, AHL_MR_INTERVALS_V MRI, AHL_MR_EFFECTIVITIES MRE, AHL_UNIT_EFFECTIVITIES_B UE
5035: WHERE CP.customer_product_id = UE.csi_item_instance_id
5036: AND CP.counter_name = MRI.counter_name
5037: AND MRI.reset_value IS NOT NULL
5038: AND MRI.mr_effectivity_id = MRE.mr_effectivity_id

Line 5054: AHL_MR_EFFECTIVITIES MRE, AHL_UNIT_EFFECTIVITIES_B UE

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
5058: AND MRI.reset_value IS NOT NULL

Line 5065: AHL_MR_EFFECTIVITIES MRE, AHL_UNIT_EFFECTIVITIES_B UE

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
5069: AND MRI.reset_value IS NOT NULL