DBA Data[Home] [Help]

APPS.OKL_ACTIVATE_ASSET_PVT dependencies on OKL_TRX_TYPES_TL

Line 5043: from okl_trx_types_tl tl

5039: AND rul.rule_information_category = 'LATOWN'
5040: AND khr.id = chr.id
5041: AND chr.id = rbk_chr.orig_system_id1
5042: AND exists (select null
5043: from okl_trx_types_tl tl
5044: where tl.language = 'US'
5045: and tl.name = 'Rebook'
5046: and tl.id = ktrx.try_id)
5047: AND ktrx.KHR_ID = chr.id

Line 6337: from okl_trx_types_tl tl

6333: AND rul.rule_information_category = 'LATOWN'
6334: AND khr.id = chr.id
6335: AND chr.id = p_rbk_chr_id
6336: AND exists (select null
6337: from okl_trx_types_tl tl
6338: where tl.language = 'US'
6339: and tl.name = 'Rebook'
6340: and tl.id = ktrx.try_id)
6341: AND ktrx.KHR_ID = chr.id

Line 7469: FROM OKL_TRX_TYPES_TL ttyp,

7465: 'OKL_TXL_ASSETS_B' sla_source_line_table,
7466: trx.try_id sla_source_try_id,
7467: cle.cle_id sla_source_kle_id
7468: --Bug# 6373605 end
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,

Line 7494: --OKL_TRX_TYPES_TL ttyp

7490: --Bug# 3156924:
7491: /*----------------------------------------------------
7492: --AND exists (select null
7493: --from OKL_TRX_ASSETS trx,
7494: --OKL_TRX_TYPES_TL ttyp
7495: --where trx.id = txl.tas_id
7496: --and trx.try_id = ttyp.id
7497: --and ttyp.name = 'Internal Asset Creation'
7498: --and ttyp.language = 'US'

Line 7548: FROM OKL_TRX_TYPES_TL ttyp,

7544: 'OKL_TXD_ASSETS_B' sla_source_line_table,
7545: trx.try_id sla_source_try_id,
7546: cle.cle_id sla_source_kle_id
7547: --Bug# 6373605 end
7548: FROM OKL_TRX_TYPES_TL ttyp,
7549: OKL_TRX_ASSETS trx,
7550: OKL_TXD_ASSETS_B txd,
7551: OKL_TXL_ASSETS_B txl,
7552: OKC_K_LINES_B cle,

Line 7575: --OKL_TRX_TYPES_TL ttyp

7571: --bug# 3156924
7572: /*-------------------------------------------------------------
7573: --AND exists (select null
7574: --from OKL_TRX_ASSETS trx,
7575: --OKL_TRX_TYPES_TL ttyp
7576: --where trx.id = txl.tas_id
7577: --and trx.try_id = ttyp.id
7578: --and ttyp.name = 'Release'
7579: --and ttyp.language = 'US'

Line 7688: okl_trx_types_tl ttyp,

7684: --Bug# 6373605 start
7685: fa_book_controls fbc,
7686: --Bug# 6373605 end
7687: okc_k_items fa_cim,
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,

Line 9320: from okl_trx_types_tl ttyt,

9316: trx.tas_type,
9317: txl.tal_type,
9318: txl.id tal_id,
9319: trx.creation_date
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

Line 11126: from okl_trx_types_tl ttyt,

11122: trx.tas_type,
11123: txl.tal_type,
11124: txl.id tal_id,
11125: trx.creation_date
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