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

Line 510: okl_trx_contracts ktrx

506: CURSOR l_chk_mass_rbk_csr
507: IS
508: SELECT '1'
509: FROM okc_k_headers_b chrb,
510: okl_trx_contracts ktrx
511: WHERE chrb.ID = p_chr_id
512: AND ktrx.khr_id = chrb.id
513: AND ktrx.tsu_code = 'ENTERED'
514: AND ktrx.rbr_code IS NOT NULL

Line 552: okl_trx_contracts ktrx

548: CURSOR l_chk_rbk_csr
549: IS
550: SELECT '1'
551: FROM okc_k_headers_b chrb,
552: okl_trx_contracts ktrx
553: WHERE ktrx.khr_id_new = chrb.id
554: AND ktrx.tsu_code = 'ENTERED'
555: AND ktrx.rbr_code IS NOT NULL
556: AND ktrx.tcn_type = 'TRBK'

Line 1580: okl_trx_contracts ktrx

1576: CURSOR l_last_activation_date_csr(p_chr_id IN NUMBER)
1577: IS
1578: SELECT MAX(ktrx.transaction_date)
1579: FROM okc_k_headers_b chrb,
1580: okl_trx_contracts ktrx
1581: WHERE chrb.id = p_chr_id
1582: AND ktrx.khr_id = chrb.id
1583: AND ktrx.tsu_code = 'PROCESSED'
1584: AND ktrx.tcn_type IN ('TRBK','SPA','BKG','REL')

Line 1794: okl_trx_contracts_all trx

1790: SELECT 'Y' online_rebook_in_progress,
1791: orig_chr.id
1792: FROM okc_k_headers_all_b rbk_chr,
1793: okc_k_headers_all_b orig_chr,
1794: okl_trx_contracts_all trx
1795: WHERE rbk_chr.id = p_khr_id
1796: AND rbk_chr.orig_system_source_code = 'OKL_REBOOK'
1797: AND trx.khr_id_new = rbk_chr.id
1798: AND trx.tsu_code = 'ENTERED'