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

Line 229: FROM AHL_UE_RELATIONSHIPS

225: l_child_ue_ids_tbl NUM_TBL_TYPE;
226:
227: CURSOR get_descendant_UEs_csr IS
228: SELECT related_ue_id
229: FROM AHL_UE_RELATIONSHIPS
230: START WITH ue_id = p_unit_effectivity_id
231: AND relationship_code = 'PARENT'
232: CONNECT BY ue_id = PRIOR related_ue_id
233: AND relationship_code = 'PARENT'

Line 467: FROM AHL_UE_RELATIONSHIPS UER,

463: AND OEL.line_id = OSPL.OE_RETURN_LINE_ID;
464:
465: CURSOR get_descendant_UEs_csr (c_ue_id IN NUMBER) IS
466: SELECT UER.related_ue_id, UEB.CSI_ITEM_INSTANCE_ID, UEB.MR_HEADER_ID, UEB.ACCOMPLISHED_DATE
467: FROM AHL_UE_RELATIONSHIPS UER,
468: AHL_UNIT_EFFECTIVITIES_B UEB
469: WHERE UER.related_ue_id = UEB.UNIT_EFFECTIVITY_ID
470: START WITH ue_id = c_ue_id
471: AND relationship_code = 'PARENT'