APPS.OKL_QA_DATA_INTEGRITY dependencies on OKL_TRX_ASSETS

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

4327: inv_master_org_id
4328: FROM okl_txl_itm_insts iti
4329: WHERE iti.kle_id = p_kle_id
4330: AND iti.tal_type = G_TRX_LINE_TYPE_BOOK
4331: AND EXISTS (SELECT '1' FROM okl_trx_assets
4332: WHERE okl_trx_assets.tas_type = G_TRX_LINE_TYPE_BOOK
4333: AND okl_trx_assets.tsu_code = G_TSU_CODE_ENTERED
4334: AND okl_trx_assets.id = iti.tas_id);
4335:

Line 4332: WHERE okl_trx_assets.tas_type = G_TRX_LINE_TYPE_BOOK

4328: FROM okl_txl_itm_insts iti
4329: WHERE iti.kle_id = p_kle_id
4330: AND iti.tal_type = G_TRX_LINE_TYPE_BOOK
4331: AND EXISTS (SELECT '1' FROM okl_trx_assets
4332: WHERE okl_trx_assets.tas_type = G_TRX_LINE_TYPE_BOOK
4333: AND okl_trx_assets.tsu_code = G_TSU_CODE_ENTERED
4334: AND okl_trx_assets.id = iti.tas_id);
4335:
4336:

Line 4333: AND okl_trx_assets.tsu_code = G_TSU_CODE_ENTERED

4329: WHERE iti.kle_id = p_kle_id
4330: AND iti.tal_type = G_TRX_LINE_TYPE_BOOK
4331: AND EXISTS (SELECT '1' FROM okl_trx_assets
4332: WHERE okl_trx_assets.tas_type = G_TRX_LINE_TYPE_BOOK
4333: AND okl_trx_assets.tsu_code = G_TSU_CODE_ENTERED
4334: AND okl_trx_assets.id = iti.tas_id);
4335:
4336:
4337: CURSOR serialized_csr (p_inv_item_id NUMBER, p_inventory_org_id NUMBER) IS

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

4330: AND iti.tal_type = G_TRX_LINE_TYPE_BOOK
4331: AND EXISTS (SELECT '1' FROM okl_trx_assets
4332: WHERE okl_trx_assets.tas_type = G_TRX_LINE_TYPE_BOOK
4333: AND okl_trx_assets.tsu_code = G_TSU_CODE_ENTERED
4334: AND okl_trx_assets.id = iti.tas_id);
4335:
4336:
4337: CURSOR serialized_csr (p_inv_item_id NUMBER, p_inventory_org_id NUMBER) IS
4338: SELECT 'X'

Line 11627: OKL_TRX_ASSETS trx,

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

Line 12106: from okl_trx_assets trx,

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