APPS.OKL_QA_DATA_INTEGRITY dependencies on OKL_TXL_ASSETS_B

Line 8144: okl_txl_assets_b txl,

8140: SELECT
8141: sgn.value book_type,
8142: COUNT(*) book_count
8143: FROM Okl_txd_assets_v txd,
8144: okl_txl_assets_b txl,
8145: okl_sgn_translations sgn
8146: WHERE txd.tal_id = txl.id
8147: AND txl.kle_id = Kleid
8148: AND sgn.jtot_object1_code = 'FA_BOOK_CONTROLS'

Line 10716: from okl_txl_assets_b txl

10712: txl.asset_number,
10713: txl.original_cost,
10714: txl.salvage_value,
10715: txl.percent_salvage_value
10716: from okl_txl_assets_b txl
10717: where txl.dnz_khr_id = p_chr_id;
10718:
10719: ln_comp_prn_oec NUMBER := 0;
10720: ln_comp_prn_salv NUMBER := 0;

Line 10907: okl_txl_assets_b txl

10903: SELECT txd.cost,
10904: txd.deprn_method_tax,
10905: txd.tax_book
10906: FROM okl_txd_assets_b txd,
10907: okl_txl_assets_b txl
10908: WHERE txd.tal_id = txl.id
10909: AND txl.kle_id = kleid;
10910:
10911: BEGIN

Line 12051: okl_txl_assets_b txl,

12047: FROM okc_k_items cim,
12048: okc_k_lines_V fa,
12049: okc_line_styles_b fa_lse,
12050: OKL_TRX_ASSETS trx,
12051: okl_txl_assets_b txl,
12052: okl_txd_assets_v txd,
12053: okc_statuses_b sts
12054: WHERE cim.cle_id = fa.id
12055: AND cim.dnz_chr_id = p_chr_id

Line 12530: okl_txl_assets_b txl,

12526: txl.asset_number asset_number,
12527: fab.cost original_cost,
12528: txl.depreciation_cost new_cost
12529: from okl_trx_assets trx,
12530: okl_txl_assets_b txl,
12531: okc_k_lines_b cleb,
12532: okc_statuses_b sts,
12533: fa_books fab,
12534: fa_additions fa

Line 13514: okl_txl_assets_b txl,

13510: SELECT txl.id tal_id,
13511: txl.asset_number asset_number,
13512: txl.in_service_date in_service_date
13513: FROM okl_trx_assets trx,
13514: okl_txl_assets_b txl,
13515: okc_k_lines_b cleb_fa,
13516: okc_statuses_b sts,
13517: okc_k_lines_b cleb_fin,
13518: okl_k_lines kle_fin