APPS.AHL_OSP_QUERIES_PVT dependencies on AHL_ROUTES_B

Line 1513: ahl_routes_b arb

1509: arb.service_item_id
1510: FROM ahl_workorders wo,
1511: ahl_visits_b vst,
1512: ahl_visit_tasks_b vts,
1513: ahl_routes_b arb
1514: WHERE workorder_id = p_work_order_id
1515: AND wo.visit_task_id = vts.visit_task_id
1516: AND vts.visit_id = vst.visit_id
1517: AND wo.route_id = arb.route_id(+);

Line 1762: AHL_ROUTES_B arb

1758: from PO_VENDORS_VIEW VEN,
1759: PO_ASL_STATUSES AST,
1760: PO_APPROVED_SUPPLIER_LIST ASL,
1761: AHL_WORKORDERS WO,
1762: AHL_ROUTES_B arb
1763: WHERE WO.WORKORDER_ID = l_workorder_id
1764: AND arb.route_id = wo.route_id
1765: AND ASL.ITEM_ID = arb.SERVICE_ITEM_ID
1766: AND (ASL.USING_ORGANIZATION_ID = l_org_id