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.OKL_COPY_ASSET_PVT dependencies on OKX_AST_DST_HST_V

Line 4154: CURSOR c_asset_loc_info(p_asset_id OKX_AST_DST_HST_V.ASSET_ID%TYPE) IS

4150: FROM OKX_ASSETS_V
4151: WHERE id1 = p_object1_id1
4152: AND id2 = p_object1_id2;
4153:
4154: CURSOR c_asset_loc_info(p_asset_id OKX_AST_DST_HST_V.ASSET_ID%TYPE) IS
4155: SELECT location_id
4156: FROM OKX_AST_DST_HST_V
4157: WHERE asset_id = p_asset_id
4158: AND transaction_header_id_out is null

Line 4156: FROM OKX_AST_DST_HST_V

4152: AND id2 = p_object1_id2;
4153:
4154: CURSOR c_asset_loc_info(p_asset_id OKX_AST_DST_HST_V.ASSET_ID%TYPE) IS
4155: SELECT location_id
4156: FROM OKX_AST_DST_HST_V
4157: WHERE asset_id = p_asset_id
4158: AND transaction_header_id_out is null
4159: AND sysdate between start_date_active and nvl(end_date_active,sysdate+1)
4160: AND rownum < 2;