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_INTERVALS_V

Line 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

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

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

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

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

425: AND MRI.mr_effectivity_id = MRE.mr_effectivity_id
426: AND MRE.mr_header_id = UE.mr_header_id
427: AND UE.unit_effectivity_id = p_unit_effectivity_id
428: UNION
429: --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
430: SELECT 'x' from csi_cp_counters_v CP, AHL_MR_INTERVALS_V MRI,AHL_MR_EFFECTIVITIES MRE, AHL_UNIT_EFFECTIVITIES_B UE
431: WHERE CP.customer_product_id = UE.csi_item_instance_id
432: AND CP.counter_name = MRI.counter_name
433: AND MRI.reset_value IS NOT NULL

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

426: AND MRE.mr_header_id = UE.mr_header_id
427: AND UE.unit_effectivity_id = p_unit_effectivity_id
428: UNION
429: --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
430: SELECT 'x' from csi_cp_counters_v CP, AHL_MR_INTERVALS_V MRI,AHL_MR_EFFECTIVITIES MRE, AHL_UNIT_EFFECTIVITIES_B UE
431: WHERE CP.customer_product_id = UE.csi_item_instance_id
432: AND CP.counter_name = MRI.counter_name
433: AND MRI.reset_value IS NOT NULL
434: AND MRI.mr_effectivity_id = MRE.mr_effectivity_id

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 2215: SELECT 'x' from ahl_unit_effectivities_b UE, ahl_unit_deferrals_b UD,AHL_MR_INTERVALS_V MR,CSI_CP_COUNTERS_V CO

2211: AND UE.unit_effectivity_id = UD.unit_effectivity_id
2212: AND UD.unit_deferral_id = p_unit_deferral_id;
2213:
2214: /*CURSOR mr_valid_counter_csr(p_unit_deferral_id IN NUMBER,p_counter_id IN NUMBER) IS
2215: SELECT 'x' from ahl_unit_effectivities_b UE, ahl_unit_deferrals_b UD,AHL_MR_INTERVALS_V MR,CSI_CP_COUNTERS_V CO
2216: WHERE UD.unit_deferral_id = p_unit_deferral_id
2217: AND UE.unit_effectivity_id = UD.unit_effectivity_id
2218: AND co.customer_product_id = ue.csi_item_instance_id
2219: AND UE.mr_effectivity_id = MR.mr_effectivity_id

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

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

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

5413: AND MRI.mr_effectivity_id = MRE.mr_effectivity_id
5414: AND MRE.mr_header_id = UE.mr_header_id
5415: AND UE.unit_effectivity_id = p_unit_effectivity_id
5416: UNION
5417: SELECT 'x' from csi_cp_counters_v CP, AHL_MR_INTERVALS_V MRI, AHL_MR_EFFECTIVITIES MRE, AHL_UNIT_EFFECTIVITIES_B UE
5418: WHERE CP.customer_product_id = UE.csi_item_instance_id
5419: AND CP.counter_name = MRI.counter_name
5420: AND MRI.reset_value IS NOT NULL
5421: AND MRI.mr_effectivity_id = MRE.mr_effectivity_id

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