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_SPLIT_ASSET_PVT dependencies on OKX_AST_DPRTNS_V

Line 11024: FROM okx_ast_dprtns_v

11020: deprn_reserve - (deprn_reserve -(deprn_reserve*p_split_factor)),
11021: prior_fy_expense - (prior_fy_expense-(prior_fy_expense*p_split_factor)),
11022: bonus_ytd_deprn - (bonus_ytd_deprn-(bonus_ytd_deprn*p_split_factor)),
11023: bonus_deprn_reserve - (bonus_deprn_reserve-(bonus_deprn_reserve*p_split_factor))
11024: FROM okx_ast_dprtns_v
11025: WHERE asset_id = p_asset_id
11026: AND book_type_code = p_book_type_code
11027: AND deprn_run_date = (SELECT MAX(deprn_run_date)
11028: FROM okx_ast_dprtns_v

Line 11028: FROM okx_ast_dprtns_v

11024: FROM okx_ast_dprtns_v
11025: WHERE asset_id = p_asset_id
11026: AND book_type_code = p_book_type_code
11027: AND deprn_run_date = (SELECT MAX(deprn_run_date)
11028: FROM okx_ast_dprtns_v
11029: WHERE asset_id = p_asset_id
11030: AND book_type_code = p_book_type_code);
11031:
11032: --cursor to get asset distribution rec

Line 12252: FROM okx_ast_dprtns_v

12248: -- -1 * (deprn_reserve -(deprn_reserve*p_split_factor)),
12249: -1 * (prior_fy_expense-(prior_fy_expense*p_split_factor)),
12250: -1 * (bonus_ytd_deprn-(bonus_ytd_deprn*p_split_factor)),
12251: -1 * (bonus_deprn_reserve-(bonus_deprn_reserve*p_split_factor))
12252: FROM okx_ast_dprtns_v
12253: WHERE asset_id = p_asset_id
12254: AND book_type_code = p_book_type_code
12255: AND deprn_run_date = (SELECT MAX(deprn_run_date)
12256: FROM okx_ast_dprtns_v

Line 12256: FROM okx_ast_dprtns_v

12252: FROM okx_ast_dprtns_v
12253: WHERE asset_id = p_asset_id
12254: AND book_type_code = p_book_type_code
12255: AND deprn_run_date = (SELECT MAX(deprn_run_date)
12256: FROM okx_ast_dprtns_v
12257: WHERE asset_id = p_asset_id
12258: AND book_type_code = p_book_type_code);
12259:
12260:

Line 12270: FROM okx_ast_dprtns_v

12266: -- -1 * deprn_reserve,
12267: -1 * prior_fy_expense,
12268: -1 * bonus_ytd_deprn,
12269: -1 * bonus_deprn_reserve
12270: FROM okx_ast_dprtns_v
12271: WHERE asset_id = p_asset_id
12272: AND book_type_code = p_book_type_code
12273: AND deprn_run_date = (SELECT MAX(deprn_run_date)
12274: FROM okx_ast_dprtns_v

Line 12274: FROM okx_ast_dprtns_v

12270: FROM okx_ast_dprtns_v
12271: WHERE asset_id = p_asset_id
12272: AND book_type_code = p_book_type_code
12273: AND deprn_run_date = (SELECT MAX(deprn_run_date)
12274: FROM okx_ast_dprtns_v
12275: WHERE asset_id = p_asset_id
12276: AND book_type_code = p_book_type_code);
12277:
12278: --Bug# 4028371 :