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_CONTRACT_BOOK_PVT dependencies on OKL_TRX_TYPES_TL

Line 630: FROM okl_trx_contracts trx, okl_trx_types_tl trx_type

626: l_failstatus VARCHAR2 (256);
627:
628: CURSOR l_rebooked_csr (chrid NUMBER) IS
629: SELECT date_transaction_occurred
630: FROM okl_trx_contracts trx, okl_trx_types_tl trx_type
631: WHERE trx.khr_id_old = chrid
632: AND trx.khr_id_new IS NOT NULL
633: AND trx.tsu_code = 'ENTERED'
634: AND trx.tcn_type = 'TRBK'

Line 2311: FROM okl_trx_contracts tcn, okl_trx_types_tl try

2307: SELECT tcn.ID,
2308: tcn.source_trx_id,
2309: tcn.date_transaction_occurred,
2310: tcn.qte_id
2311: FROM okl_trx_contracts tcn, okl_trx_types_tl try
2312: WHERE tcn.khr_id_old = p_orig_chr_id
2313: AND tcn.khr_id_new = p_new_chr_id
2314: AND tcn_type = 'MAE'
2315: AND tcn.tsu_code <> 'PROCESSED'

Line 4689: l_booking_trx_type okl_trx_types_tl.NAME%TYPE DEFAULT 'Booking';

4685: ) IS
4686: l_api_name CONSTANT VARCHAR2 (30) := 'GENERATE_DRAFT_ACCT';
4687: l_api_version CONSTANT NUMBER := 1;
4688: l_return_status VARCHAR2 (1) := okl_api.g_ret_sts_success;
4689: l_booking_trx_type okl_trx_types_tl.NAME%TYPE DEFAULT 'Booking';
4690: BEGIN
4691: x_return_status := okl_api.g_ret_sts_success;
4692: x_return_status :=
4693: okl_api.start_activity (p_api_name => l_api_name,

Line 5213: okl_trx_types_tl try,

5209: --cursor to fetch quote number to check for re-leasing
5210: CURSOR get_term_qte_num (p_khr_id okc_k_headers_b.ID%TYPE) IS
5211: SELECT qte.quote_number
5212: FROM okl_trx_contracts tcn,
5213: okl_trx_types_tl try,
5214: okl_trx_quotes_b qte,
5215: okc_k_headers_b CHR
5216: WHERE tcn.khr_id_old = CHR.orig_system_id1
5217: AND tcn.khr_id_new = CHR.ID