[Home] [Help]
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
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
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
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
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
453: AND MRI.reset_value IS NOT NULL
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
464: AND MRI.reset_value IS NOT NULL
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
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
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
5441: AND MRI.reset_value IS NOT NULL
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
5452: AND MRI.reset_value IS NOT NULL
6233: -- JKJain, NR Analysis and Forecasting
6234: FUNCTION get_fleet_from_effectivity(p_unit_effectivity_id IN NUMBER) RETURN NUMBER IS
6235:
6236: Cursor get_fleet_header_id(c_unit_effectivity_id NUMBER) IS
6237: SELECT eff.fleet_header_id from ahl_mr_effectivities eff, ahl_unit_effectivities_b ue
6238: WHERE eff.mr_effectivity_id = ue.mr_effectivity_id
6239: AND ue.unit_effectivity_id = c_unit_effectivity_id;
6240:
6241: l_fleet_header_id NUMBER := null;