APPS.OKL_QA_DATA_INTEGRITY dependencies on OKL_TRX_ASSETS

Line 4718: AND EXISTS (SELECT '1' FROM okl_trx_assets

4714: inv_master_org_id
4715: FROM okl_txl_itm_insts iti
4716: WHERE iti.kle_id = p_kle_id
4717: AND iti.tal_type = G_TRX_LINE_TYPE_BOOK
4718: AND EXISTS (SELECT '1' FROM okl_trx_assets
4719: WHERE okl_trx_assets.tas_type = G_TRX_LINE_TYPE_BOOK
4720: AND okl_trx_assets.tsu_code = G_TSU_CODE_ENTERED
4721: AND okl_trx_assets.id = iti.tas_id);
4722:

Line 4719: WHERE okl_trx_assets.tas_type = G_TRX_LINE_TYPE_BOOK

4715: FROM okl_txl_itm_insts iti
4716: WHERE iti.kle_id = p_kle_id
4717: AND iti.tal_type = G_TRX_LINE_TYPE_BOOK
4718: AND EXISTS (SELECT '1' FROM okl_trx_assets
4719: WHERE okl_trx_assets.tas_type = G_TRX_LINE_TYPE_BOOK
4720: AND okl_trx_assets.tsu_code = G_TSU_CODE_ENTERED
4721: AND okl_trx_assets.id = iti.tas_id);
4722:
4723:

Line 4720: AND okl_trx_assets.tsu_code = G_TSU_CODE_ENTERED

4716: WHERE iti.kle_id = p_kle_id
4717: AND iti.tal_type = G_TRX_LINE_TYPE_BOOK
4718: AND EXISTS (SELECT '1' FROM okl_trx_assets
4719: WHERE okl_trx_assets.tas_type = G_TRX_LINE_TYPE_BOOK
4720: AND okl_trx_assets.tsu_code = G_TSU_CODE_ENTERED
4721: AND okl_trx_assets.id = iti.tas_id);
4722:
4723:
4724: CURSOR serialized_csr (p_inv_item_id NUMBER, p_inventory_org_id NUMBER) IS

Line 4721: AND okl_trx_assets.id = iti.tas_id);

4717: AND iti.tal_type = G_TRX_LINE_TYPE_BOOK
4718: AND EXISTS (SELECT '1' FROM okl_trx_assets
4719: WHERE okl_trx_assets.tas_type = G_TRX_LINE_TYPE_BOOK
4720: AND okl_trx_assets.tsu_code = G_TSU_CODE_ENTERED
4721: AND okl_trx_assets.id = iti.tas_id);
4722:
4723:
4724: CURSOR serialized_csr (p_inv_item_id NUMBER, p_inventory_org_id NUMBER) IS
4725: SELECT 'X'

Line 12050: OKL_TRX_ASSETS trx,

12046: txd.tax_book
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

Line 12529: from okl_trx_assets trx,

12525: select txl.id tal_id ,
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,

Line 13513: FROM okl_trx_assets trx,

13509: CURSOR l_corp_book_csr(p_chr_id in number) is
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,