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_EAM_JOB_PVT dependencies on AHL_UE_RELATIONSHIPS

Line 147: FROM AHL_UE_RELATIONSHIPS UER

143: AHL_UNIT_EFFECTIVITIES_B UE
144: WHERE
145: UE.unit_effectivity_id = p_ue_id
146: AND NOT EXISTS (SELECT 'x'
147: FROM AHL_UE_RELATIONSHIPS UER
148: WHERE UER.related_ue_id = UE.unit_effectivity_id
149: );
150:
151: -- get originator UE details for a child UE.

Line 160: FROM AHL_UE_RELATIONSHIPS UER

156: FROM
157: AHL_UNIT_EFFECTIVITIES_B UE
158: WHERE
159: UE.unit_effectivity_id IN (SELECT originator_ue_id
160: FROM AHL_UE_RELATIONSHIPS UER
161: WHERE UER.related_ue_id = p_ue_id
162: );
163:
164: -- Define local variables here