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_STATUSES_B

Line 1784: OKC_STATUSES_B fee_sts,

1780: Select nvl(sum(cov_ast_kle.capital_amount),0) capitalized_fee
1781: From
1782: OKL_K_LINES fee_kle,
1783: OKC_K_LINES_B fee_cle,
1784: OKC_STATUSES_B fee_sts,
1785: OKL_K_LINES cov_ast_kle,
1786: OKC_K_LINES_B cov_ast_cle,
1787: OKC_LINE_STYLES_B cov_ast_lse,
1788: OKC_STATUSES_B cov_ast_sts,

Line 1788: OKC_STATUSES_B cov_ast_sts,

1784: OKC_STATUSES_B fee_sts,
1785: OKL_K_LINES cov_ast_kle,
1786: OKC_K_LINES_B cov_ast_cle,
1787: OKC_LINE_STYLES_B cov_ast_lse,
1788: OKC_STATUSES_B cov_ast_sts,
1789: OKC_K_ITEMS cov_ast_cim,
1790: OKC_K_LINES_B fa_cle,
1791: OKC_K_LINES_B src_cle
1792: Where fee_kle.id = fee_cle.id

Line 4650: okc_statuses_b sts

4646: Cursor fa_line_csr(p_chrv_id IN Number) is
4647: SELECT cle.id,
4648: cle.cle_id
4649: from okc_k_lines_b cle,
4650: okc_statuses_b sts
4651: where cle.lse_id = G_FA_LINE_LTY_ID
4652: and cle.dnz_chr_id = p_chrv_id
4653: and cle.sts_code = sts.code
4654: and sts.ste_code not in ('HOLD','EXPIRED','TERMINATED','CANCELLED');

Line 5135: from OKC_STATUSES_B sts

5131: --Bug# 6373605 end
5132: AND cle.dnz_chr_id = p_rbk_chr_id
5133: AND cle.lse_id = lse.id
5134: AND not exists (select '1'
5135: from OKC_STATUSES_B sts
5136: Where sts.code = cle.sts_code
5137: And sts.ste_code in ('HOLD','EXPIRED','TERMINATED','CANCELLED')
5138: )
5139: AND lse.lty_code = G_FA_LINE_LTY_CODE

Line 5193: from OKC_STATUSES_B sts

5189: AND txl.kle_id = cle.id
5190: AND cle.dnz_chr_id = p_rbk_chr_id
5191: AND cle.lse_id = lse.id
5192: AND not exists (select '1'
5193: from OKC_STATUSES_B sts
5194: Where sts.code = cle.sts_code
5195: And sts.ste_code in ('HOLD','EXPIRED','TERMINATED','CANCELLED')
5196: )
5197: AND lse.lty_code = G_FA_LINE_LTY_CODE;

Line 5234: OKC_STATUSES_B sts,

5230: p_asset_id2 IN VARCHAR2,
5231: p_effective_date IN DATE) IS
5232: Select '!'
5233: from OKC_K_LINES_B cle,
5234: OKC_STATUSES_B sts,
5235: OKC_K_ITEMS cim
5236: Where cle.sts_code = sts.CODE
5237: And cle.id = cim.cle_id
5238: And cle.dnz_chr_id = p_chr_id

Line 6318: from OKC_STATUSES_B sts

6314: --AND nvl(cle.start_date,p_effective_date) <= p_effective_date
6315: --AND nvl(cle.end_date,p_effective_date+1) > p_effective_date
6316: AND p_effective_date between cle.start_date and cle.end_date
6317: AND not exists (select '1'
6318: from OKC_STATUSES_B sts
6319: Where sts.code = cle.sts_code
6320: --Bug# 2522268
6321: --And sts.ste_code in ('HOLD','EXPIRED','TERMINATED','CANCELED'));
6322: And sts.ste_code in ('HOLD','EXPIRED','TERMINATED','CANCELLED'));

Line 6372: from OKC_STATUSES_B sts

6368: AND cle.lse_id = lse.id
6369: --sechawla : Bug# 8370324
6370: -- AND p_effective_date between cle.start_date and cle.end_date
6371: AND not exists (select '1'
6372: from OKC_STATUSES_B sts
6373: Where sts.code = cle.sts_code
6374: And sts.ste_code in ('HOLD','EXPIRED','TERMINATED','CANCELLED')
6375: )
6376: AND lse.lty_code = G_FA_LINE_LTY_CODE

Line 6424: from OKC_STATUSES_B sts

6420: AND cle.lse_id = lse.id
6421: --sechawla : Bug# 8370324
6422: --AND p_effective_date between cle.start_date and cle.end_date
6423: AND not exists (select '1'
6424: from OKC_STATUSES_B sts
6425: Where sts.code = cle.sts_code
6426: And sts.ste_code in ('HOLD','EXPIRED','TERMINATED','CANCELLED')
6427: )
6428: AND lse.lty_code = G_FA_LINE_LTY_CODE

Line 6474: OKC_STATUSES_B sts,

6470: p_asset_id2 IN VARCHAR2,
6471: p_effective_date IN DATE) IS
6472: Select '!'
6473: from OKC_K_LINES_B cle,
6474: OKC_STATUSES_B sts,
6475: OKC_K_ITEMS cim
6476: Where cle.sts_code = sts.CODE
6477: --sechawla : Bug# 8370324
6478: --And p_effective_date between cle.start_date and cle.end_date

Line 7208: from OKC_STATUSES_B sts

7204: --effectivity
7205: --And nvl(cle.start_date,p_effective_date) <= p_effective_date
7206: --And nvl(cle.end_date,p_effective_date+1) > p_effective_date
7207: AND not exists (select '1'
7208: from OKC_STATUSES_B sts
7209: Where sts.code = cle.sts_code
7210: --Bug# 2522268
7211: --And sts.ste_code in ('HOLD','EXPIRED','TERMINATED','CANCELED')
7212: And sts.ste_code in ('HOLD','EXPIRED','TERMINATED','CANCELLED')

Line 7289: from OKC_STATUSES_B sts

7285: --effectivity
7286: --And nvl(cle.start_date,p_effective_date) <= p_effective_date
7287: --And nvl(cle.end_date,p_effective_date+1) > p_effective_date
7288: AND not exists (select '1'
7289: from OKC_STATUSES_B sts
7290: Where sts.code = cle.sts_code
7291: --Bug#2522268
7292: --And sts.ste_code in ('HOLD','EXPIRED','TERMINATED','CANCELED')
7293: And sts.ste_code in ('HOLD','EXPIRED','TERMINATED','CANCELLED')

Line 7377: okc_statuses_b stsb

7373: --Bug# 3783518
7374: cleb.orig_system_id1
7375: from okc_k_lines_b cleb,
7376: okc_line_styles_b lseb,
7377: okc_statuses_b stsb
7378: where cleb.chr_id = p_chr_id
7379: and cleb.dnz_chr_id = p_chr_id
7380: and lseb.id = cleb.lse_id
7381: and lseb.lty_code = G_FIN_AST_LINE_LTY_CODE

Line 7486: from OKC_STATUSES_B sts

7482: WHERE txl.kle_id = cle.id
7483: AND cle.dnz_chr_id = p_chr_id
7484: AND cle.lse_id = lse.id
7485: AND not exists (select '1'
7486: from OKC_STATUSES_B sts
7487: Where sts.code = cle.sts_code
7488: And sts.ste_code in ('HOLD','EXPIRED','TERMINATED','CANCELLED')
7489: )
7490: AND lse.lty_code = G_FA_LINE_LTY_CODE

Line 7599: OKC_STATUSES_B fee_sts,

7595: Select nvl(sum(cov_ast_kle.capital_amount),0) capitalized_fee
7596: From
7597: OKL_K_LINES fee_kle,
7598: OKC_K_LINES_B fee_cle,
7599: OKC_STATUSES_B fee_sts,
7600: OKL_K_LINES cov_ast_kle,
7601: OKC_K_LINES_B cov_ast_cle,
7602: OKC_LINE_STYLES_B cov_ast_lse,
7603: OKC_STATUSES_B cov_ast_sts,

Line 7603: OKC_STATUSES_B cov_ast_sts,

7599: OKC_STATUSES_B fee_sts,
7600: OKL_K_LINES cov_ast_kle,
7601: OKC_K_LINES_B cov_ast_cle,
7602: OKC_LINE_STYLES_B cov_ast_lse,
7603: OKC_STATUSES_B cov_ast_sts,
7604: OKC_K_ITEMS cov_ast_cim,
7605: OKC_K_LINES_B fa_cle
7606: Where fee_kle.id = fee_cle.id
7607: and fee_kle.fee_type = 'CAPITALIZED'

Line 9341: OKC_STATUSES_B fee_sts,

9337: Select nvl(sum(cov_ast_kle.capital_amount),0) capitalized_fee
9338: From
9339: OKL_K_LINES fee_kle,
9340: OKC_K_LINES_B fee_cle,
9341: OKC_STATUSES_B fee_sts,
9342: OKL_K_LINES cov_ast_kle,
9343: OKC_K_LINES_B cov_ast_cle,
9344: OKC_STATUSES_B cov_ast_sts,
9345: OKC_K_ITEMS cov_ast_cim

Line 9344: OKC_STATUSES_B cov_ast_sts,

9340: OKC_K_LINES_B fee_cle,
9341: OKC_STATUSES_B fee_sts,
9342: OKL_K_LINES cov_ast_kle,
9343: OKC_K_LINES_B cov_ast_cle,
9344: OKC_STATUSES_B cov_ast_sts,
9345: OKC_K_ITEMS cov_ast_cim
9346: Where fee_kle.id = fee_cle.id
9347: and fee_kle.fee_type = 'CAPITALIZED'
9348: and fee_cle.dnz_chr_id = p_chr_id