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

Line 715: SELECT visit_id FROM ahl_visits_b

711: SELECT instance_id FROM csi_item_instances
712: WHERE instance_number = p_instance_number;
713:
714: CURSOR ahl_visit(p_visit_number IN NUMBER) IS
715: SELECT visit_id FROM ahl_visits_b
716: WHERE visit_number = p_visit_number;
717: -- Begin Changes by VSUNDARA
718: -- TO validate the Instance Owner
719: CURSOR ahl_instance_owner(p_instance_number IN VARCHAR2) IS

Line 2623: SELECT organization_id, status_code FROM ahl_visits_b WHERE

2619:
2620: -- Kasridha: Changes for Bug#13739171 Begins
2621: -- Cursor to get the visit details
2622: CURSOR c_get_visit_dtls(p_visit_id_csr NUMBER) IS
2623: SELECT organization_id, status_code FROM ahl_visits_b WHERE
2624: visit_id = p_visit_id_csr;
2625: -- To find the repair batch task ID for a given instance
2626: CURSOR c_get_rprbatch_task (p_instance_id IN NUMBER, p_org_id NUMBER) IS
2627: SELECT visit_task_id FROM ahl_visit_tasks_b