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_UNIT_EFFECTIVITIES_B

Line 240: FROM ahl_unit_effectivities_b

236: CURSOR get_ue_dtls_csr(c_unit_effectivity_id IN NUMBER) IS
237: SELECT MR_HEADER_ID,
238: CSI_ITEM_INSTANCE_ID,
239: OBJECT_VERSION_NUMBER
240: FROM ahl_unit_effectivities_b
241: WHERE UNIT_EFFECTIVITY_ID = c_unit_effectivity_id;
242:
243: BEGIN
244: --Initialize API return status to success

Line 468: AHL_UNIT_EFFECTIVITIES_B UEB

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'
472: CONNECT BY ue_id = PRIOR related_ue_id