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 5900: AHL_UNIT_EFFECTIVITIES_APP_V UE

5896: FROM WIP_DISCRETE_JOBS WIP,
5897: AHL_WORKORDERS WO,
5898: AHL_WORKORDERS VWO,
5899: AHL_VISIT_TASKS_B VT,
5900: AHL_UNIT_EFFECTIVITIES_APP_V UE
5901: WHERE WIP.wip_entity_id = WO.wip_entity_id
5902: AND WO.visit_task_id = VT.visit_task_id
5903: AND VWO.visit_task_id IS NULL
5904: AND VWO.visit_id = VT.visit_id

Line 10964: DEF,AHL_UNIT_EFFECTIVITIES_APP_V UE

10960: THEN DEF.APPROVAL_STATUS_CODE
10961: ELSE UE.STATUS_CODE
10962: END)UMP_STATUS_CODE
10963: FROM AHL_UNIT_DEFERRALS_B ORIG_DEF,AHL_UNIT_DEFERRALS_B
10964: DEF,AHL_UNIT_EFFECTIVITIES_APP_V UE
10965: WHERE UE.orig_deferral_ue_id = orig_def.unit_effectivity_id(+)
10966: AND orig_def.unit_deferral_type(+) = 'DEFERRAL'
10967: AND UE.unit_effectivity_id = def.unit_effectivity_id(+)
10968: AND def.unit_deferral_type(+) = 'DEFERRAL'

Line 10987: DEF,AHL_UNIT_EFFECTIVITIES_APP_V UE

10983: THEN DEF.APPROVAL_STATUS_CODE
10984: ELSE UE.STATUS_CODE
10985: END)UMP_STATUS_CODE
10986: FROM AHL_UNIT_DEFERRALS_B ORIG_DEF,AHL_UNIT_DEFERRALS_B
10987: DEF,AHL_UNIT_EFFECTIVITIES_APP_V UE
10988: WHERE UE.orig_deferral_ue_id = orig_def.unit_effectivity_id(+)
10989: AND orig_def.unit_deferral_type(+) = 'DEFERRAL'
10990: AND UE.unit_effectivity_id = def.unit_effectivity_id(+)
10991: AND def.unit_deferral_type(+) = 'DEFERRAL'

Line 12095: AHL_UNIT_EFFECTIVITIES_APP_V UE,

12091: --To Get the Wip_Entity_id
12092: CURSOR get_wip_entity_id( c_unit_effectivity_id NUMBER ) IS
12093: SELECT WO.wip_entity_id,WO.workorder_id
12094: FROM AHL_VISIT_TASKS_B VT,
12095: AHL_UNIT_EFFECTIVITIES_APP_V UE,
12096: AHL_WORKORDERS WO
12097: WHERE WO.visit_task_id = VT.visit_task_id
12098: AND VT.unit_effectivity_id = UE.unit_effectivity_id
12099: AND WO.visit_id = VT.visit_id

Line 12108: AHL_UNIT_EFFECTIVITIES_APP_V UE,

12104: CURSOR get_ue_det( c_workorder_id NUMBER ) IS
12105: SELECT UE.unit_effectivity_id,
12106: UE.OBJECT_VERSION_NUMBER
12107: FROM AHL_VISIT_TASKS_B VT,
12108: AHL_UNIT_EFFECTIVITIES_APP_V UE,
12109: AHL_WORKORDERS WO
12110: WHERE WO.visit_task_id = VT.visit_task_id
12111: AND VT.unit_effectivity_id = UE.unit_effectivity_id
12112: AND WO.visit_id = VT.visit_id