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

Line 1636: FROM okl_trx_contracts ktrx

1632: --Bug# 4899328: Start
1633: --cursor to check if the contract is undergoing on-line rebook
1634: cursor l_chk_rbk_csr(p_chr_id IN NUMBER) is
1635: SELECT '!'
1636: FROM okl_trx_contracts ktrx
1637: WHERE ktrx.khr_id_old = p_chr_id
1638: AND ktrx.tsu_code = 'ENTERED'
1639: AND ktrx.rbr_code is NOT NULL
1640: AND ktrx.tcn_type = 'TRBK'

Line 3220: l_trans_number okl_trx_contracts.trx_number%TYPE := p_trans_number;

3216: --Bug# 6373605 end
3217: from okl_trx_assets
3218: where id = p_tas_id;
3219:
3220: l_trans_number okl_trx_contracts.trx_number%TYPE := p_trans_number;
3221: l_trans_date okl_trx_assets.date_trans_occurred%TYPE;
3222: l_calling_interface varchar2(30) := p_calling_interface;
3223: --Bug# 3156924
3224: --Bug# 6373605 start

Line 5036: OKL_TRX_CONTRACTS ktrx,

5032: ktrx.trx_number
5033: FROM OKC_RULES_B rul,
5034: OKL_K_HEADERS khr,
5035: OKC_K_HEADERS_B chr,
5036: OKL_TRX_CONTRACTS ktrx,
5037: OKC_K_HEADERS_B rbk_chr
5038: WHERE rul.dnz_chr_id = chr.id
5039: AND rul.rule_information_category = 'LATOWN'
5040: AND khr.id = chr.id

Line 5056: l_rbr_code OKL_TRX_CONTRACTS.rbr_code%TYPE;

5052: --
5053: AND rbk_chr.orig_system_source_code = 'OKL_REBOOK'
5054: AND rbk_chr.id = p_rbk_chr_id;
5055:
5056: l_rbr_code OKL_TRX_CONTRACTS.rbr_code%TYPE;
5057: l_deal_type OKL_K_HEADERS.deal_type%TYPE;
5058: l_chr_id OKC_K_HEADERS_B.ID%TYPE;
5059: l_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;
5060: l_date_trx_occured OKL_TRX_CONTRACTS.date_transaction_occurred%TYPE;

Line 5060: l_date_trx_occured OKL_TRX_CONTRACTS.date_transaction_occurred%TYPE;

5056: l_rbr_code OKL_TRX_CONTRACTS.rbr_code%TYPE;
5057: l_deal_type OKL_K_HEADERS.deal_type%TYPE;
5058: l_chr_id OKC_K_HEADERS_B.ID%TYPE;
5059: l_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;
5060: l_date_trx_occured OKL_TRX_CONTRACTS.date_transaction_occurred%TYPE;
5061: l_tax_owner OKC_RULES_B.RULE_INFORMATION1%TYPE;
5062: --Bug# : 11.5.9 enhancement Multi GAAP
5063: l_pdt_id OKL_K_HEADERS.pdt_id%TYPE;
5064: l_start_date Date;

Line 5071: l_trx_number okl_trx_contracts.trx_number%TYPE;

5067: l_rep_deal_type Varchar2(150);
5068: l_Multi_GAAP_YN Varchar2(1) := 'N';
5069: l_rep_pdt_book OKX_AST_BKS_V.Book_Type_Code%Type;
5070: --Bug# 3156924 :
5071: l_trx_number okl_trx_contracts.trx_number%TYPE;
5072: l_calling_interface varchar2(30) := 'OKL: Rebook';
5073:
5074: --cursor to get the adjusted residual value and OEC
5075: CURSOR adj_cle_csr (p_chr_id IN NUMBER, p_fa_cle_id IN NUMBER, p_effective_date IN date) IS

Line 6331: OKL_TRX_CONTRACTS ktrx

6327: ktrx.trx_number
6328: FROM OKC_RULES_B rul,
6329: OKL_K_HEADERS khr,
6330: OKC_K_HEADERS_B chr,
6331: OKL_TRX_CONTRACTS ktrx
6332: WHERE rul.dnz_chr_id = chr.id
6333: AND rul.rule_information_category = 'LATOWN'
6334: AND khr.id = chr.id
6335: AND chr.id = p_rbk_chr_id

Line 6349: l_rbr_code OKL_TRX_CONTRACTS.rbr_code%TYPE;

6345: --
6346: AND ktrx.KHR_ID_NEW is null
6347: AND ktrx.tsu_code = G_TSU_CODE_ENTERED;
6348:
6349: l_rbr_code OKL_TRX_CONTRACTS.rbr_code%TYPE;
6350: l_deal_type OKL_K_HEADERS.deal_type%TYPE;
6351: l_chr_id OKC_K_HEADERS_B.ID%TYPE;
6352: l_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;
6353: l_date_trx_occured OKL_TRX_CONTRACTS.date_transaction_occurred%TYPE;

Line 6353: l_date_trx_occured OKL_TRX_CONTRACTS.date_transaction_occurred%TYPE;

6349: l_rbr_code OKL_TRX_CONTRACTS.rbr_code%TYPE;
6350: l_deal_type OKL_K_HEADERS.deal_type%TYPE;
6351: l_chr_id OKC_K_HEADERS_B.ID%TYPE;
6352: l_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;
6353: l_date_trx_occured OKL_TRX_CONTRACTS.date_transaction_occurred%TYPE;
6354: l_tax_owner OKC_RULES_B.RULE_INFORMATION1%TYPE;
6355: --Bug# 3156924
6356: l_trans_number OKL_TRX_CONTRACTS.trx_number%TYPE;
6357: l_calling_interface Varchar2(30) := 'OKLRACAB:Mass Rebook';

Line 6356: l_trans_number OKL_TRX_CONTRACTS.trx_number%TYPE;

6352: l_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;
6353: l_date_trx_occured OKL_TRX_CONTRACTS.date_transaction_occurred%TYPE;
6354: l_tax_owner OKC_RULES_B.RULE_INFORMATION1%TYPE;
6355: --Bug# 3156924
6356: l_trans_number OKL_TRX_CONTRACTS.trx_number%TYPE;
6357: l_calling_interface Varchar2(30) := 'OKLRACAB:Mass Rebook';
6358:
6359: --cursor to get the adjusted residual value and OEC
6360: CURSOR adj_cle_csr (p_chr_id IN NUMBER, p_fa_cle_id IN NUMBER, p_effective_date IN date) IS

Line 9342: okl_trx_contracts ktrx

9338: --cursor to check if the contract is selected for Mass Rebook
9339: CURSOR l_chk_mass_rbk_csr (p_chr_id IN NUMBER) IS
9340: SELECT 'Y'
9341: FROM okc_k_headers_b CHR,
9342: okl_trx_contracts ktrx
9343: where CHR.ID = p_chr_id
9344: AND ktrx.KHR_ID = chr.id
9345: AND ktrx.tsu_code = 'ENTERED'
9346: AND ktrx.rbr_code IS NOT NULL

Line 11105: okl_trx_contracts ktrx

11101: --cursor to check if the contract is undergoing on-line rebook
11102: cursor l_chk_rbk_csr(p_chr_id IN NUMBER) is
11103: SELECT '!'
11104: FROM okc_k_headers_b CHR,
11105: okl_trx_contracts ktrx
11106: WHERE ktrx.khr_id_new = chr.id
11107: AND ktrx.tsu_code = 'ENTERED'
11108: AND ktrx.rbr_code is NOT NULL
11109: AND ktrx.tcn_type = 'TRBK'