DBA Data[Home] [Help]

APPS.OKL_LA_TRADEIN_PVT dependencies on OKC_LINE_STYLES_B

Line 313: okc_line_styles_b lse,

309:
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'

Line 341: okc_line_styles_b lse,

337:
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'

Line 440: okc_line_styles_b lse

436:
437: CURSOR c_sublines IS
438: SELECT cle.id
439: FROM okc_k_lines_b cle,
440: okc_line_styles_b lse
441: WHERE cle.cle_id = p_cle_id
442: AND cle.lse_id = lse.id
443: AND lse.lty_code = 'LINK_FEE_ASSET';
444:

Line 450: okc_line_styles_b lse

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
453: AND cle.lse_id = lse.id
454: AND lse.lty_code = 'FIXED_ASSET'

Line 1525: okc_line_styles_b lse

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
1528: AND cle.lse_id = lse.id
1529: AND lse.lty_code = 'FIXED_ASSET'