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 OKC_K_HEADERS_B

Line 4629: From OKC_K_HEADERS_B chr,

4625: khr.DEAL_TYPE,
4626: --11.5.9(Multi GAAP)
4627: khr.PDT_ID,
4628: chr.START_DATE
4629: From OKC_K_HEADERS_B chr,
4630: OKL_K_HEADERS khr
4631: WHERE khr.id = chr.id
4632: AND chr.ID = P_CHRV_ID;
4633:

Line 5035: OKC_K_HEADERS_B chr,

5031: --Bug# 3156924
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'

Line 5037: OKC_K_HEADERS_B rbk_chr

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
5041: AND chr.id = rbk_chr.orig_system_id1

Line 5058: l_chr_id OKC_K_HEADERS_B.ID%TYPE;

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;
5061: l_tax_owner OKC_RULES_B.RULE_INFORMATION1%TYPE;
5062: --Bug# : 11.5.9 enhancement Multi GAAP

Line 5059: l_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;

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;
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;

Line 5304: okc_k_headers_b chr

5300: From okc_k_lines_v clev,
5301: okc_line_styles_b lse,
5302: okc_k_lines_b fa_cle,
5303: okc_line_styles_b fa_lse,
5304: okc_k_headers_b chr
5305: where clev.chr_id = chr.orig_system_id1
5306: and clev.dnz_chr_id = chr.orig_system_id1
5307: and chr.id = p_rbk_chr_id
5308: and chr.orig_system_source_code = 'OKL_REBOOK'

Line 5325: l_orig_chr_id OKC_K_HEADERS_B.ID%TYPE;

5321: and fa_lse.lty_code = G_FA_LINE_LTY_CODE;
5322:
5323: l_new_fin_cle_id OKC_K_LINES_B.ID%TYPE;
5324: l_new_fa_cle_id OKC_K_LINES_B.ID%TYPE;
5325: l_orig_chr_id OKC_K_HEADERS_B.ID%TYPE;
5326: lx_cimv_rec cimv_rec_type;
5327: lx_cimv_ib_tbl cimv_tbl_type;
5328:
5329: l_dummy_amount NUMBER;

Line 6330: OKC_K_HEADERS_B chr,

6326: --Bug# 3156924
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

Line 6351: l_chr_id OKC_K_HEADERS_B.ID%TYPE;

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;
6354: l_tax_owner OKC_RULES_B.RULE_INFORMATION1%TYPE;
6355: --Bug# 3156924

Line 6352: l_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;

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;
6354: l_tax_owner OKC_RULES_B.RULE_INFORMATION1%TYPE;
6355: --Bug# 3156924
6356: l_trans_number OKL_TRX_CONTRACTS.trx_number%TYPE;

Line 7403: OKC_K_HEADERS_B chr

7399: --Bug# 4631549
7400: chr.orig_system_source_code
7401: FROM OKC_RULES_B rul,
7402: OKL_K_HEADERS khr,
7403: OKC_K_HEADERS_B chr
7404: WHERE rul.dnz_chr_id = chr.id
7405: AND rul.rule_information_category = 'LATOWN'
7406: AND rul.dnz_chr_id = khr.id
7407: AND khr.id = chr.id

Line 7419: l_rel_chr_id OKC_K_HEADERS_B.ID%TYPE;

7415: AND nvl(rule_information1,'N') = 'Y');
7416: --Bug#2522439
7417:
7418: l_deal_type OKL_K_HEADERS.deal_type%TYPE;
7419: l_rel_chr_id OKC_K_HEADERS_B.ID%TYPE;
7420: l_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;
7421: l_tax_owner OKC_RULES_B.RULE_INFORMATION1%TYPE;
7422: l_orig_chr_id OKC_K_HEADERS_B.ID%TYPE;
7423: --Bug# : 11.5.9 enhancement Multi GAAP

Line 7420: l_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;

7416: --Bug#2522439
7417:
7418: l_deal_type OKL_K_HEADERS.deal_type%TYPE;
7419: l_rel_chr_id OKC_K_HEADERS_B.ID%TYPE;
7420: l_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;
7421: l_tax_owner OKC_RULES_B.RULE_INFORMATION1%TYPE;
7422: l_orig_chr_id OKC_K_HEADERS_B.ID%TYPE;
7423: --Bug# : 11.5.9 enhancement Multi GAAP
7424: l_pdt_id OKL_K_HEADERS.pdt_id%TYPE;

Line 7422: l_orig_chr_id OKC_K_HEADERS_B.ID%TYPE;

7418: l_deal_type OKL_K_HEADERS.deal_type%TYPE;
7419: l_rel_chr_id OKC_K_HEADERS_B.ID%TYPE;
7420: l_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;
7421: l_tax_owner OKC_RULES_B.RULE_INFORMATION1%TYPE;
7422: l_orig_chr_id OKC_K_HEADERS_B.ID%TYPE;
7423: --Bug# : 11.5.9 enhancement Multi GAAP
7424: l_pdt_id OKL_K_HEADERS.pdt_id%TYPE;
7425: l_start_date Date;
7426: l_rep_pdt_id Number;

Line 7431: l_orig_system_source_code okc_k_headers_b.orig_system_source_code%TYPE;

7427: l_rep_deal_type Varchar2(150);
7428: l_Multi_GAAP_YN Varchar2(1) := 'N';
7429: l_rep_pdt_book OKX_AST_BKS_V.Book_Type_Code%Type;
7430: --Bug# 4631549
7431: l_orig_system_source_code okc_k_headers_b.orig_system_source_code%TYPE;
7432:
7433: ---------------- ---------------------------------------------------------------*/
7434:
7435: --cursor to get the modified transaction values against the release contract

Line 9341: FROM okc_k_headers_b CHR,

9337:
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'

Line 9398: okc_k_headers_b chrb

9394: rul.rule_information1
9395: from okc_rules_b rul,
9396: okc_rule_groups_b rgp,
9397: okl_k_headers khr,
9398: okc_k_headers_b chrb
9399: where rul.rule_information_category = 'LATOWN'
9400: and rul.rgp_id = rgp.id
9401: and rul.dnz_chr_id = rgp.dnz_chr_id
9402: and rgp.dnz_chr_id = chrb.id

Line 9601: from okc_k_headers_b

9597: -- cursor to get ORIG_SYSTEM_SOURCE_CODE of the contract
9598:
9599: cursor l_orig_sys_src_code_csr (p_chr_id in number) is
9600: select id, ORIG_SYSTEM_SOURCE_CODE
9601: from okc_k_headers_b
9602: where id = p_chr_id;
9603:
9604: l_chr_id okc_k_headers_b.id%type;
9605: l_orig_system_source_code okc_k_headers_b.orig_system_source_code%type;

Line 9604: l_chr_id okc_k_headers_b.id%type;

9600: select id, ORIG_SYSTEM_SOURCE_CODE
9601: from okc_k_headers_b
9602: where id = p_chr_id;
9603:
9604: l_chr_id okc_k_headers_b.id%type;
9605: l_orig_system_source_code okc_k_headers_b.orig_system_source_code%type;
9606: l_cle_id okl_k_lines_v.id%type;
9607: l_exp_asset_cost okl_k_lines_v.expected_asset_cost%type;
9608:

Line 9605: l_orig_system_source_code okc_k_headers_b.orig_system_source_code%type;

9601: from okc_k_headers_b
9602: where id = p_chr_id;
9603:
9604: l_chr_id okc_k_headers_b.id%type;
9605: l_orig_system_source_code okc_k_headers_b.orig_system_source_code%type;
9606: l_cle_id okl_k_lines_v.id%type;
9607: l_exp_asset_cost okl_k_lines_v.expected_asset_cost%type;
9608:
9609: --cursor to get Cap fees added during Re-lease for the asset

Line 11104: FROM okc_k_headers_b CHR,

11100:
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

Line 11153: okc_k_headers_b chrb

11149: rul.rule_information1
11150: from okc_rules_b rul,
11151: okc_rule_groups_b rgp,
11152: okl_k_headers khr,
11153: okc_k_headers_b chrb
11154: where rul.rule_information_category = 'LATOWN'
11155: and rul.rgp_id = rgp.id
11156: and rul.dnz_chr_id = rgp.dnz_chr_id
11157: and rgp.dnz_chr_id = chrb.id