DBA Data[Home] [Help]

APPS.AHL_PRD_WO_PUB dependencies on AHL_ROUTES_B

Line 133: AHL_MR_ROUTES AMR, AHL_MR_HEADERS_B AMH, AHL_ROUTES_B AR, AHL_VISIT_TASKS_B VTS,

129: VTS.service_request_id service_request_number,
130: WO.HOLD_REASON_CODE,
131: WO.HOLD_REASON
132: FROM AHL_WORKORDER_TASKS_V WO, PA_PROJECTS_ALL PAA, PA_TASKS PAT,
133: AHL_MR_ROUTES AMR, AHL_MR_HEADERS_B AMH, AHL_ROUTES_B AR, AHL_VISIT_TASKS_B VTS,
134: AHL_VISITS_B VST,AHL_WORKORDERS WOS
135: WHERE WO.VISIT_TASK_ID=VTS.VISIT_TASK_ID
136: AND WO.VISIT_ID=VST.VISIT_ID
137: AND WO.MR_ROUTE_ID=AMR.MR_ROUTE_ID (+)