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_PVT dependencies on AHL_VISITS_B

Line 10165: l_visit_status ahl_visits_b.status_code%TYPE;

10161: l_unit_deferral_type VARCHAR2(30);
10162: l_repair_time NUMBER;
10163: l_expected_resolutn_date DATE;
10164:
10165: l_visit_status ahl_visits_b.status_code%TYPE;
10166:
10167: -- Added for SB Enh.
10168: l_junk VARCHAR2(1);
10169: CURSOR check_applicable_mr(p_mr_title IN VARCHAR2, p_item_instance_id IN NUMBER) IS

Line 10649: l_visit_status ahl_visits_b.status_code%TYPE;

10645:
10646: l_grp_match VARCHAR2(1);
10647: l_grp_match1 VARCHAR2(1);
10648:
10649: l_visit_status ahl_visits_b.status_code%TYPE;
10650:
10651: -- added for Complx Assy Enh
10652: l_due_date DATE;
10653: l_due_counter_value NUMBER;

Line 15310: from ahl_visits_b vst, ahl_visit_tasks_b tsk

15306:
15307: -- get visit end date
15308: CURSOR get_vst_date(p_ue_id IN NUMBER) IS
15309: SELECT vst.close_date_time
15310: from ahl_visits_b vst, ahl_visit_tasks_b tsk
15311: where tsk.unit_effectivity_id = p_ue_id
15312: and tsk.visit_id = vst.visit_id
15313: and tsk.task_type_code = 'SUMMARY';
15314: