APPS.AHL_PRD_WO_PUB dependencies on AHL_MR_HEADERS_B

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

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
121: AND WO.MR_ROUTE_ID=AMR.MR_ROUTE_ID (+)

Line 1104: AHL_MR_ROUTES AMR, AHL_MR_HEADERS_B AMH

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
1108: AND WOP.workorder_operation_id = p_WoOperationId;

Line 1121: AHL_MR_ROUTES AMR, AHL_MR_HEADERS_B AMH

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;
1125: