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_LTP_RESRC_LEVL_PVT dependencies on AHL_WORKORDERS

Line 4747: from ahl_workorders wo

4743: OR
4744: p_end_date BETWEEN wip.scheduled_start_date
4745: AND wip.scheduled_completion_date)
4746: AND not exists (select wip_entity_id
4747: from ahl_workorders wo
4748: where wo.wip_entity_id = wip.wip_entity_id
4749: and wo.status_code = '17');
4750:
4751: --

Line 4891: AHL_WORKORDERS aw

4887: ) IS
4888: CURSOR get_wip_req_dtls_csr IS
4889: SELECT wor.start_date, wor.completion_date, wor.assigned_units, wor.wip_entity_id
4890: FROM wip_operation_resources wor, wip_operations wo, wip_discrete_jobs wdj,
4891: AHL_WORKORDERS aw
4892: WHERE wor.resource_id = p_resource_id
4893: AND wo.department_id = p_dept_id
4894: AND wo.wip_entity_id = wor.wip_entity_id
4895: AND wdj.WIP_ENTITY_ID = aw.WIP_ENTITY_ID