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_VWP_TIMES_PVT dependencies on WIP_DISCRETE_JOBS

Line 234: FROM WIP_DISCRETE_JOBS WIP, AHL_WORKORDERS WO

230: --PRAKKUM :: 18/04/2012 :: Bug 13095151
231: -- To find visit master WO end date
232: CURSOR c_visit_mwo_end_date (c_id IN NUMBER) IS
233: /*SELECT WIP.scheduled_completion_date
234: FROM WIP_DISCRETE_JOBS WIP, AHL_WORKORDERS WO
235: WHERE WO.VISIT_ID = c_id
236: AND WO.visit_task_id IS NULL
237: AND WO.master_workorder_flag = 'Y'
238: AND WO.wip_entity_id = WIP.wip_entity_id;*/

Line 240: FROM WIP_DISCRETE_JOBS WIP, AHL_WORKORDERS WO

236: AND WO.visit_task_id IS NULL
237: AND WO.master_workorder_flag = 'Y'
238: AND WO.wip_entity_id = WIP.wip_entity_id;*/
239: SELECT max(WIP.scheduled_completion_date) AS scheduled_completion_date
240: FROM WIP_DISCRETE_JOBS WIP, AHL_WORKORDERS WO
241: WHERE WO.VISIT_ID = c_id
242: AND WO.STATUS_CODE NOT IN ('7', '22') -- Exclude canceled and deleted work orders
243: AND WO.wip_entity_id = WIP.wip_entity_id;
244: