DBA Data[Home] [Help]

APPS.AHL_PRD_DISP_UTIL_PVT dependencies on AHL_VISIT_TASKS_B

Line 2424: FROM AHL_WORKORDERS WO, AHL_VISITS_B VST, AHL_VISIT_TASKS_B VTS

2420: IS
2421:
2422: CURSOR get_instance_id_csr IS
2423: SELECT VTS.INSTANCE_ID, VST.ITEM_INSTANCE_ID
2424: FROM AHL_WORKORDERS WO, AHL_VISITS_B VST, AHL_VISIT_TASKS_B VTS
2425: WHERE WO.WORKORDER_ID = p_workorder_id AND
2426: VST.VISIT_ID = WO.VISIT_ID AND
2427: VTS.VISIT_TASK_ID = WO.VISIT_TASK_ID;
2428: