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 1783: OKC_LINE_STYLES_B cov_ast_lse,

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,
1785: OKC_K_ITEMS cov_ast_cim,
1786: OKC_K_LINES_B fa_cle,
1787: OKC_K_LINES_B src_cle

Line 3080: OKC_LINE_STYLES_B lse

3076: --Cursor to fetch line style source
3077: Cursor lse_source_csr(p_lty_code IN VARCHAR2) is
3078: select src.jtot_object_code
3079: from OKC_LINE_STYLE_SOURCES src,
3080: OKC_LINE_STYLES_B lse
3081: where src.lse_id = lse.id
3082: and lse.lty_code = p_lty_code;
3083:
3084: --Cursor to fetch book records for an asset

Line 5081: OKC_LINE_STYLES_B lse,

5077: kle.RESIDUAL_VALUE,
5078: cle.id,
5079: cle.name
5080: FROM OKC_K_LINES_V cle,
5081: OKC_LINE_STYLES_B lse,
5082: OKL_K_LINES kle,
5083: OKC_K_LINES_B fa_cle,
5084: OKC_LINE_STYLES_B fa_cle_lse
5085: WHERE kle.id = cle.id

Line 5084: OKC_LINE_STYLES_B fa_cle_lse

5080: FROM OKC_K_LINES_V cle,
5081: OKC_LINE_STYLES_B lse,
5082: OKL_K_LINES kle,
5083: OKC_K_LINES_B fa_cle,
5084: OKC_LINE_STYLES_B fa_cle_lse
5085: WHERE kle.id = cle.id
5086: AND cle.chr_id = p_chr_id
5087: AND cle.dnz_chr_id = p_chr_id
5088: AND cle.lse_id = lse.id

Line 5150: OKC_LINE_STYLES_B lse

5146: --Bug# 6373605 start
5147: OKL_TRX_ASSETS tas,
5148: --Bug# 6373605 end
5149: OKC_K_LINES_B cle,
5150: OKC_LINE_STYLES_B lse
5151: WHERE txl.kle_id = cle.id
5152: --Bug# 6373605 start
5153: AND tas.id = txl.tas_id
5154: --Bug# 6373605 end

Line 5209: OKC_LINE_STYLES_B lse

5205: --Bug# 6373605 start
5206: OKL_TRX_ASSETS tas,
5207: --Bug# 6373605 end
5208: OKC_K_LINES_B cle,
5209: OKC_LINE_STYLES_B lse
5210: WHERE txd.tal_id = txl.id
5211: --Bug# 6373605 start
5212: AND tas.id = txl.tas_id
5213: --Bug# 6373605

Line 5301: okc_line_styles_b lse,

5297: Select clev.id new_fin_cle_id,
5298: fa_cle.id new_fa_cle_id,
5299: clev.chr_id orig_chr_id
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

Line 5303: okc_line_styles_b fa_lse,

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

Line 6366: OKC_LINE_STYLES_B lse,

6362: kle.RESIDUAL_VALUE,
6363: cle.id,
6364: cle.name
6365: FROM OKC_K_LINES_V cle,
6366: OKC_LINE_STYLES_B lse,
6367: OKL_K_LINES kle,
6368: OKC_K_LINES_B fa_cle,
6369: OKC_LINE_STYLES_B fa_cle_lse
6370: WHERE kle.id = cle.id

Line 6369: OKC_LINE_STYLES_B fa_cle_lse

6365: FROM OKC_K_LINES_V cle,
6366: OKC_LINE_STYLES_B lse,
6367: OKL_K_LINES kle,
6368: OKC_K_LINES_B fa_cle,
6369: OKC_LINE_STYLES_B fa_cle_lse
6370: WHERE kle.id = cle.id
6371: AND cle.chr_id = p_chr_id
6372: AND cle.dnz_chr_id = p_chr_id
6373: AND cle.lse_id = lse.id

Line 6425: OKC_LINE_STYLES_B lse

6421: --Bug# 6373605 start
6422: OKL_TRX_ASSETS tas,
6423: --Bug# 6373605 end
6424: OKC_K_LINES_B cle,
6425: OKC_LINE_STYLES_B lse
6426: WHERE txl.kle_id = cle.id
6427: AND txl.tal_type = 'CRB'
6428: --Bug# 6373605 start
6429: AND tas.id = txl.tas_id

Line 6480: OKC_LINE_STYLES_B lse

6476: --Bug# 6373605 start
6477: OKL_TRX_ASSETS tas,
6478: --Bug# 6373605 end
6479: OKC_K_LINES_B cle,
6480: OKC_LINE_STYLES_B lse
6481: WHERE txd.tal_id = txl.id
6482: --Bug# 6373605 start
6483: AND tas.id = txl.tas_id
6484: --Bug# 6373605

Line 7473: OKC_LINE_STYLES_B lse,

7469: FROM OKL_TRX_TYPES_TL ttyp,
7470: OKL_TRX_ASSETS trx,
7471: OKL_TXL_ASSETS_B txl,
7472: OKC_K_LINES_B cle,
7473: OKC_LINE_STYLES_B lse,
7474: -- Bug# 3631094
7475: FA_BOOK_CONTROLS fab
7476: WHERE txl.kle_id = cle.id
7477: AND cle.dnz_chr_id = p_rel_chr_id

Line 7553: OKC_LINE_STYLES_B lse,

7549: OKL_TRX_ASSETS trx,
7550: OKL_TXD_ASSETS_B txd,
7551: OKL_TXL_ASSETS_B txl,
7552: OKC_K_LINES_B cle,
7553: OKC_LINE_STYLES_B lse,
7554: -- Bug# 3631094
7555: FA_BOOK_CONTROLS fab
7556: WHERE txd.tal_id = txl.id
7557: AND txl.kle_id = cle.id

Line 7651: okc_line_styles_b lseb,

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

Line 7692: okc_line_styles_b fa_lseb,

7688: okl_trx_types_tl ttyp,
7689: okl_trx_assets trx,
7690: okl_txl_assets_b txl,
7691: okc_k_lines_b fa_cleb,
7692: okc_line_styles_b fa_lseb,
7693: okc_k_lines_tl ast_clet
7694: where
7695: fab.asset_id = to_number(fa_cim.object1_id1)
7696: and fab.transaction_header_id_out is NULL

Line 7756: OKC_LINE_STYLES_B lse

7752: SELECT trx.id
7753: FROM OKL_TRX_ASSETS trx,
7754: OKL_TXL_ASSETS_B txl,
7755: OKC_K_LINES_B cle,
7756: OKC_LINE_STYLES_B lse
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'

Line 7877: OKC_LINE_STYLES_B cov_ast_lse,

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,
7879: OKC_K_ITEMS cov_ast_cim,
7880: OKC_K_LINES_B fa_cle
7881: Where fee_kle.id = fee_cle.id

Line 9324: okc_line_styles_b lseb

9320: from okl_trx_types_tl ttyt,
9321: okl_trx_assets trx,
9322: okl_txl_assets_b txl,
9323: okc_k_lines_b cleb,
9324: okc_line_styles_b lseb
9325: where ttyt.id = trx.try_id
9326: and ttyt.language = 'US'
9327: and trx.id = txl.tas_id
9328: and trx.tsu_code = 'ENTERED'

Line 9372: okc_line_styles_b lseb

9368: fa_books fab,
9369: fa_book_controls fbc,
9370: okc_k_items cim,
9371: okc_k_lines_b cleb,
9372: okc_line_styles_b lseb
9373: where fab.asset_id = fa.asset_id
9374: and fab.transaction_header_id_out is null
9375: and fbc.book_type_code = fab.book_type_code
9376: and fa.asset_id = cim.object1_id1

Line 11130: okc_line_styles_b lseb

11126: from okl_trx_types_tl ttyt,
11127: okl_trx_assets trx,
11128: okl_txl_assets_b txl,
11129: okc_k_lines_b cleb,
11130: okc_line_styles_b lseb
11131: where ttyt.id = trx.try_id
11132: and ttyt.language = 'US'
11133: and trx.id = txl.tas_id
11134: and trx.tsu_code = 'ENTERED'