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 2514: SELECT 'x' from ahl_workorders WO, AHL_ROUTES_B ARB

2510: AND VST.visit_id = WO.visit_id
2511: AND WO.workorder_id = p_workorder_id;
2512:
2513: CURSOR val_service_item_id_wo_csr(p_workorder_id IN NUMBER, p_service_item_id IN NUMBER) IS
2514: SELECT 'x' from ahl_workorders WO, AHL_ROUTES_B ARB
2515: WHERE WO.workorder_id = p_workorder_id
2516: AND WO.ROUTE_ID = ARB.ROUTE_ID (+)
2517: AND NVL(ARB.service_item_id, p_service_item_id) = p_service_item_id;
2518:

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

2516: AND WO.ROUTE_ID = ARB.ROUTE_ID (+)
2517: AND NVL(ARB.service_item_id, p_service_item_id) = p_service_item_id;
2518:
2519: CURSOR val_service_item_id_nll_csr(p_workorder_id IN NUMBER) IS
2520: SELECT 'x' from ahl_workorders WO, AHL_ROUTES_B ARB
2521: WHERE WO.workorder_id = p_workorder_id
2522: AND WO.ROUTE_ID = ARB.ROUTE_ID (+)
2523: AND ARB.service_item_id IS NULL;
2524:

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

2523: AND ARB.service_item_id IS NULL;
2524:
2525: CURSOR item_exists_in_wo_org_csr(p_workorder_id IN NUMBER) IS
2526: SELECT 'x'
2527: from ahl_workorders WO, AHL_ROUTES_B ARB, AHL_VISITS_B VST, ahl_mtl_items_ou_v mtl
2528: where wo.workorder_id = p_workorder_id and
2529: WO.ROUTE_ID = ARB.ROUTE_ID (+) and
2530: ARB.service_item_id = mtl.inventory_item_id and
2531: VST.visit_id = WO.visit_id and

Line 4072: ahl_routes_b arb,

4068: INTO l_organization_id, l_inventory_item_id, l_service_item_id
4069: FROM ahl_workorders wo,
4070: ahl_visits_b vst,
4071: ahl_visit_tasks_b vts,
4072: ahl_routes_b arb,
4073: inv_organization_info_v org
4074: WHERE wo.workorder_id = p_x_osp_order_lines_tbl (i).workorder_id
4075: AND wo.route_id = arb.route_id(+)
4076: AND wo.master_workorder_flag = 'N'

Line 4443: ahl_routes_b arb

4439: ahl_visits_b vst,
4440: ahl_visit_tasks_b vts,
4441: csi_item_instances csii,
4442: mtl_system_items_kfv mtls,
4443: ahl_routes_b arb
4444: WHERE wo.workorder_id = c_workorder_id
4445: AND wo.visit_task_id = vts.visit_task_id
4446: AND vst.visit_id = vts.visit_id
4447: AND wo.route_id = arb.route_id(+)

Line 5086: ahl_routes_b arb

5082: ahl_visits_b vst,
5083: ahl_visit_tasks_b vts,
5084: csi_item_instances csii,
5085: mtl_system_items_kfv mtls,
5086: ahl_routes_b arb
5087: WHERE workorder_id = c_workorder_id
5088: AND wo.visit_task_id = vts.visit_task_id
5089: AND vst.visit_id = vts.visit_id
5090: AND wo.route_id = arb.route_id(+)