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_LINE_STYLES_B

Line 1787: OKC_LINE_STYLES_B cov_ast_lse,

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,
1789: OKC_K_ITEMS cov_ast_cim,
1790: OKC_K_LINES_B fa_cle,
1791: OKC_K_LINES_B src_cle

Line 3089: OKC_LINE_STYLES_B lse

3085: --Cursor to fetch line style source
3086: Cursor lse_source_csr(p_lty_code IN VARCHAR2) is
3087: select src.jtot_object_code
3088: from OKC_LINE_STYLE_SOURCES src,
3089: OKC_LINE_STYLES_B lse
3090: where src.lse_id = lse.id
3091: and lse.lty_code = p_lty_code;
3092:
3093: --Cursor to fetch book records for an asset

Line 5127: OKC_LINE_STYLES_B lse

5123: --Bug# 6373605 start
5124: OKL_TRX_ASSETS tas,
5125: --Bug# 6373605 end
5126: OKC_K_LINES_B cle,
5127: OKC_LINE_STYLES_B lse
5128: WHERE txl.kle_id = cle.id
5129: --Bug# 6373605 start
5130: AND tas.id = txl.tas_id
5131: --Bug# 6373605 end

Line 5184: OKC_LINE_STYLES_B lse

5180: --Bug# 6373605 start
5181: OKL_TRX_ASSETS tas,
5182: --Bug# 6373605 end
5183: OKC_K_LINES_B cle,
5184: OKC_LINE_STYLES_B lse
5185: WHERE txd.tal_id = txl.id
5186: --Bug# 6373605 start
5187: AND tas.id = txl.tas_id
5188: --Bug# 6373605

Line 5261: okc_line_styles_b lse,

5257: Select clev.id new_fin_cle_id,
5258: fa_cle.id new_fa_cle_id,
5259: clev.chr_id orig_chr_id
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

Line 5263: okc_line_styles_b fa_lse,

5259: clev.chr_id orig_chr_id
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

Line 6300: OKC_LINE_STYLES_B lse,

6296: kle.RESIDUAL_VALUE,
6297: cle.id,
6298: cle.name
6299: FROM OKC_K_LINES_V cle,
6300: OKC_LINE_STYLES_B lse,
6301: OKL_K_LINES kle,
6302: OKC_K_LINES_B fa_cle,
6303: OKC_LINE_STYLES_B fa_cle_lse
6304: WHERE kle.id = cle.id

Line 6303: OKC_LINE_STYLES_B fa_cle_lse

6299: FROM OKC_K_LINES_V cle,
6300: OKC_LINE_STYLES_B lse,
6301: OKL_K_LINES kle,
6302: OKC_K_LINES_B fa_cle,
6303: OKC_LINE_STYLES_B fa_cle_lse
6304: WHERE kle.id = cle.id
6305: AND cle.chr_id = p_chr_id
6306: AND cle.dnz_chr_id = p_chr_id
6307: AND cle.lse_id = lse.id

Line 6361: OKC_LINE_STYLES_B lse

6357: --Bug# 6373605 start
6358: OKL_TRX_ASSETS tas,
6359: --Bug# 6373605 end
6360: OKC_K_LINES_B cle,
6361: OKC_LINE_STYLES_B lse
6362: WHERE txl.kle_id = cle.id
6363: AND txl.tal_type = 'CRB'
6364: --Bug# 6373605 start
6365: AND tas.id = txl.tas_id

Line 6413: OKC_LINE_STYLES_B lse

6409: --Bug# 6373605 start
6410: OKL_TRX_ASSETS tas,
6411: --Bug# 6373605 end
6412: OKC_K_LINES_B cle,
6413: OKC_LINE_STYLES_B lse
6414: WHERE txd.tal_id = txl.id
6415: --Bug# 6373605 start
6416: AND tas.id = txl.tas_id
6417: --Bug# 6373605

Line 7198: OKC_LINE_STYLES_B lse,

7194: FROM OKL_TRX_TYPES_TL ttyp,
7195: OKL_TRX_ASSETS trx,
7196: OKL_TXL_ASSETS_B txl,
7197: OKC_K_LINES_B cle,
7198: OKC_LINE_STYLES_B lse,
7199: -- Bug# 3631094
7200: FA_BOOK_CONTROLS fab
7201: WHERE txl.kle_id = cle.id
7202: AND cle.dnz_chr_id = p_rel_chr_id

Line 7278: OKC_LINE_STYLES_B lse,

7274: OKL_TRX_ASSETS trx,
7275: OKL_TXD_ASSETS_B txd,
7276: OKL_TXL_ASSETS_B txl,
7277: OKC_K_LINES_B cle,
7278: OKC_LINE_STYLES_B lse,
7279: -- Bug# 3631094
7280: FA_BOOK_CONTROLS fab
7281: WHERE txd.tal_id = txl.id
7282: AND txl.kle_id = cle.id

Line 7376: okc_line_styles_b lseb,

7372: select cleb.id,
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

Line 7417: okc_line_styles_b fa_lseb,

7413: okl_trx_types_tl ttyp,
7414: okl_trx_assets trx,
7415: okl_txl_assets_b txl,
7416: okc_k_lines_b fa_cleb,
7417: okc_line_styles_b fa_lseb,
7418: okc_k_lines_tl ast_clet
7419: where
7420: fab.asset_id = to_number(fa_cim.object1_id1)
7421: and fab.transaction_header_id_out is NULL

Line 7481: OKC_LINE_STYLES_B lse

7477: SELECT trx.id
7478: FROM OKL_TRX_ASSETS trx,
7479: OKL_TXL_ASSETS_B txl,
7480: OKC_K_LINES_B cle,
7481: OKC_LINE_STYLES_B lse
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'

Line 7602: OKC_LINE_STYLES_B cov_ast_lse,

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,
7604: OKC_K_ITEMS cov_ast_cim,
7605: OKC_K_LINES_B fa_cle
7606: Where fee_kle.id = fee_cle.id

Line 9049: okc_line_styles_b lseb

9045: from okl_trx_types_tl ttyt,
9046: okl_trx_assets trx,
9047: okl_txl_assets_b txl,
9048: okc_k_lines_b cleb,
9049: okc_line_styles_b lseb
9050: where ttyt.id = trx.try_id
9051: and ttyt.language = 'US'
9052: and trx.id = txl.tas_id
9053: and trx.tsu_code = 'ENTERED'

Line 9097: okc_line_styles_b lseb

9093: fa_books fab,
9094: fa_book_controls fbc,
9095: okc_k_items cim,
9096: okc_k_lines_b cleb,
9097: okc_line_styles_b lseb
9098: where fab.asset_id = fa.asset_id
9099: and fab.transaction_header_id_out is null
9100: and fbc.book_type_code = fab.book_type_code
9101: and fa.asset_id = cim.object1_id1

Line 10855: okc_line_styles_b lseb

10851: from okl_trx_types_tl ttyt,
10852: okl_trx_assets trx,
10853: okl_txl_assets_b txl,
10854: okc_k_lines_b cleb,
10855: okc_line_styles_b lseb
10856: where ttyt.id = trx.try_id
10857: and ttyt.language = 'US'
10858: and trx.id = txl.tas_id
10859: and trx.tsu_code = 'ENTERED'