DBA Data[Home] [Help]

APPS.AHL_OSP_QUERIES_PVT dependencies on AHL_VISIT_TASKS_B

Line 1512: ahl_visit_tasks_b vts,

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
1516: AND vts.visit_id = vst.visit_id