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_COMPLETIONS_PVT dependencies on AHL_UNIT_EFFECTIVITIES_APP_V

Line 5618: AHL_UNIT_EFFECTIVITIES_APP_V UE

5614: FROM WIP_DISCRETE_JOBS WIP,
5615: AHL_WORKORDERS WO,
5616: AHL_WORKORDERS VWO,
5617: AHL_VISIT_TASKS_B VT,
5618: AHL_UNIT_EFFECTIVITIES_APP_V UE
5619: WHERE WIP.wip_entity_id = WO.wip_entity_id
5620: AND WO.visit_task_id = VT.visit_task_id
5621: AND VWO.visit_task_id IS NULL
5622: AND VWO.visit_id = VT.visit_id

Line 10161: DEF,AHL_UNIT_EFFECTIVITIES_APP_V UE

10157: THEN DEF.APPROVAL_STATUS_CODE
10158: ELSE UE.STATUS_CODE
10159: END)UMP_STATUS_CODE
10160: FROM AHL_UNIT_DEFERRALS_B ORIG_DEF,AHL_UNIT_DEFERRALS_B
10161: DEF,AHL_UNIT_EFFECTIVITIES_APP_V UE
10162: WHERE UE.orig_deferral_ue_id = orig_def.unit_effectivity_id(+)
10163: AND orig_def.unit_deferral_type(+) = 'DEFERRAL'
10164: AND UE.unit_effectivity_id = def.unit_effectivity_id(+)
10165: AND def.unit_deferral_type(+) = 'DEFERRAL'