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_OSP_ORDERS_PVT dependencies on AHL_ROUTES_B

Line 2535: SELECT 'x' from ahl_workorders WO, AHL_ROUTES_B ARB

2531: AND VST.visit_id = WO.visit_id
2532: AND WO.workorder_id = p_workorder_id;
2533:
2534: CURSOR val_service_item_id_wo_csr(p_workorder_id IN NUMBER, p_service_item_id IN NUMBER) IS
2535: SELECT 'x' from ahl_workorders WO, AHL_ROUTES_B ARB
2536: WHERE WO.workorder_id = p_workorder_id
2537: AND WO.ROUTE_ID = ARB.ROUTE_ID (+)
2538: AND NVL(ARB.service_item_id, p_service_item_id) = p_service_item_id;
2539:

Line 2541: SELECT 'x' from ahl_workorders WO, AHL_ROUTES_B ARB

2537: AND WO.ROUTE_ID = ARB.ROUTE_ID (+)
2538: AND NVL(ARB.service_item_id, p_service_item_id) = p_service_item_id;
2539:
2540: CURSOR val_service_item_id_nll_csr(p_workorder_id IN NUMBER) IS
2541: SELECT 'x' from ahl_workorders WO, AHL_ROUTES_B ARB
2542: WHERE WO.workorder_id = p_workorder_id
2543: AND WO.ROUTE_ID = ARB.ROUTE_ID (+)
2544: AND ARB.service_item_id IS NULL;
2545:

Line 2548: from ahl_workorders WO, AHL_ROUTES_B ARB, AHL_VISITS_B VST, ahl_mtl_items_ou_v mtl

2544: AND ARB.service_item_id IS NULL;
2545:
2546: CURSOR item_exists_in_wo_org_csr(p_workorder_id IN NUMBER) IS
2547: SELECT 'x'
2548: from ahl_workorders WO, AHL_ROUTES_B ARB, AHL_VISITS_B VST, ahl_mtl_items_ou_v mtl
2549: where wo.workorder_id = p_workorder_id and
2550: WO.ROUTE_ID = ARB.ROUTE_ID (+) and
2551: ARB.service_item_id = mtl.inventory_item_id and
2552: VST.visit_id = WO.visit_id and

Line 4414: ahl_routes_b arb,

4410: INTO l_organization_id, l_inventory_item_id, l_service_item_id
4411: FROM ahl_workorders wo,
4412: ahl_visits_b vst,
4413: ahl_visit_tasks_b vts,
4414: ahl_routes_b arb,
4415: inv_organization_info_v org
4416: WHERE wo.workorder_id = p_x_osp_order_lines_tbl (i).workorder_id
4417: AND wo.route_id = arb.route_id(+)
4418: AND wo.master_workorder_flag = 'N'

Line 4785: ahl_routes_b arb

4781: ahl_visits_b vst,
4782: ahl_visit_tasks_b vts,
4783: csi_item_instances csii,
4784: mtl_system_items_kfv mtls,
4785: ahl_routes_b arb
4786: WHERE wo.workorder_id = c_workorder_id
4787: AND wo.visit_task_id = vts.visit_task_id
4788: AND vst.visit_id = vts.visit_id
4789: AND wo.route_id = arb.route_id(+)

Line 5436: ahl_routes_b arb

5432: ahl_visits_b vst,
5433: ahl_visit_tasks_b vts,
5434: csi_item_instances csii,
5435: mtl_system_items_kfv mtls,
5436: ahl_routes_b arb
5437: WHERE workorder_id = c_workorder_id
5438: AND wo.visit_task_id = vts.visit_task_id
5439: AND vst.visit_id = vts.visit_id
5440: AND wo.route_id = arb.route_id(+)