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_STREAM_GENERATOR_PVT dependencies on OKL_TRX_CONTRACTS

Line 6338: okl_trx_contracts ktrx,

6334: --Cursor to check whether it is a partial termination mass rebook transaction
6335: CURSOR l_chk_mass_rbk_csr IS
6336: SELECT '!'
6337: FROM okc_k_headers_b CHR,
6338: okl_trx_contracts ktrx,
6339: okl_trx_contracts trx
6340: WHERE CHR.ID = p_chr_id
6341: AND ktrx.KHR_ID = chr.id
6342: AND ktrx.tsu_code = 'ENTERED'

Line 6339: okl_trx_contracts trx

6335: CURSOR l_chk_mass_rbk_csr IS
6336: SELECT '!'
6337: FROM okc_k_headers_b CHR,
6338: okl_trx_contracts ktrx,
6339: okl_trx_contracts trx
6340: WHERE CHR.ID = p_chr_id
6341: AND ktrx.KHR_ID = chr.id
6342: AND ktrx.tsu_code = 'ENTERED'
6343: AND ktrx.rbr_code IS NOT NULL

Line 6425: okl_trx_contracts ktrx,

6421: CURSOR chk_curr_terminated_line(p_kle_id IN OKC_K_LINES_B.ID%TYPE)
6422: IS
6423: SELECT 'Y'
6424: FROM okc_k_headers_b CHR,
6425: okl_trx_contracts ktrx,
6426: okl_trx_contracts trx,
6427: okl_txl_quote_lines_b txl
6428: WHERE CHR.ID = p_chr_id
6429: AND ktrx.KHR_ID = chr.id

Line 6426: okl_trx_contracts trx,

6422: IS
6423: SELECT 'Y'
6424: FROM okc_k_headers_b CHR,
6425: okl_trx_contracts ktrx,
6426: okl_trx_contracts trx,
6427: okl_txl_quote_lines_b txl
6428: WHERE CHR.ID = p_chr_id
6429: AND ktrx.KHR_ID = chr.id
6430: AND ktrx.tsu_code = 'ENTERED'

Line 6450: okl_trx_contracts ktrx,

6446: UNION
6447:
6448: SELECT 'Y'
6449: FROM okc_k_headers_b CHR,
6450: okl_trx_contracts ktrx,
6451: okl_trx_contracts trx,
6452: okl_txl_quote_lines_b txl
6453: , OKC_K_ITEMS LNK_ITM
6454: WHERE CHR.ID = p_chr_id

Line 6451: okl_trx_contracts trx,

6447:
6448: SELECT 'Y'
6449: FROM okc_k_headers_b CHR,
6450: okl_trx_contracts ktrx,
6451: okl_trx_contracts trx,
6452: okl_txl_quote_lines_b txl
6453: , OKC_K_ITEMS LNK_ITM
6454: WHERE CHR.ID = p_chr_id
6455: AND ktrx.KHR_ID = chr.id

Line 8420: okl_trx_contracts_all trx

8416: ,rbk_chr.start_date rbk_chr_start_date
8417: ,orig_chr.start_date orig_chr_start_date
8418: FROM okc_k_headers_all_b rbk_chr,
8419: okc_k_headers_all_b orig_chr,
8420: okl_trx_contracts_all trx
8421: WHERE rbk_chr.id = p_khr_id
8422: AND rbk_chr.orig_system_source_code = 'OKL_REBOOK'
8423: AND trx.khr_id_new = rbk_chr.id
8424: AND trx.tsu_code = 'ENTERED'

Line 8436: okl_trx_contracts_all trx

8432: 'MASS_REBOOK' rebook_type
8433: ,orig_chr.start_date rbk_chr_start_date
8434: ,orig_chr.start_date orig_chr_start_date
8435: FROM okc_k_headers_all_b orig_chr,
8436: okl_trx_contracts_all trx
8437: WHERE orig_chr.id = p_khr_id
8438: AND trx.khr_id = orig_chr.id
8439: AND trx.tsu_code = 'ENTERED'
8440: AND trx.tcn_type = 'TRBK'