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.

[Home] [Help]

APPS.OKL_QA_DATA_INTEGRITY dependencies on OKL_TXL_ASSETS_B

Line 7727: okl_txl_assets_b txl,

7723: SELECT
7724: sgn.value book_type,
7725: COUNT(*) book_count
7726: FROM Okl_txd_assets_v txd,
7727: okl_txl_assets_b txl,
7728: okl_sgn_translations sgn
7729: WHERE txd.tal_id = txl.id
7730: AND txl.kle_id = Kleid
7731: AND sgn.jtot_object1_code = 'FA_BOOK_CONTROLS'

Line 10294: from okl_txl_assets_b txl

10290: txl.asset_number,
10291: txl.original_cost,
10292: txl.salvage_value,
10293: txl.percent_salvage_value
10294: from okl_txl_assets_b txl
10295: where txl.dnz_khr_id = p_chr_id;
10296:
10297: ln_comp_prn_oec NUMBER := 0;
10298: ln_comp_prn_salv NUMBER := 0;

Line 10484: okl_txl_assets_b txl

10480: SELECT txd.cost,
10481: txd.deprn_method_tax,
10482: txd.tax_book
10483: FROM okl_txd_assets_b txd,
10484: okl_txl_assets_b txl
10485: WHERE txd.tal_id = txl.id
10486: AND txl.kle_id = kleid;
10487:
10488: BEGIN

Line 11628: okl_txl_assets_b txl,

11624: FROM okc_k_items cim,
11625: okc_k_lines_V fa,
11626: okc_line_styles_b fa_lse,
11627: OKL_TRX_ASSETS trx,
11628: okl_txl_assets_b txl,
11629: okl_txd_assets_v txd,
11630: okc_statuses_b sts
11631: WHERE cim.cle_id = fa.id
11632: AND cim.dnz_chr_id = p_chr_id

Line 12107: okl_txl_assets_b txl,

12103: txl.asset_number asset_number,
12104: fab.cost original_cost,
12105: txl.depreciation_cost new_cost
12106: from okl_trx_assets trx,
12107: okl_txl_assets_b txl,
12108: okc_k_lines_b cleb,
12109: okc_statuses_b sts,
12110: fa_books fab,
12111: fa_additions fa