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 4638: From OKC_K_HEADERS_B chr,

4634: khr.DEAL_TYPE,
4635: --11.5.9(Multi GAAP)
4636: khr.PDT_ID,
4637: chr.START_DATE
4638: From OKC_K_HEADERS_B chr,
4639: OKL_K_HEADERS khr
4640: WHERE khr.id = chr.id
4641: AND chr.ID = P_CHRV_ID;
4642:

Line 5044: OKC_K_HEADERS_B chr,

5040: --Bug# 3156924
5041: ktrx.trx_number
5042: FROM OKC_RULES_B rul,
5043: OKL_K_HEADERS khr,
5044: OKC_K_HEADERS_B chr,
5045: OKL_TRX_CONTRACTS ktrx,
5046: OKC_K_HEADERS_B rbk_chr
5047: WHERE rul.dnz_chr_id = chr.id
5048: AND rul.rule_information_category = 'LATOWN'

Line 5046: OKC_K_HEADERS_B rbk_chr

5042: FROM OKC_RULES_B rul,
5043: OKL_K_HEADERS khr,
5044: OKC_K_HEADERS_B chr,
5045: OKL_TRX_CONTRACTS ktrx,
5046: OKC_K_HEADERS_B rbk_chr
5047: WHERE rul.dnz_chr_id = chr.id
5048: AND rul.rule_information_category = 'LATOWN'
5049: AND khr.id = chr.id
5050: AND chr.id = rbk_chr.orig_system_id1

Line 5067: l_chr_id OKC_K_HEADERS_B.ID%TYPE;

5063: AND rbk_chr.id = p_rbk_chr_id;
5064:
5065: l_rbr_code OKL_TRX_CONTRACTS.rbr_code%TYPE;
5066: l_deal_type OKL_K_HEADERS.deal_type%TYPE;
5067: l_chr_id OKC_K_HEADERS_B.ID%TYPE;
5068: l_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;
5069: l_date_trx_occured OKL_TRX_CONTRACTS.date_transaction_occurred%TYPE;
5070: l_tax_owner OKC_RULES_B.RULE_INFORMATION1%TYPE;
5071: --Bug# : 11.5.9 enhancement Multi GAAP

Line 5068: l_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;

5064:
5065: l_rbr_code OKL_TRX_CONTRACTS.rbr_code%TYPE;
5066: l_deal_type OKL_K_HEADERS.deal_type%TYPE;
5067: l_chr_id OKC_K_HEADERS_B.ID%TYPE;
5068: l_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;
5069: l_date_trx_occured OKL_TRX_CONTRACTS.date_transaction_occurred%TYPE;
5070: l_tax_owner OKC_RULES_B.RULE_INFORMATION1%TYPE;
5071: --Bug# : 11.5.9 enhancement Multi GAAP
5072: l_pdt_id OKL_K_HEADERS.pdt_id%TYPE;

Line 5264: okc_k_headers_b chr

5260: From okc_k_lines_v clev,
5261: okc_line_styles_b lse,
5262: okc_k_lines_b fa_cle,
5263: okc_line_styles_b fa_lse,
5264: okc_k_headers_b chr
5265: where clev.chr_id = chr.orig_system_id1
5266: and clev.dnz_chr_id = chr.orig_system_id1
5267: and chr.id = p_rbk_chr_id
5268: and chr.orig_system_source_code = 'OKL_REBOOK'

Line 5285: l_orig_chr_id OKC_K_HEADERS_B.ID%TYPE;

5281: and fa_lse.lty_code = G_FA_LINE_LTY_CODE;
5282:
5283: l_new_fin_cle_id OKC_K_LINES_B.ID%TYPE;
5284: l_new_fa_cle_id OKC_K_LINES_B.ID%TYPE;
5285: l_orig_chr_id OKC_K_HEADERS_B.ID%TYPE;
5286: lx_cimv_rec cimv_rec_type;
5287: lx_cimv_ib_tbl cimv_tbl_type;
5288:
5289: l_dummy_amount NUMBER;

Line 6262: OKC_K_HEADERS_B chr,

6258: --Bug# 3156924
6259: ktrx.trx_number
6260: FROM OKC_RULES_B rul,
6261: OKL_K_HEADERS khr,
6262: OKC_K_HEADERS_B chr,
6263: OKL_TRX_CONTRACTS ktrx
6264: WHERE rul.dnz_chr_id = chr.id
6265: AND rul.rule_information_category = 'LATOWN'
6266: AND khr.id = chr.id

Line 6283: l_chr_id OKC_K_HEADERS_B.ID%TYPE;

6279: AND ktrx.tsu_code = G_TSU_CODE_ENTERED;
6280:
6281: l_rbr_code OKL_TRX_CONTRACTS.rbr_code%TYPE;
6282: l_deal_type OKL_K_HEADERS.deal_type%TYPE;
6283: l_chr_id OKC_K_HEADERS_B.ID%TYPE;
6284: l_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;
6285: l_date_trx_occured OKL_TRX_CONTRACTS.date_transaction_occurred%TYPE;
6286: l_tax_owner OKC_RULES_B.RULE_INFORMATION1%TYPE;
6287: --Bug# 3156924

Line 6284: l_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;

6280:
6281: l_rbr_code OKL_TRX_CONTRACTS.rbr_code%TYPE;
6282: l_deal_type OKL_K_HEADERS.deal_type%TYPE;
6283: l_chr_id OKC_K_HEADERS_B.ID%TYPE;
6284: l_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;
6285: l_date_trx_occured OKL_TRX_CONTRACTS.date_transaction_occurred%TYPE;
6286: l_tax_owner OKC_RULES_B.RULE_INFORMATION1%TYPE;
6287: --Bug# 3156924
6288: l_trans_number OKL_TRX_CONTRACTS.trx_number%TYPE;

Line 7119: OKC_K_HEADERS_B chr

7115: --Bug# 4631549
7116: chr.orig_system_source_code
7117: FROM OKC_RULES_B rul,
7118: OKL_K_HEADERS khr,
7119: OKC_K_HEADERS_B chr
7120: WHERE rul.dnz_chr_id = chr.id
7121: AND rul.rule_information_category = 'LATOWN'
7122: AND rul.dnz_chr_id = khr.id
7123: AND khr.id = chr.id

Line 7144: l_rel_chr_id OKC_K_HEADERS_B.ID%TYPE;

7140: AND cleb.id = kle.id
7141: AND nvl(kle.re_lease_yn,'N') = 'Y');
7142: --Bug# 15992711 End of Modifications
7143: l_deal_type OKL_K_HEADERS.deal_type%TYPE;
7144: l_rel_chr_id OKC_K_HEADERS_B.ID%TYPE;
7145: l_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;
7146: l_tax_owner OKC_RULES_B.RULE_INFORMATION1%TYPE;
7147: l_orig_chr_id OKC_K_HEADERS_B.ID%TYPE;
7148: --Bug# : 11.5.9 enhancement Multi GAAP

Line 7145: l_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;

7141: AND nvl(kle.re_lease_yn,'N') = 'Y');
7142: --Bug# 15992711 End of Modifications
7143: l_deal_type OKL_K_HEADERS.deal_type%TYPE;
7144: l_rel_chr_id OKC_K_HEADERS_B.ID%TYPE;
7145: l_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;
7146: l_tax_owner OKC_RULES_B.RULE_INFORMATION1%TYPE;
7147: l_orig_chr_id OKC_K_HEADERS_B.ID%TYPE;
7148: --Bug# : 11.5.9 enhancement Multi GAAP
7149: l_pdt_id OKL_K_HEADERS.pdt_id%TYPE;

Line 7147: l_orig_chr_id OKC_K_HEADERS_B.ID%TYPE;

7143: l_deal_type OKL_K_HEADERS.deal_type%TYPE;
7144: l_rel_chr_id OKC_K_HEADERS_B.ID%TYPE;
7145: l_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;
7146: l_tax_owner OKC_RULES_B.RULE_INFORMATION1%TYPE;
7147: l_orig_chr_id OKC_K_HEADERS_B.ID%TYPE;
7148: --Bug# : 11.5.9 enhancement Multi GAAP
7149: l_pdt_id OKL_K_HEADERS.pdt_id%TYPE;
7150: l_start_date Date;
7151: l_rep_pdt_id Number;

Line 7156: l_orig_system_source_code okc_k_headers_b.orig_system_source_code%TYPE;

7152: l_rep_deal_type Varchar2(150);
7153: l_Multi_GAAP_YN Varchar2(1) := 'N';
7154: l_rep_pdt_book OKX_AST_BKS_V.Book_Type_Code%Type;
7155: --Bug# 4631549
7156: l_orig_system_source_code okc_k_headers_b.orig_system_source_code%TYPE;
7157:
7158: ---------------- ---------------------------------------------------------------*/
7159:
7160: --cursor to get the modified transaction values against the release contract

Line 9066: FROM okc_k_headers_b CHR,

9062:
9063: --cursor to check if the contract is selected for Mass Rebook
9064: CURSOR l_chk_mass_rbk_csr (p_chr_id IN NUMBER) IS
9065: SELECT 'Y'
9066: FROM okc_k_headers_b CHR,
9067: okl_trx_contracts ktrx
9068: where CHR.ID = p_chr_id
9069: AND ktrx.KHR_ID = chr.id
9070: AND ktrx.tsu_code = 'ENTERED'

Line 9123: okc_k_headers_b chrb

9119: rul.rule_information1
9120: from okc_rules_b rul,
9121: okc_rule_groups_b rgp,
9122: okl_k_headers khr,
9123: okc_k_headers_b chrb
9124: where rul.rule_information_category = 'LATOWN'
9125: and rul.rgp_id = rgp.id
9126: and rul.dnz_chr_id = rgp.dnz_chr_id
9127: and rgp.dnz_chr_id = chrb.id

Line 9326: from okc_k_headers_b

9322: -- cursor to get ORIG_SYSTEM_SOURCE_CODE of the contract
9323:
9324: cursor l_orig_sys_src_code_csr (p_chr_id in number) is
9325: select id, ORIG_SYSTEM_SOURCE_CODE
9326: from okc_k_headers_b
9327: where id = p_chr_id;
9328:
9329: l_chr_id okc_k_headers_b.id%type;
9330: l_orig_system_source_code okc_k_headers_b.orig_system_source_code%type;

Line 9329: l_chr_id okc_k_headers_b.id%type;

9325: select id, ORIG_SYSTEM_SOURCE_CODE
9326: from okc_k_headers_b
9327: where id = p_chr_id;
9328:
9329: l_chr_id okc_k_headers_b.id%type;
9330: l_orig_system_source_code okc_k_headers_b.orig_system_source_code%type;
9331: l_cle_id okl_k_lines_v.id%type;
9332: l_exp_asset_cost okl_k_lines_v.expected_asset_cost%type;
9333:

Line 9330: l_orig_system_source_code okc_k_headers_b.orig_system_source_code%type;

9326: from okc_k_headers_b
9327: where id = p_chr_id;
9328:
9329: l_chr_id okc_k_headers_b.id%type;
9330: l_orig_system_source_code okc_k_headers_b.orig_system_source_code%type;
9331: l_cle_id okl_k_lines_v.id%type;
9332: l_exp_asset_cost okl_k_lines_v.expected_asset_cost%type;
9333:
9334: --cursor to get Cap fees added during Re-lease for the asset

Line 10829: FROM okc_k_headers_b CHR,

10825:
10826: --cursor to check if the contract is undergoing on-line rebook
10827: cursor l_chk_rbk_csr(p_chr_id IN NUMBER) is
10828: SELECT '!'
10829: FROM okc_k_headers_b CHR,
10830: okl_trx_contracts ktrx
10831: WHERE ktrx.khr_id_new = chr.id
10832: AND ktrx.tsu_code = 'ENTERED'
10833: AND ktrx.rbr_code is NOT NULL

Line 10878: okc_k_headers_b chrb

10874: rul.rule_information1
10875: from okc_rules_b rul,
10876: okc_rule_groups_b rgp,
10877: okl_k_headers khr,
10878: okc_k_headers_b chrb
10879: where rul.rule_information_category = 'LATOWN'
10880: and rul.rgp_id = rgp.id
10881: and rul.dnz_chr_id = rgp.dnz_chr_id
10882: and rgp.dnz_chr_id = chrb.id