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 1780: OKC_STATUSES_B fee_sts,

1776: Select nvl(sum(cov_ast_kle.capital_amount),0) capitalized_fee
1777: From
1778: OKL_K_LINES fee_kle,
1779: OKC_K_LINES_B fee_cle,
1780: OKC_STATUSES_B fee_sts,
1781: OKL_K_LINES cov_ast_kle,
1782: OKC_K_LINES_B cov_ast_cle,
1783: OKC_LINE_STYLES_B cov_ast_lse,
1784: OKC_STATUSES_B cov_ast_sts,

Line 1784: OKC_STATUSES_B cov_ast_sts,

1780: OKC_STATUSES_B fee_sts,
1781: OKL_K_LINES cov_ast_kle,
1782: OKC_K_LINES_B cov_ast_cle,
1783: OKC_LINE_STYLES_B cov_ast_lse,
1784: OKC_STATUSES_B cov_ast_sts,
1785: OKC_K_ITEMS cov_ast_cim,
1786: OKC_K_LINES_B fa_cle,
1787: OKC_K_LINES_B src_cle
1788: Where fee_kle.id = fee_cle.id

Line 4641: okc_statuses_b sts

4637: Cursor fa_line_csr(p_chrv_id IN Number) is
4638: SELECT cle.id,
4639: cle.cle_id
4640: from okc_k_lines_b cle,
4641: okc_statuses_b sts
4642: where cle.lse_id = G_FA_LINE_LTY_ID
4643: and cle.dnz_chr_id = p_chrv_id
4644: and cle.sts_code = sts.code
4645: and sts.ste_code not in ('HOLD','EXPIRED','TERMINATED','CANCELLED');

Line 5099: from OKC_STATUSES_B sts

5095: --AND nvl(cle.start_date,p_effective_date) <= p_effective_date
5096: --AND nvl(cle.end_date,p_effective_date+1) > p_effective_date
5097: And p_effective_date between cle.start_date and cle.end_date
5098: AND not exists (select '1'
5099: from OKC_STATUSES_B sts
5100: Where sts.code = cle.sts_code
5101: --Bug# 2522268
5102: --And sts.ste_code in ('HOLD','EXPIRED','TERMINATED','CANCELED'));
5103: And sts.ste_code in ('HOLD','EXPIRED','TERMINATED','CANCELLED'));

Line 5163: from OKC_STATUSES_B sts

5159: --And nvl(cle.start_date,p_effective_date) <= p_effective_date
5160: --And nvl(cle.end_date,p_effective_date+1) > p_effective_date
5161: And p_effective_date between cle.start_date and cle.end_date
5162: AND not exists (select '1'
5163: from OKC_STATUSES_B sts
5164: Where sts.code = cle.sts_code
5165: --Bug# 2522268
5166: --And sts.ste_code in ('HOLD','EXPIRED','TERMINATED','CANCELED')
5167: And sts.ste_code in ('HOLD','EXPIRED','TERMINATED','CANCELLED')

Line 5223: from OKC_STATUSES_B sts

5219: --And nvl(cle.start_date,p_effective_date) <= p_effective_date
5220: --And nvl(cle.end_date,p_effective_date+1) > p_effective_date
5221: And p_effective_date between cle.start_date and cle.end_date
5222: AND not exists (select '1'
5223: from OKC_STATUSES_B sts
5224: Where sts.code = cle.sts_code
5225: --Bug# 2522268
5226: --And sts.ste_code in ('HOLD','EXPIRED','TERMINATED','CANCELED')
5227: And sts.ste_code in ('HOLD','EXPIRED','TERMINATED','CANCELLED')

Line 5266: OKC_STATUSES_B sts,

5262: p_asset_id2 IN VARCHAR2,
5263: p_effective_date IN DATE) IS
5264: Select '!'
5265: from OKC_K_LINES_B cle,
5266: OKC_STATUSES_B sts,
5267: OKC_K_ITEMS cim
5268: Where cle.sts_code = sts.CODE
5269: --Bug# 2942543 : effectivity should be checked by keeping start and end date as inclusive
5270: --And nvl(sts.start_date,p_effective_date) <= p_effective_date

Line 6384: from OKC_STATUSES_B sts

6380: --AND nvl(cle.start_date,p_effective_date) <= p_effective_date
6381: --AND nvl(cle.end_date,p_effective_date+1) > p_effective_date
6382: AND p_effective_date between cle.start_date and cle.end_date
6383: AND not exists (select '1'
6384: from OKC_STATUSES_B sts
6385: Where sts.code = cle.sts_code
6386: --Bug# 2522268
6387: --And sts.ste_code in ('HOLD','EXPIRED','TERMINATED','CANCELED'));
6388: And sts.ste_code in ('HOLD','EXPIRED','TERMINATED','CANCELLED'));

Line 6439: from OKC_STATUSES_B sts

6435: --And nvl(cle.start_date,p_effective_date) <= p_effective_date
6436: --And nvl(cle.end_date,p_effective_date+1) > p_effective_date
6437: AND p_effective_date between cle.start_date and cle.end_date
6438: AND not exists (select '1'
6439: from OKC_STATUSES_B sts
6440: Where sts.code = cle.sts_code
6441: --Bug# 2522268
6442: --And sts.ste_code in ('HOLD','EXPIRED','TERMINATED','CANCELED')
6443: And sts.ste_code in ('HOLD','EXPIRED','TERMINATED','CANCELLED')

Line 6494: from OKC_STATUSES_B sts

6490: --And nvl(cle.start_date,p_effective_date) <= p_effective_date
6491: --And nvl(cle.end_date,p_effective_date+1) > p_effective_date
6492: AND p_effective_date between cle.start_date and cle.end_date
6493: AND not exists (select '1'
6494: from OKC_STATUSES_B sts
6495: Where sts.code = cle.sts_code
6496: --Bug# 2522268
6497: --And sts.ste_code in ('HOLD','EXPIRED','TERMINATED','CANCELED')
6498: And sts.ste_code in ('HOLD','EXPIRED','TERMINATED','CANCELLED')

Line 6546: OKC_STATUSES_B sts,

6542: p_asset_id2 IN VARCHAR2,
6543: p_effective_date IN DATE) IS
6544: Select '!'
6545: from OKC_K_LINES_B cle,
6546: OKC_STATUSES_B sts,
6547: OKC_K_ITEMS cim
6548: Where cle.sts_code = sts.CODE
6549: --Bug# 2942543 : effectivity should be checked by keeping start and end date as inclusive
6550: --And nvl(sts.start_date,p_effective_date) <= p_effective_date

Line 7483: from OKC_STATUSES_B sts

7479: --effectivity
7480: --And nvl(cle.start_date,p_effective_date) <= p_effective_date
7481: --And nvl(cle.end_date,p_effective_date+1) > p_effective_date
7482: AND not exists (select '1'
7483: from OKC_STATUSES_B sts
7484: Where sts.code = cle.sts_code
7485: --Bug# 2522268
7486: --And sts.ste_code in ('HOLD','EXPIRED','TERMINATED','CANCELED')
7487: And sts.ste_code in ('HOLD','EXPIRED','TERMINATED','CANCELLED')

Line 7564: from OKC_STATUSES_B sts

7560: --effectivity
7561: --And nvl(cle.start_date,p_effective_date) <= p_effective_date
7562: --And nvl(cle.end_date,p_effective_date+1) > p_effective_date
7563: AND not exists (select '1'
7564: from OKC_STATUSES_B sts
7565: Where sts.code = cle.sts_code
7566: --Bug#2522268
7567: --And sts.ste_code in ('HOLD','EXPIRED','TERMINATED','CANCELED')
7568: And sts.ste_code in ('HOLD','EXPIRED','TERMINATED','CANCELLED')

Line 7652: okc_statuses_b stsb

7648: --Bug# 3783518
7649: cleb.orig_system_id1
7650: from okc_k_lines_b cleb,
7651: okc_line_styles_b lseb,
7652: okc_statuses_b stsb
7653: where cleb.chr_id = p_chr_id
7654: and cleb.dnz_chr_id = p_chr_id
7655: and lseb.id = cleb.lse_id
7656: and lseb.lty_code = G_FIN_AST_LINE_LTY_CODE

Line 7761: from OKC_STATUSES_B sts

7757: WHERE txl.kle_id = cle.id
7758: AND cle.dnz_chr_id = p_chr_id
7759: AND cle.lse_id = lse.id
7760: AND not exists (select '1'
7761: from OKC_STATUSES_B sts
7762: Where sts.code = cle.sts_code
7763: And sts.ste_code in ('HOLD','EXPIRED','TERMINATED','CANCELLED')
7764: )
7765: AND lse.lty_code = G_FA_LINE_LTY_CODE

Line 7874: OKC_STATUSES_B fee_sts,

7870: Select nvl(sum(cov_ast_kle.capital_amount),0) capitalized_fee
7871: From
7872: OKL_K_LINES fee_kle,
7873: OKC_K_LINES_B fee_cle,
7874: OKC_STATUSES_B fee_sts,
7875: OKL_K_LINES cov_ast_kle,
7876: OKC_K_LINES_B cov_ast_cle,
7877: OKC_LINE_STYLES_B cov_ast_lse,
7878: OKC_STATUSES_B cov_ast_sts,

Line 7878: OKC_STATUSES_B cov_ast_sts,

7874: OKC_STATUSES_B fee_sts,
7875: OKL_K_LINES cov_ast_kle,
7876: OKC_K_LINES_B cov_ast_cle,
7877: OKC_LINE_STYLES_B cov_ast_lse,
7878: OKC_STATUSES_B cov_ast_sts,
7879: OKC_K_ITEMS cov_ast_cim,
7880: OKC_K_LINES_B fa_cle
7881: Where fee_kle.id = fee_cle.id
7882: and fee_kle.fee_type = 'CAPITALIZED'

Line 9616: OKC_STATUSES_B fee_sts,

9612: Select nvl(sum(cov_ast_kle.capital_amount),0) capitalized_fee
9613: From
9614: OKL_K_LINES fee_kle,
9615: OKC_K_LINES_B fee_cle,
9616: OKC_STATUSES_B fee_sts,
9617: OKL_K_LINES cov_ast_kle,
9618: OKC_K_LINES_B cov_ast_cle,
9619: OKC_STATUSES_B cov_ast_sts,
9620: OKC_K_ITEMS cov_ast_cim

Line 9619: OKC_STATUSES_B cov_ast_sts,

9615: OKC_K_LINES_B fee_cle,
9616: OKC_STATUSES_B fee_sts,
9617: OKL_K_LINES cov_ast_kle,
9618: OKC_K_LINES_B cov_ast_cle,
9619: OKC_STATUSES_B cov_ast_sts,
9620: OKC_K_ITEMS cov_ast_cim
9621: Where fee_kle.id = fee_cle.id
9622: and fee_kle.fee_type = 'CAPITALIZED'
9623: and fee_cle.dnz_chr_id = p_chr_id