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_UMP_PROCESSUNIT_EXTN_PVT dependencies on AHL_UNIT_EFFECTIVITIES_VL

Line 223: FROM ahl_unit_effectivities_vl

219: LAST_UPDATED_BY ,
220: LAST_UPDATE_LOGIN
221:
222: --FROM ahl_unit_effectivities_app_v
223: FROM ahl_unit_effectivities_vl
224: WHERE unit_effectivity_id = p_unit_effectivity_id;
225: --FOR UPDATE OF preceding_ue_id, status_code NOWAIT; -- not required as these rows were locked before.
226:
227: -- Cursor for reading unit effectivity records(top nodes) that have not been updated.

Line 1834: FROM ahl_unit_effectivities_vl

1830: ATTRIBUTE14 ,
1831: ATTRIBUTE15 ,
1832: OBJECT_VERSION_NUMBER
1833: --FROM ahl_unit_effectivities_app_v
1834: FROM ahl_unit_effectivities_vl
1835: WHERE unit_effectivity_id = p_unit_effectivity_id;
1836: --FOR UPDATE OF due_date NOWAIT;
1837:
1838: TYPE temp_grp_rec_type IS RECORD (

Line 2281: FROM ahl_unit_effectivities_vl

2277: start_lc_ue_id,
2278: loop_chain_seq_num,
2279: -- JKJain, NR Analysis and Forecasting
2280: fleet_header_id
2281: FROM ahl_unit_effectivities_vl
2282: WHERE unit_effectivity_id = p_unit_effectivity_id;
2283: --FOR UPDATE OF due_date NOWAIT; -- not required as we locked the UEs before
2284:
2285: -- Get all mr-terminated children under the SR-UE.