DBA Data[Home] [Help]

APPS.OKL_LA_TRADEIN_PVT dependencies on OKL_TXL_ASSETS_B

Line 314: okl_txl_assets_b txl

310: SELECT txl.asset_number
311: INTO l_create_line_item_tbl(k).name
312: FROM okc_k_lines_b cle,
313: okc_line_styles_b lse,
314: okl_txl_assets_b txl
315: WHERE cle.id = txl.kle_id
316: AND cle.lse_id = lse.id
317: AND lse.lty_code = 'FIXED_ASSET'
318: AND cle.cle_id = l_link_asset_tbl(i).fin_asset_id;

Line 342: okl_txl_assets_b txl

338: SELECT txl.asset_number
339: INTO l_update_line_item_tbl(m).name
340: FROM okc_k_lines_b cle,
341: okc_line_styles_b lse,
342: okl_txl_assets_b txl
343: WHERE cle.id = txl.kle_id
344: AND cle.lse_id = lse.id
345: AND lse.lty_code = 'FIXED_ASSET'
346: AND cle.cle_id = l_link_asset_tbl(i).fin_asset_id;

Line 448: FROM okl_txl_assets_b txl,

444:
445: CURSOR c_assets IS
446: SELECT cle.cle_id fin_asset_id,
447: txl.asset_number
448: FROM okl_txl_assets_b txl,
449: okc_k_lines_b cle,
450: okc_line_styles_b lse
451: WHERE cle.dnz_chr_id = p_chr_id
452: AND cle.id = txl.kle_id

Line 1523: FROM okl_txl_assets_b txl,

1519:
1520: CURSOR c_assets IS
1521: SELECT cle.cle_id fin_asset_id,
1522: txl.asset_number
1523: FROM okl_txl_assets_b txl,
1524: okc_k_lines_b cle,
1525: okc_line_styles_b lse
1526: WHERE cle.dnz_chr_id = p_chr_id
1527: AND cle.id = txl.kle_id