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_STREAMS_UTIL dependencies on OKL_TRX_CONTRACTS_ALL

Line 2835: okl_trx_contracts_all trx

2831: ,rbk_chr.start_date rbk_chr_start_date
2832: ,orig_chr.start_date orig_chr_start_date
2833: FROM okc_k_headers_all_b rbk_chr,
2834: okc_k_headers_all_b orig_chr,
2835: okl_trx_contracts_all trx
2836: WHERE rbk_chr.id = p_khr_id
2837: AND rbk_chr.orig_system_source_code = 'OKL_REBOOK'
2838: AND trx.khr_id_new = rbk_chr.id
2839: AND trx.tsu_code = 'ENTERED'

Line 2851: okl_trx_contracts_all trx

2847: 'MASS_REBOOK' rebook_type
2848: ,orig_chr.start_date rbk_chr_start_date
2849: ,orig_chr.start_date orig_chr_start_date
2850: FROM okc_k_headers_all_b orig_chr,
2851: okl_trx_contracts_all trx
2852: WHERE orig_chr.id = p_khr_id
2853: AND trx.khr_id = orig_chr.id
2854: AND trx.tsu_code = 'ENTERED'
2855: AND trx.tcn_type = 'TRBK'

Line 3250: FROM OKL_TRX_CONTRACTS_ALL

3246: IS
3247: SELECT 'Y'
3248: FROM DUAL
3249: WHERE EXISTS (SELECT 1
3250: FROM OKL_TRX_CONTRACTS_ALL
3251: WHERE KHR_ID = p_contract_id
3252: AND TCN_TYPE IN ('BKG','REL')
3253: AND TSU_CODE = 'PROCESSED'
3254: AND REPRESENTATION_TYPE = 'PRIMARY');