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_UMP_PROCESSUNIT_EXTN_PVT dependencies on AHL_UNIT_EFFECTIVITIES_B

Line 356: SELECT 'x' from okc_k_lines_b OKCL, ahl_unit_effectivities_b UE

352: l_scheduled_date DATE;
353:
354: -- Cursor to check whether contract for exiting UE is valid(bug#4692366)
355: CURSOR valid_contract_csr (p_unit_effectivity_id IN NUMBER) IS
356: SELECT 'x' from okc_k_lines_b OKCL, ahl_unit_effectivities_b UE
357: --WHERE NVL(NVL(DATE_TERMINATED,END_DATE),SYSDATE) >= SYSDATE
358: -- Fix for bug# 5517930
359: WHERE NVL(NVL(DATE_TERMINATED,END_DATE),SYSDATE+1) >= trunc(SYSDATE)
360: AND OKCL.id = UE.service_line_id

Line 368: FROM okc_k_lines_b OKCL, ahl_unit_effectivities_b UE

364: -- delete UMP rows only if due date > termination date/end date.
365: CURSOR valid_due_date_csr (p_unit_effectivity_id IN NUMBER,
366: p_due_date IN DATE) IS
367: SELECT 'x'
368: FROM okc_k_lines_b OKCL, ahl_unit_effectivities_b UE
369: WHERE trunc(p_due_date) <= NVL(DATE_TERMINATED,END_DATE)
370: AND OKCL.id = UE.service_line_id
371: AND UE.unit_effectivity_id = p_unit_effectivity_id;
372:

Line 402: FROM ahl_unit_effectivities_b ue, ahl_mr_headers_b mr

398: SELECT unit_effectivity_id INTO l_terminating_mr_header_id
399: FROM (
400: SELECT ue.unit_effectivity_id
401: BULK COLLECT INTO l_ue_id_tbl
402: FROM ahl_unit_effectivities_b ue, ahl_mr_headers_b mr
403: WHERE ue.mr_header_id = mr.mr_header_id
404: AND (ue.status_code IS NULL OR ue.status_code = 'INIT-DUE')
405: AND mr.title IN (select title from ahl_mr_headers_b where mr_header_id = l_term_mr_id_tbl(i))
406: ORDER BY ue.due_date asc)

Line 559: FROM ahl_unit_effectivities_b ue, ahl_visit_tasks_b vts,

555: BEGIN
556: SELECT due_date, unit_effectivity_id INTO l_min_mr_due_date, l_min_mr_ue_id
557: FROM (
558: SELECT ue.due_date, ue.unit_effectivity_id
559: FROM ahl_unit_effectivities_b ue, ahl_visit_tasks_b vts,
560: ahl_mr_headers_b mr1, ahl_mr_headers_b mr2
561: WHERE ue.csi_item_instance_id = l_temp_mr_rec.csi_item_instance_id
562: AND ue.mr_header_id = mr1.mr_header_id
563: AND mr1.title = mr2.title

Line 591: UPDATE AHL_UNIT_EFFECTIVITIES_B

587:
588: IF (l_min_mr_flag = TRUE AND l_min_def_flag = TRUE) THEN
589: IF (l_min_mr_due_date <= l_min_due_date) THEN
590: -- update l_min_mr_ue_id
591: UPDATE AHL_UNIT_EFFECTIVITIES_B
592: SET REPETITIVE_MR_FLAG = 'N',
593: DATE_RUN = SYSDATE,
594: LAST_UPDATE_DATE = SYSDATE,
595: LAST_UPDATED_BY = fnd_global.user_id,

Line 599: UPDATE AHL_UNIT_EFFECTIVITIES_B

595: LAST_UPDATED_BY = fnd_global.user_id,
596: LAST_UPDATE_LOGIN = fnd_global.login_id
597: WHERE unit_effectivity_id = l_min_mr_ue_id;
598: -- update l_min_ue_id
599: UPDATE AHL_UNIT_EFFECTIVITIES_B
600: SET REPETITIVE_MR_FLAG = 'Y',
601: DATE_RUN = SYSDATE,
602: LAST_UPDATE_DATE = SYSDATE
603: WHERE unit_effectivity_id = l_min_ue_id;

Line 606: UPDATE AHL_UNIT_EFFECTIVITIES_B

602: LAST_UPDATE_DATE = SYSDATE
603: WHERE unit_effectivity_id = l_min_ue_id;
604: ELSE
605: -- update l_min_ue_id
606: UPDATE AHL_UNIT_EFFECTIVITIES_B
607: SET REPETITIVE_MR_FLAG = 'N',
608: DATE_RUN = SYSDATE,
609: LAST_UPDATE_DATE = SYSDATE
610: WHERE unit_effectivity_id = l_min_ue_id;

Line 613: UPDATE AHL_UNIT_EFFECTIVITIES_B

609: LAST_UPDATE_DATE = SYSDATE
610: WHERE unit_effectivity_id = l_min_ue_id;
611:
612: -- update l_min_mr_ue_id
613: UPDATE AHL_UNIT_EFFECTIVITIES_B
614: SET REPETITIVE_MR_FLAG = 'Y',
615: DATE_RUN = SYSDATE,
616: LAST_UPDATE_DATE = SYSDATE,
617: LAST_UPDATED_BY = fnd_global.user_id,

Line 623: UPDATE AHL_UNIT_EFFECTIVITIES_B

619: WHERE unit_effectivity_id = l_min_mr_ue_id;
620: END IF;
621: ELSIF (l_min_mr_flag = FALSE AND l_min_def_flag = TRUE) THEN
622: -- update l_min_ue_id
623: UPDATE AHL_UNIT_EFFECTIVITIES_B
624: SET REPETITIVE_MR_FLAG = 'N',
625: DATE_RUN = SYSDATE,
626: LAST_UPDATE_DATE = SYSDATE
627: WHERE unit_effectivity_id = l_min_ue_id;

Line 630: UPDATE AHL_UNIT_EFFECTIVITIES_B

626: LAST_UPDATE_DATE = SYSDATE
627: WHERE unit_effectivity_id = l_min_ue_id;
628: ELSIF (l_min_mr_flag = TRUE AND l_min_def_flag = FALSE) THEN
629: -- update l_min_mr_ue_id
630: UPDATE AHL_UNIT_EFFECTIVITIES_B
631: SET REPETITIVE_MR_FLAG = 'N',
632: DATE_RUN = SYSDATE,
633: LAST_UPDATE_DATE = SYSDATE,
634: LAST_UPDATED_BY = fnd_global.user_id,

Line 640: UPDATE AHL_UNIT_EFFECTIVITIES_B

636: WHERE unit_effectivity_id = l_min_mr_ue_id;
637: ELSIF (l_min_mr_flag = FALSE AND l_min_def_flag = FALSE) THEN
638: IF (l_min_ue_id IS NOT NULL) THEN
639: -- update l_min_ue_id
640: UPDATE AHL_UNIT_EFFECTIVITIES_B
641: SET REPETITIVE_MR_FLAG = 'Y',
642: DATE_RUN = SYSDATE,
643: LAST_UPDATE_DATE = SYSDATE
644: WHERE unit_effectivity_id = l_min_ue_id;

Line 648: UPDATE AHL_UNIT_EFFECTIVITIES_B

644: WHERE unit_effectivity_id = l_min_ue_id;
645: END IF;
646: IF (l_min_mr_ue_id IS NOT NULL) THEN
647: -- update l_min_mr_ue_id
648: UPDATE AHL_UNIT_EFFECTIVITIES_B
649: SET REPETITIVE_MR_FLAG = 'Y',
650: DATE_RUN = SYSDATE,
651: LAST_UPDATE_DATE = SYSDATE,
652: LAST_UPDATED_BY = fnd_global.user_id,

Line 877: FROM ahl_unit_effectivities_b ue, ahl_mr_headers_b mr

873:
874: SELECT unit_effectivity_id INTO l_terminating_ue_id
875: FROM (
876: SELECT ue.unit_effectivity_id
877: FROM ahl_unit_effectivities_b ue, ahl_mr_headers_b mr
878: WHERE ue.mr_header_id = mr.mr_header_id
879: AND ue.csi_item_instance_id = l_ii_id_tbl(i)
880: AND (ue.status_code IS NULL OR ue.status_code = 'INIT-DUE')
881: AND mr.title IN (select title from ahl_mr_headers_b where mr_header_id = l_term_mr_id_tbl(i))

Line 886: UPDATE ahl_unit_effectivities_b

882: AND date_run >= l_start_time
883: ORDER BY ue.due_date asc)
884: where rownum < 2;
885:
886: UPDATE ahl_unit_effectivities_b
887: SET terminating_ue_id = l_terminating_ue_id
888: WHERE csi_item_instance_id = l_ii_id_tbl(i)
889: AND mr_header_id IN (select mr_header_id from ahl_mr_headers_b
890: where title IN (select title from ahl_mr_headers_b where mr_header_id = l_mr_id_tbl(i))

Line 1054: UPDATE ahl_unit_effectivities_b

1050: -- fix for bug# 9078331
1051: -- set repetitive mr flag for row with min due date.
1052: -- Needed when MR new revision is not applicable.
1053: -- update all old revisions with repetitive_mr_flag = 'N' for now
1054: UPDATE ahl_unit_effectivities_b
1055: SET repetitive_mr_flag = 'N',
1056: date_run = sysdate,
1057: last_update_date = sysdate,
1058: object_version_number = object_version_number + 1,

Line 1410: UPDATE AHL_UNIT_EFFECTIVITIES_B

1406:
1407: p_x_temp_mr_rec.unit_effectivity_id := l_unit_effectivity_id;
1408:
1409: -- added for SB Enh - only for top node.
1410: UPDATE AHL_UNIT_EFFECTIVITIES_B
1411: SET accomplish_trigger_type = p_x_temp_mr_rec.accomplish_trigger_type,
1412: loop_chain_seq_num = p_x_temp_mr_rec.loop_chain_seq_num,
1413: start_lc_ue_id = p_x_temp_mr_rec.start_lc_ue_id
1414: WHERE rowid = l_rowid;

Line 1507: UPDATE ahl_unit_effectivities_b

1503: -- JKJain, NR Analysis and Forecasting
1504: X_FLEET_HEADER_ID => p_temp_mr_rec.fleet_header_id);
1505:
1506: -- added for SB Enh
1507: UPDATE ahl_unit_effectivities_b
1508: SET accomplish_trigger_type = p_temp_mr_rec.accomplish_trigger_type,
1509: loop_chain_seq_num = p_temp_mr_rec.loop_chain_seq_num,
1510: start_lc_ue_id = p_temp_mr_rec.start_lc_ue_id,
1511: terminating_ue_id = null -- fix for bug# 16567016; reset this value.

Line 1782: FROM ahl_unit_effectivities_b ue1, ahl_unit_effectivities_b ue2

1778: SELECT ue1.mr_header_id, ue1.csi_item_instance_id, ue1.unit_effectivity_id,
1779: ue2.mr_header_id parent_mr_header_id,
1780: ue2.csi_item_instance_id parent_csi_item_instance_id
1781: --FROM ahl_unit_effectivities_app_v ue1, ahl_unit_effectivities_app_v ue2
1782: FROM ahl_unit_effectivities_b ue1, ahl_unit_effectivities_b ue2
1783: WHERE ue1.unit_effectivity_id = p_ue_id AND
1784: ue2.unit_effectivity_id = p_parent_ue_id;
1785:
1786: -- Cursor to get all details of a unit effectivity record.

Line 1902: UPDATE AHL_UNIT_EFFECTIVITIES_B

1898:
1899: IF (l_visit_status IN ('RELEASED','CLOSED')) THEN
1900: l_grp_match_found := TRUE; -- ignore matching group as UE on shop floor.
1901: -- update existing UE children.
1902: UPDATE AHL_UNIT_EFFECTIVITIES_B
1903: SET mr_interval_id = p_temp_mr_rec.mr_interval_id,
1904: mr_effectivity_id = p_temp_mr_rec.mr_effectivity_id,
1905: due_date = p_temp_mr_rec.due_date,
1906: due_counter_value = p_temp_mr_rec.due_counter_value,

Line 2114: UPDATE ahl_unit_effectivities_b

2110: END IF;
2111: CLOSE unit_deferral_csr;
2112:
2113: -- update unit effectivity status on top node.
2114: UPDATE ahl_unit_effectivities_b
2115: SET status_code = 'INIT-DUE'
2116: WHERE unit_effectivity_id = l_temp_mr_rec.unit_effectivity_id;
2117:
2118: END IF;

Line 2288: FROM ahl_unit_effectivities_b UE, ahl_ue_relationships UER

2284:
2285: -- Get all mr-terminated children under the SR-UE.
2286: CURSOR ahl_term_mr_csr (p_sr_ue_id IN NUMBER) IS
2287: SELECT unit_effectivity_id
2288: FROM ahl_unit_effectivities_b UE, ahl_ue_relationships UER
2289: WHERE UE.unit_effectivity_id = UER.related_ue_id
2290: AND UER.ue_id = p_sr_ue_id
2291: AND UE.status_code = 'MR-TERMINATE';
2292:

Line 2631: UPDATE AHL_UNIT_EFFECTIVITIES_B

2627: WHERE unit_effectivity_id = unit_sr_def_rec.unit_effectivity_id;
2628:
2629: -- added for SB Enh - only for top node.
2630: IF (unit_sr_def_rec.object_type = 'MR') THEN
2631: UPDATE AHL_UNIT_EFFECTIVITIES_B
2632: SET accomplish_trigger_type = l_unit_effectivity_rec.accomplish_trigger_type,
2633: loop_chain_seq_num = l_unit_effectivity_rec.loop_chain_seq_num,
2634: start_lc_ue_id = l_unit_effectivity_rec.start_lc_ue_id
2635: WHERE unit_effectivity_id = l_new_top_ue_id;

Line 2907: UPDATE AHL_UNIT_EFFECTIVITIES_B

2903: Delete_Sch_Materials(l_ue_rec.related_ue_id);
2904: END LOOP;
2905:
2906: -- update unit effectivity record to exception.
2907: UPDATE AHL_UNIT_EFFECTIVITIES_B
2908: SET status_code = 'EXCEPTION',
2909: message_code = 'VISIT-ASSIGN',
2910: object_version_number = object_version_number + 1,
2911: DATE_RUN = sysdate,

Line 2921: UPDATE AHL_UNIT_EFFECTIVITIES_B

2917: WHERE originator_ue_id = l_delete_ue_id_tbl(i)
2918: AND relationship_code = 'PARENT');
2919:
2920: -- Update originator UE ID.
2921: UPDATE AHL_UNIT_EFFECTIVITIES_B
2922: SET status_code = 'EXCEPTION',
2923: message_code = 'VISIT-ASSIGN',
2924: object_version_number = object_version_number + 1,
2925: DATE_RUN = sysdate,

Line 3038: FROM ahl_unit_effectivities_b ue, ahl_mr_headers_b mr

3034:
3035: -- get open child UEs for start_lc_ue_id
3036: CURSOR get_start_ue_csr (p_start_lc_ue_id IN NUMBER) IS
3037: SELECT ue.unit_effectivity_Id, ue.loop_chain_seq_num, mr.title, 'N' match_flag
3038: FROM ahl_unit_effectivities_b ue, ahl_mr_headers_b mr
3039: WHERE ue.mr_header_id = mr.mr_header_id
3040: AND ue.start_lc_ue_id = p_start_lc_ue_id
3041: AND ue.accomplish_trigger_type = 'LOOP'
3042: AND (ue.status_code IS NULL OR ue.status_code = 'INIT-DUE')

Line 3061: TYPE unitEffectivityTab IS TABLE OF ahl_unit_effectivities_b%ROWTYPE;

3057: --AND (ue.status_code IS NULL OR ue.status_code = 'INIT-DUE')
3058: ORDER BY csi_item_instance_id, due_date, forecast_sequence, loop_chain_seq_num;
3059:
3060:
3061: TYPE unitEffectivityTab IS TABLE OF ahl_unit_effectivities_b%ROWTYPE;
3062: l_upd_UE_tbl_records unitEffectivityTab;
3063:
3064: l_temp_mr_rec ahl_temp_unit_effectivities%ROWTYPE;
3065:

Line 3149: UPDATE AHL_UNIT_EFFECTIVITIES_B

3145: IF (l_min_due_date <= l_temp_ue_records(i).due_date) THEN
3146: l_temp_ue_records(i).repetitive_mr_flag := 'Y';
3147:
3148: --- update deferral row (deferrals dates are processed before this procedure is called.
3149: UPDATE AHL_UNIT_EFFECTIVITIES_B
3150: SET repetitive_mr_flag = 'N',
3151: preceding_ue_id = null
3152: WHERE UNIT_EFFECTIVITY_ID = l_min_ue_id;
3153:

Line 3280: UPDATE ahl_unit_effectivities_b

3276: l_temp_ue_records(i).start_lc_ue_id := l_loop_1_start_lc_ue_id;
3277: END IF;
3278: END IF;
3279:
3280: UPDATE ahl_unit_effectivities_b
3281: SET start_lc_ue_id = l_temp_ue_records(i).start_lc_ue_id
3282: WHERE unit_effectivity_id = l_temp_mr_rec.unit_effectivity_id;
3283:
3284: END IF;

Line 3294: UPDATE AHL_UNIT_EFFECTIVITIES_B

3290: END LOOP; -- for i ..
3291:
3292: -- update
3293: FORALL i IN 1..l_upd_UE_tbl_records.count
3294: UPDATE AHL_UNIT_EFFECTIVITIES_B
3295: SET
3296: due_date = l_upd_UE_tbl_records(i).due_date,
3297: mr_interval_id = l_upd_UE_tbl_records(i).mr_interval_id,
3298: mr_effectivity_id = l_upd_UE_tbl_records(i).mr_effectivity_id,

Line 3336: UPDATE AHL_UNIT_EFFECTIVITIES_B

3332: IF (l_ue_id_tbl.count > 0) THEN
3333: l_index := l_ue_id_tbl.FIRST;
3334:
3335: IF (l_ue_id_tbl(l_index) = l_min_ue_id) THEN
3336: UPDATE AHL_UNIT_EFFECTIVITIES_B
3337: SET preceding_ue_id = null
3338: where unit_effectivity_id = l_ue_id_tbl(l_index);
3339: ELSE
3340: -- deferral exists

Line 3341: UPDATE AHL_UNIT_EFFECTIVITIES_B

3337: SET preceding_ue_id = null
3338: where unit_effectivity_id = l_ue_id_tbl(l_index);
3339: ELSE
3340: -- deferral exists
3341: UPDATE AHL_UNIT_EFFECTIVITIES_B
3342: SET preceding_ue_id = null
3343: where unit_effectivity_id = l_ue_id_tbl(l_index);
3344: END IF;
3345:

Line 3349: UPDATE AHL_UNIT_EFFECTIVITIES_B

3345:
3346: l_index := l_index + 1;
3347:
3348: FOR i IN l_index..l_ue_id_tbl.count LOOP
3349: UPDATE AHL_UNIT_EFFECTIVITIES_B
3350: SET preceding_ue_id = l_ue_id_tbl(i-1)
3351: WHERE unit_effectivity_id = l_ue_id_tbl(i);
3352: END LOOP;
3353: END IF;

Line 3417: FROM ahl_unit_effectivities_b ue, ahl_mr_headers_b mr

3413:
3414: -- get open child UEs for start_lc_ue_id
3415: CURSOR get_start_ue_csr (p_start_lc_ue_id IN NUMBER) IS
3416: SELECT ue.unit_effectivity_Id, ue.loop_chain_seq_num, mr.title, 'N' match_flag
3417: FROM ahl_unit_effectivities_b ue, ahl_mr_headers_b mr
3418: WHERE ue.mr_header_id = mr.mr_header_id
3419: AND ue.start_lc_ue_id = p_start_lc_ue_id
3420: AND ue.accomplish_trigger_type = 'CHAIN'
3421: AND (ue.status_code IS NULL OR ue.status_code = 'INIT-DUE')

Line 3445: FROM ahl_unit_effectivities_b ue

3441: ORDER BY csi_item_instance_id, due_date, forecast_sequence, loop_chain_seq_num;
3442: */
3443:
3444: SELECT ue.unit_effectivity_id
3445: FROM ahl_unit_effectivities_b ue
3446: WHERE ue.start_lc_ue_id = p_start_lc_ue_id
3447: AND ue.accomplish_trigger_type IN ('CHAIN')
3448: AND (ue.status_code IS NULL OR ue.status_code = 'INIT-DUE')
3449: ORDER BY loop_chain_seq_num;

Line 3461: TYPE unitEffectivityTab IS TABLE OF ahl_unit_effectivities_b%ROWTYPE;

3457: AND ue.csi_item_instance_id = p_csi_ii_id
3458: AND ue.accomplish_trigger_type IN ('CHAIN');
3459:
3460:
3461: TYPE unitEffectivityTab IS TABLE OF ahl_unit_effectivities_b%ROWTYPE;
3462: l_upd_UE_tbl_records unitEffectivityTab;
3463:
3464: l_temp_mr_rec ahl_temp_unit_effectivities%ROWTYPE;
3465:

Line 3550: UPDATE AHL_UNIT_EFFECTIVITIES_B

3546: IF (l_min_due_date <= l_temp_ue_records(i).due_date) THEN
3547: l_temp_ue_records(i).repetitive_mr_flag := 'Y';
3548:
3549: --- update deferral row (deferrals dates are processed before this procedure is called.
3550: UPDATE AHL_UNIT_EFFECTIVITIES_B
3551: SET repetitive_mr_flag = 'N',
3552: preceding_ue_id = null
3553: WHERE UNIT_EFFECTIVITY_ID = l_min_ue_id;
3554:

Line 3681: UPDATE ahl_unit_effectivities_b

3677: l_temp_ue_records(i).start_lc_ue_id := l_loop_1_start_lc_ue_id;
3678: END IF;
3679: END IF;
3680:
3681: UPDATE ahl_unit_effectivities_b
3682: SET start_lc_ue_id = l_temp_ue_records(i).start_lc_ue_id
3683: WHERE unit_effectivity_id = l_temp_mr_rec.unit_effectivity_id;
3684:
3685: END IF;

Line 3695: UPDATE AHL_UNIT_EFFECTIVITIES_B

3691: END LOOP; -- for i ..
3692:
3693: -- update
3694: FORALL i IN 1..l_upd_UE_tbl_records.count
3695: UPDATE AHL_UNIT_EFFECTIVITIES_B
3696: SET
3697: due_date = l_upd_UE_tbl_records(i).due_date,
3698: mr_interval_id = l_upd_UE_tbl_records(i).mr_interval_id,
3699: mr_effectivity_id = l_upd_UE_tbl_records(i).mr_effectivity_id,

Line 3744: UPDATE AHL_UNIT_EFFECTIVITIES_B

3740: IF (l_ue_id_tbl.count > 0) THEN
3741: l_index := l_ue_id_tbl.FIRST;
3742:
3743: -- for chain, first UE to be updated with preceding_ue_id as null
3744: UPDATE AHL_UNIT_EFFECTIVITIES_B
3745: SET preceding_ue_id = null
3746: where unit_effectivity_id = l_ue_id_tbl(l_index);
3747: /*
3748: ELSE

Line 3750: UPDATE AHL_UNIT_EFFECTIVITIES_B

3746: where unit_effectivity_id = l_ue_id_tbl(l_index);
3747: /*
3748: ELSE
3749: -- deferral exists
3750: UPDATE AHL_UNIT_EFFECTIVITIES_B
3751: SET preceding_ue_id = null
3752: where unit_effectivity_id = l_ue_id_tbl(l_index);
3753: END IF;
3754: */

Line 3758: UPDATE AHL_UNIT_EFFECTIVITIES_B

3754: */
3755: l_index := l_index + 1;
3756:
3757: FOR i IN l_index..l_ue_id_tbl.count LOOP
3758: UPDATE AHL_UNIT_EFFECTIVITIES_B
3759: SET preceding_ue_id = l_ue_id_tbl(i-1)
3760: WHERE unit_effectivity_id = l_ue_id_tbl(i);
3761: END LOOP;
3762: END IF;

Line 3842: from ahl_unit_effectivities_b

3838: cs_incident_id,
3839: manually_planned_flag,
3840: defer_from_ue_id,
3841: counter_id
3842: from ahl_unit_effectivities_b
3843: WHERE csi_item_instance_id = c_csi_item_instance_id and
3844: defer_from_ue_id is null and
3845: (status_code is null or status_code = 'INIT-DUE') and
3846: cs_incident_id IS NOT NULL and

Line 3853: FROM ahl_unit_effectivities_b

3849: */
3850: -- get individual Unplanned UEs and NRs for item instance and top group records from temporary table.
3851: CURSOR temp_nr_unplanned_ue_csr(c_csi_item_instance_id NUMBER) IS
3852: SELECT unit_effectivity_id
3853: FROM ahl_unit_effectivities_b
3854: WHERE csi_item_instance_id = c_csi_item_instance_id and
3855: defer_from_ue_id is null and
3856: ((status_code is null and manually_planned_flag = 'Y') OR status_code = 'INIT-DUE') and
3857: NOT EXISTS ( SELECT 'X'

Line 3870: from ahl_temp_unit_sr_deferrals temp, ahl_unit_effectivities_b ue

3866: temp.due_date,
3867: temp.tolerance_flag,
3868: temp.message_code,
3869: temp.counter_id
3870: from ahl_temp_unit_sr_deferrals temp, ahl_unit_effectivities_b ue
3871: WHERE ue.unit_effectivity_id = temp.unit_effectivity_id and
3872: temp.csi_item_instance_id = c_csi_item_instance_id and
3873: temp.orig_unit_effectivity_id IS NULL and
3874: temp.deferral_effective_on IS NOT NULL

Line 4413: from ahl_unit_effectivities_b

4409: fleet_header_id,
4410: cs_incident_id,
4411: manually_planned_flag,
4412: defer_from_ue_id
4413: from ahl_unit_effectivities_b
4414: where unit_effectivity_id = c_unit_effectivity_id;
4415:
4416: l_temp_ue_rec get_ue_details_csr%ROWTYPE;
4417: l_temp_sim_ue_rec ahl_ue_simulations%ROWTYPE;