APPS.AHL_PRD_WO_PUB dependencies on AHL_WORKORDER_TASKS_V

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

128: VTS.service_request_id,
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

Line 1124: FROM AHL_WORKORDER_TASKS_V WO, AHL_WORKORDER_OPERATIONS WOP,

1120: WO.WO_PART_NUMBER,
1121: WO.ITEM_INSTANCE_NUMBER,
1122: WO.LOT_NUMBER,
1123: WO.SERIAL_NUMBER
1124: FROM AHL_WORKORDER_TASKS_V WO, AHL_WORKORDER_OPERATIONS WOP,
1125: AHL_MR_ROUTES AMR, AHL_MR_HEADERS_B AMH
1126: WHERE WO.MR_ROUTE_ID=AMR.MR_ROUTE_ID (+)
1127: AND AMR.MR_HEADER_ID=AMH.MR_HEADER_ID(+)
1128: AND WO.WORKORDER_ID = WOP.WORKORDER_ID

Line 1141: FROM AHL_WORKORDER_TASKS_V WO,

1137: WO.WO_PART_NUMBER,
1138: WO.ITEM_INSTANCE_NUMBER,
1139: WO.LOT_NUMBER,
1140: WO.SERIAL_NUMBER
1141: FROM AHL_WORKORDER_TASKS_V WO,
1142: AHL_MR_ROUTES AMR, AHL_MR_HEADERS_B AMH
1143: WHERE WO.MR_ROUTE_ID=AMR.MR_ROUTE_ID (+)
1144: AND AMR.MR_HEADER_ID=AMH.MR_HEADER_ID(+)
1145: AND WO.WORKORDER_ID = p_WorkorderId;