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_WARRANTY_ENTL_PVT dependencies on AHL_WORKORDERS

Line 750: FROM AHL_VISIT_TASKS_B VTK, AHL_WORKORDERS WO,

746: AND ENT.warranty_entitlement_id = c_entl_id;
747:
748: CURSOR get_osp_line_inst_csr (c_entl_id NUMBER) IS
749: SELECT VTK.instance_id
750: FROM AHL_VISIT_TASKS_B VTK, AHL_WORKORDERS WO,
751: AHL_OSP_ORDER_LINES OSP, AHL_WARRANTY_ENTITLEMENTS ENT
752: WHERE VTK.visit_task_id = WO.visit_task_id
753: AND WO.workorder_id = OSP.workorder_id
754: AND OSP.workorder_id IS NOT NULL

Line 1766: FROM AHL_WORKORDERS

1762: AND status_code NOT IN ('CANCELLED', 'DELETED');
1763:
1764: CURSOR chk_workorder_id_csr (c_wo_id NUMBER) IS
1765: SELECT 'X'
1766: FROM AHL_WORKORDERS
1767: WHERE workorder_id = c_wo_id;
1768:
1769: CURSOR chk_osp_line_id_csr (c_line_id NUMBER) IS
1770: SELECT 'X'