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_MR_HEADERS_B

Line 143: WHERE atu.mr_header_id IN (select mr1.mr_header_id from ahl_mr_headers_b mr1

139: SELECT unit_effectivity_id FROM (
140: SELECT atu.unit_effectivity_id unit_effectivity_id, atu.due_date
141: FROM ahl_temp_unit_effectivities atu
142: --WHERE atu.mr_header_id = p_preceding_mr_header_id AND
143: WHERE atu.mr_header_id IN (select mr1.mr_header_id from ahl_mr_headers_b mr1
144: where mr1.title = (select mr2.title from ahl_mr_headers_b mr2
145: where mr2.mr_header_id = p_preceding_mr_header_id)
146: ) AND
147: atu.csi_item_instance_id = p_preceding_item_instance

Line 144: where mr1.title = (select mr2.title from ahl_mr_headers_b mr2

140: SELECT atu.unit_effectivity_id unit_effectivity_id, atu.due_date
141: FROM ahl_temp_unit_effectivities atu
142: --WHERE atu.mr_header_id = p_preceding_mr_header_id AND
143: WHERE atu.mr_header_id IN (select mr1.mr_header_id from ahl_mr_headers_b mr1
144: where mr1.title = (select mr2.title from ahl_mr_headers_b mr2
145: where mr2.mr_header_id = p_preceding_mr_header_id)
146: ) AND
147: atu.csi_item_instance_id = p_preceding_item_instance
148: --forecast_sequence = p_preceding_forecast_seq;

Line 153: WHERE atu.mr_header_id IN (select mr1.mr_header_id from ahl_mr_headers_b mr1

149: UNION
150: SELECT atu.unit_effectivity_id unit_effectivity_id, atu.due_date
151: FROM ahl_temp_unit_SR_deferrals atu
152: --WHERE atu.mr_header_id = p_preceding_mr_header_id AND
153: WHERE atu.mr_header_id IN (select mr1.mr_header_id from ahl_mr_headers_b mr1
154: where mr1.title = (select mr2.title from ahl_mr_headers_b mr2
155: where mr2.mr_header_id = p_preceding_mr_header_id)
156: ) AND
157: atu.csi_item_instance_id = p_preceding_item_instance

Line 154: where mr1.title = (select mr2.title from ahl_mr_headers_b mr2

150: SELECT atu.unit_effectivity_id unit_effectivity_id, atu.due_date
151: FROM ahl_temp_unit_SR_deferrals atu
152: --WHERE atu.mr_header_id = p_preceding_mr_header_id AND
153: WHERE atu.mr_header_id IN (select mr1.mr_header_id from ahl_mr_headers_b mr1
154: where mr1.title = (select mr2.title from ahl_mr_headers_b mr2
155: where mr2.mr_header_id = p_preceding_mr_header_id)
156: ) AND
157: atu.csi_item_instance_id = p_preceding_item_instance
158: ORDER BY DUE_DATE ASC)

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 405: AND mr.title IN (select title from ahl_mr_headers_b where mr_header_id = l_term_mr_id_tbl(i))

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)
407: where rownum < 2;
408: */
409: BEGIN

Line 533: FROM ahl_temp_unit_SR_deferrals def, ahl_mr_headers_b mr1

529: BEGIN
530: SELECT due_date, unit_effectivity_id INTO l_min_due_date, l_min_ue_id
531: FROM (
532: SELECT def.due_date, def.unit_effectivity_id
533: FROM ahl_temp_unit_SR_deferrals def, ahl_mr_headers_b mr1
534: WHERE def.csi_item_instance_id = l_temp_mr_rec.csi_item_instance_id
535: AND def.mr_header_id = mr1.mr_header_id
536: AND mr1.title = (select mr2.title from ahl_mr_headers_b mr2 where mr2.mr_header_id = l_temp_mr_rec.MR_header_id)
537: AND def.due_date IS NOT NULL

Line 536: AND mr1.title = (select mr2.title from ahl_mr_headers_b mr2 where mr2.mr_header_id = l_temp_mr_rec.MR_header_id)

532: SELECT def.due_date, def.unit_effectivity_id
533: FROM ahl_temp_unit_SR_deferrals def, ahl_mr_headers_b mr1
534: WHERE def.csi_item_instance_id = l_temp_mr_rec.csi_item_instance_id
535: AND def.mr_header_id = mr1.mr_header_id
536: AND mr1.title = (select mr2.title from ahl_mr_headers_b mr2 where mr2.mr_header_id = l_temp_mr_rec.MR_header_id)
537: AND def.due_date IS NOT NULL
538: AND def.deferral_effective_on IS NOT NULL
539: AND def.orig_unit_effectivity_id IS NULL
540: ORDER BY due_date asc )

Line 560: ahl_mr_headers_b mr1, ahl_mr_headers_b mr2

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
564: AND mr1.version_number < mr2.version_number

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 881: AND mr.title IN (select title from ahl_mr_headers_b where mr_header_id = l_term_mr_id_tbl(i))

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))
882: AND date_run >= l_start_time
883: ORDER BY ue.due_date asc)
884: where rownum < 2;
885:

Line 889: AND mr_header_id IN (select mr_header_id from ahl_mr_headers_b

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))
891: )
892: AND (status_code IS NULL OR status_code = 'INIT-DUE');
893:

Line 890: where title IN (select title from ahl_mr_headers_b where mr_header_id = l_mr_id_tbl(i))

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))
891: )
892: AND (status_code IS NULL OR status_code = 'INIT-DUE');
893:
894: EXCEPTION

Line 3015: (select title from ahl_mr_headers_b mr where mr_header_id = tmp_ue.MR_header_id) mr_title

3011: tmp_ue.loop_chain_seq_num,
3012: tmp_ue.start_mr_header_id,
3013: tmp_ue.start_lc_ue_id,
3014: tmp_ue.rowid,
3015: (select title from ahl_mr_headers_b mr where mr_header_id = tmp_ue.MR_header_id) mr_title
3016: FROM ahl_temp_unit_effectivities tmp_ue, ahl_mr_headers_b mr
3017: WHERE tmp_ue.start_mr_header_id = mr.mr_header_id
3018: AND mr.title = p_mr_title
3019: AND tmp_ue.csi_item_instance_id = p_csi_ii_id

Line 3016: FROM ahl_temp_unit_effectivities tmp_ue, ahl_mr_headers_b mr

3012: tmp_ue.start_mr_header_id,
3013: tmp_ue.start_lc_ue_id,
3014: tmp_ue.rowid,
3015: (select title from ahl_mr_headers_b mr where mr_header_id = tmp_ue.MR_header_id) mr_title
3016: FROM ahl_temp_unit_effectivities tmp_ue, ahl_mr_headers_b mr
3017: WHERE tmp_ue.start_mr_header_id = mr.mr_header_id
3018: AND mr.title = p_mr_title
3019: AND tmp_ue.csi_item_instance_id = p_csi_ii_id
3020: AND tmp_ue.accomplish_trigger_type IN ('LOOP')

Line 3030: FROM ahl_applicable_mrs appl, ahl_mr_headers_b mr

3026:
3027: -- get start MRs
3028: CURSOR get_loop_start_mrs_csr IS
3029: SELECT distinct mr.title, csi_item_instance_id
3030: FROM ahl_applicable_mrs appl, ahl_mr_headers_b mr
3031: where appl.accomplish_trigger_type = 'LOOP'
3032: and appl.start_mr_header_id = appl.mr_header_id
3033: and appl.mr_header_id = mr.mr_header_id;
3034:

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 3052: FROM ahl_temp_unit_effectivities ue, ahl_mr_headers_b mr

3048: p_csi_ii_id IN NUMBER)
3049:
3050: IS
3051: SELECT ue.unit_effectivity_id
3052: FROM ahl_temp_unit_effectivities ue, ahl_mr_headers_b mr
3053: WHERE ue.start_mr_header_id = mr.mr_header_id
3054: AND mr.title = p_mr_title
3055: AND ue.csi_item_instance_id = p_csi_ii_id
3056: AND ue.accomplish_trigger_type IN ('LOOP')

Line 3134: FROM ahl_temp_unit_SR_deferrals def, ahl_mr_headers_b mr1

3130: BEGIN
3131: SELECT due_date, unit_effectivity_id INTO l_min_due_date, l_min_ue_id
3132: FROM (
3133: SELECT def.due_date, def.unit_effectivity_id
3134: FROM ahl_temp_unit_SR_deferrals def, ahl_mr_headers_b mr1
3135: WHERE def.csi_item_instance_id = l_temp_ue_records(i).csi_item_instance_id
3136: AND def.mr_header_id = mr1.mr_header_id
3137: AND mr1.title = (select mr2.title from ahl_mr_headers_b mr2 where mr2.mr_header_id = l_temp_ue_records(i).MR_header_id)
3138: AND def.due_date IS NOT NULL

Line 3137: AND mr1.title = (select mr2.title from ahl_mr_headers_b mr2 where mr2.mr_header_id = l_temp_ue_records(i).MR_header_id)

3133: SELECT def.due_date, def.unit_effectivity_id
3134: FROM ahl_temp_unit_SR_deferrals def, ahl_mr_headers_b mr1
3135: WHERE def.csi_item_instance_id = l_temp_ue_records(i).csi_item_instance_id
3136: AND def.mr_header_id = mr1.mr_header_id
3137: AND mr1.title = (select mr2.title from ahl_mr_headers_b mr2 where mr2.mr_header_id = l_temp_ue_records(i).MR_header_id)
3138: AND def.due_date IS NOT NULL
3139: AND def.deferral_effective_on IS NOT NULL
3140: AND def.orig_unit_effectivity_id IS NULL
3141: ORDER BY due_date asc )

Line 3393: (select title from ahl_mr_headers_b mr where mr_header_id = tmp_ue.MR_header_id) mr_title

3389: tmp_ue.loop_chain_seq_num,
3390: tmp_ue.start_mr_header_id,
3391: tmp_ue.start_lc_ue_id,
3392: tmp_ue.rowid,
3393: (select title from ahl_mr_headers_b mr where mr_header_id = tmp_ue.MR_header_id) mr_title
3394: FROM ahl_temp_unit_effectivities tmp_ue, ahl_mr_headers_b mr
3395: WHERE tmp_ue.start_mr_header_id = mr.mr_header_id
3396: AND mr.title = p_mr_title
3397: AND tmp_ue.csi_item_instance_id = p_csi_ii_id

Line 3394: FROM ahl_temp_unit_effectivities tmp_ue, ahl_mr_headers_b mr

3390: tmp_ue.start_mr_header_id,
3391: tmp_ue.start_lc_ue_id,
3392: tmp_ue.rowid,
3393: (select title from ahl_mr_headers_b mr where mr_header_id = tmp_ue.MR_header_id) mr_title
3394: FROM ahl_temp_unit_effectivities tmp_ue, ahl_mr_headers_b mr
3395: WHERE tmp_ue.start_mr_header_id = mr.mr_header_id
3396: AND mr.title = p_mr_title
3397: AND tmp_ue.csi_item_instance_id = p_csi_ii_id
3398: AND tmp_ue.accomplish_trigger_type IN ('CHAIN')

Line 3408: FROM ahl_applicable_mrs appl, ahl_mr_headers_b mr

3404:
3405: -- get start MRs
3406: CURSOR get_loop_start_mrs_csr IS
3407: SELECT distinct mr.title, csi_item_instance_id
3408: FROM ahl_applicable_mrs appl, ahl_mr_headers_b mr
3409: where appl.accomplish_trigger_type = 'CHAIN'
3410: and appl.start_mr_header_id = appl.mr_header_id
3411: and appl.mr_header_id = mr.mr_header_id;
3412:

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 3434: FROM ahl_temp_unit_effectivities ue, ahl_mr_headers_b mr

3430:
3431: IS
3432: /*
3433: SELECT ue.unit_effectivity_id
3434: FROM ahl_temp_unit_effectivities ue, ahl_mr_headers_b mr
3435: WHERE ue.start_mr_header_id = mr.mr_header_id
3436: AND mr.title = p_mr_title
3437: AND ue.csi_item_instance_id = p_csi_ii_id
3438: AND ue.start_lc_ue_id = p_start_lc_ue_id

Line 3454: from ahl_temp_unit_effectivities ue,ahl_mr_headers_b mr

3450:
3451: CURSOR get_start_ue_id (p_mr_title IN VARCHAR2,
3452: p_csi_ii_id IN NUMBER) IS
3453: select distinct start_lc_ue_id
3454: from ahl_temp_unit_effectivities ue,ahl_mr_headers_b mr
3455: WHERE ue.start_mr_header_id = mr.mr_header_id
3456: AND mr.title = p_mr_title
3457: AND ue.csi_item_instance_id = p_csi_ii_id
3458: AND ue.accomplish_trigger_type IN ('CHAIN');

Line 3535: FROM ahl_temp_unit_SR_deferrals def, ahl_mr_headers_b mr1

3531: BEGIN
3532: SELECT due_date, unit_effectivity_id INTO l_min_due_date, l_min_ue_id
3533: FROM (
3534: SELECT def.due_date, def.unit_effectivity_id
3535: FROM ahl_temp_unit_SR_deferrals def, ahl_mr_headers_b mr1
3536: WHERE def.csi_item_instance_id = l_temp_ue_records(i).csi_item_instance_id
3537: AND def.mr_header_id = mr1.mr_header_id
3538: AND mr1.title = (select mr2.title from ahl_mr_headers_b mr2 where mr2.mr_header_id = l_temp_ue_records(i).MR_header_id)
3539: AND def.due_date IS NOT NULL

Line 3538: AND mr1.title = (select mr2.title from ahl_mr_headers_b mr2 where mr2.mr_header_id = l_temp_ue_records(i).MR_header_id)

3534: SELECT def.due_date, def.unit_effectivity_id
3535: FROM ahl_temp_unit_SR_deferrals def, ahl_mr_headers_b mr1
3536: WHERE def.csi_item_instance_id = l_temp_ue_records(i).csi_item_instance_id
3537: AND def.mr_header_id = mr1.mr_header_id
3538: AND mr1.title = (select mr2.title from ahl_mr_headers_b mr2 where mr2.mr_header_id = l_temp_ue_records(i).MR_header_id)
3539: AND def.due_date IS NOT NULL
3540: AND def.deferral_effective_on IS NOT NULL
3541: AND def.orig_unit_effectivity_id IS NULL
3542: ORDER BY due_date asc )