DBA Data[Home] [Help]

APPS.AHL_PRD_WORKORDER_PVT dependencies on AHL_VISIT_INST_ROUTINGS

Line 3832: AHL_WORKORDERS WO, AHL_VISIT_TASKS_B TSK, AHL_VISIT_INST_ROUTINGS RTNG

3828: --Cursor to get instance routing attached to workorder instance.
3829: CURSOR Get_Wo_Inst_Rtng(p_workorder_id IN NUMBER) IS
3830: SELECT RTNG.INST_ROUTING_CODE INSTANCE_RTNG
3831: FROM
3832: AHL_WORKORDERS WO, AHL_VISIT_TASKS_B TSK, AHL_VISIT_INST_ROUTINGS RTNG
3833: WHERE
3834: WO.WORKORDER_ID = p_workorder_id
3835: AND WO.VISIT_TASK_ID = TSK.VISIT_TASK_ID
3836: AND TSK.INSTANCE_ID IS NOT NULL