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.

[Home] [Help]

APPS.OKL_BOOK_CONTROLLER_PVT dependencies on OKL_TRX_CONTRACTS

Line 4010: okl_trx_contracts trx

4006:
4007: CURSOR l_chr_csr(p_khr_id IN NUMBER) IS
4008: SELECT chrb.orig_system_id1 orig_chr_id
4009: FROM okc_k_headers_b chrb,
4010: okl_trx_contracts trx
4011: WHERE chrb.id = p_khr_id
4012: AND chrb.orig_system_source_code = 'OKL_REBOOK'
4013: AND trx.khr_id_new = p_khr_id
4014: AND trx.tcn_type = 'TRBK'

Line 4122: okl_trx_contracts trx

4118: SELECT chrb_orig.id orig_chr_id,
4119: chrb_orig.contract_number
4120: FROM okc_k_headers_b chrb_rbk,
4121: okc_k_headers_b chrb_orig,
4122: okl_trx_contracts trx
4123: WHERE chrb_rbk.id = p_khr_id
4124: AND chrb_rbk.orig_system_source_code = 'OKL_REBOOK'
4125: AND chrb_orig.id = chrb_rbk.orig_system_id1
4126: AND trx.khr_id = chrb_orig.id