DBA Data[Home] [Help]

APPS.AHL_OSP_QUERIES_PVT dependencies on AHL_VISITS_B

Line 1511: ahl_visits_b vst,

1507: SELECT vts.inventory_item_id,
1508: vst.organization_id,
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