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_DEFERRALS_B

Line 10160: FROM AHL_UNIT_DEFERRALS_B ORIG_DEF,AHL_UNIT_DEFERRALS_B

10156: WHEN DEF.APPROVAL_STATUS_CODE IS NOT NULL
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(+)