eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_PRD_WO_PUB dependencies on AHL_MR_HEADERS_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 (+)

Line 1125: AHL_MR_ROUTES AMR, AHL_MR_HEADERS_B AMH

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

Line 1142: AHL_MR_ROUTES AMR, AHL_MR_HEADERS_B AMH

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