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_RELEASE_PVT dependencies on OKL_TXL_ASSETS_B

Line 1463: CURSOR c_validate_asset_number(p_asset_number OKL_TXL_ASSETS_B.ASSET_NUMBER%TYPE)

1459: FROM OKL_ASSET_RETURNS_B
1460: WHERE kle_id = p_cle_id
1461: AND ars_code = 'RE_LEASE');
1462:
1463: CURSOR c_validate_asset_number(p_asset_number OKL_TXL_ASSETS_B.ASSET_NUMBER%TYPE)
1464: IS
1465: SELECT 1
1466: FROM dual
1467: WHERE EXISTS (SELECT '1'

Line 2369: okl_txl_assets_b otl

2365: FROM okc_k_lines_v fin_ast_cle,
2366: okc_k_headers_b chr,
2367: okc_line_styles_b fin_ast_lse,
2368: okl_trx_assets ota,
2369: okl_txl_assets_b otl
2370: WHERE chr.id = p_orig_chr_id
2371: AND fin_ast_cle.chr_id = chr.id
2372: AND fin_ast_cle.dnz_chr_id = chr.id
2373: AND fin_ast_cle.sts_code = chr.sts_code

Line 2391: okl_txl_assets_b otl

2387: fin_ast_cle.name
2388: FROM okl_txl_cntrct_lns tcl,
2389: okc_k_lines_v fin_ast_cle,
2390: okl_trx_assets ota,
2391: okl_txl_assets_b otl
2392: WHERE tcl.tcn_id = p_source_trx_id
2393: AND tcl.before_transfer_yn = 'N'
2394: AND fin_ast_cle.chr_id = p_orig_chr_id
2395: AND fin_ast_cle.dnz_chr_id = p_orig_chr_id

Line 6957: FROM okl_txl_assets_b txlb,

6953: txlb.current_units,
6954: txlb.salvage_value,
6955: txlb.percent_salvage_value,
6956: txlb.id
6957: FROM okl_txl_assets_b txlb,
6958: okl_trx_assets trx,
6959: okc_k_lines_b fa_cleb,
6960: okc_line_styles_b fa_lseb
6961: WHERE txlb.kle_id = fa_cleb.id

Line 7592: FROM okl_txl_assets_b txlb,

7588:
7589: CURSOR txl_asset_csr(p_chr_id IN NUMBER,
7590: p_cle_id IN NUMBER) IS
7591: SELECT txlb.id
7592: FROM okl_txl_assets_b txlb,
7593: okl_trx_assets trx,
7594: okc_k_lines_b fa_cleb,
7595: okc_line_styles_b fa_lseb
7596: WHERE txlb.kle_id = fa_cleb.id

Line 8783: OKL_TXL_ASSETS_B txl

8779: OKC_K_ITEMS cim,
8780: OKC_K_LINES_B cle,
8781: OKC_LINE_STYLES_B lse,
8782: OKC_STATUSES_B sts,
8783: OKL_TXL_ASSETS_B txl
8784: WHERE asr.kle_id = cle_orig.cle_id
8785: AND asr.ars_code = 'RELEASE_IN_PROCESS'
8786: AND cim.object1_id1 = cim_orig.object1_id1
8787: AND cim.object1_id2 = cim_orig.object1_id2