APPS.AHL_PRD_WO_PUB dependencies on AHL_WORKORDER_TASKS_V

Line 116: FROM AHL_WORKORDER_TASKS_V WO, PA_PROJECTS_ALL PAA, PA_TASKS PAT,

112: VST.start_date_time,
113: VST.close_date_time,
114: VTS.service_request_id,
115: VTS.service_request_id service_request_number
116: FROM AHL_WORKORDER_TASKS_V WO, PA_PROJECTS_ALL PAA, PA_TASKS PAT,
117: AHL_MR_ROUTES AMR, AHL_MR_HEADERS_B AMH, AHL_ROUTES_B AR, AHL_VISIT_TASKS_B VTS,
118: AHL_VISITS_B VST,AHL_WORKORDERS WOS
119: WHERE WO.VISIT_TASK_ID=VTS.VISIT_TASK_ID
120: AND WO.VISIT_ID=VST.VISIT_ID

Line 1103: FROM AHL_WORKORDER_TASKS_V WO, AHL_WORKORDER_OPERATIONS WOP,

1099: WO.WO_PART_NUMBER,
1100: WO.ITEM_INSTANCE_NUMBER,
1101: WO.LOT_NUMBER,
1102: WO.SERIAL_NUMBER
1103: FROM AHL_WORKORDER_TASKS_V WO, AHL_WORKORDER_OPERATIONS WOP,
1104: AHL_MR_ROUTES AMR, AHL_MR_HEADERS_B AMH
1105: WHERE WO.MR_ROUTE_ID=AMR.MR_ROUTE_ID (+)
1106: AND AMR.MR_HEADER_ID=AMH.MR_HEADER_ID(+)
1107: AND WO.WORKORDER_ID = WOP.WORKORDER_ID

Line 1120: FROM AHL_WORKORDER_TASKS_V WO,

1116: WO.WO_PART_NUMBER,
1117: WO.ITEM_INSTANCE_NUMBER,
1118: WO.LOT_NUMBER,
1119: WO.SERIAL_NUMBER
1120: FROM AHL_WORKORDER_TASKS_V WO,
1121: AHL_MR_ROUTES AMR, AHL_MR_HEADERS_B AMH
1122: WHERE WO.MR_ROUTE_ID=AMR.MR_ROUTE_ID (+)
1123: AND AMR.MR_HEADER_ID=AMH.MR_HEADER_ID(+)
1124: AND WO.WORKORDER_ID = p_WorkorderId;