[Home] [Help]
1617: SELECT txl.asset_number
1618: INTO l_create_line_item_tbl(k).name
1619: FROM okc_k_lines_b cle,
1620: okc_line_styles_b lse,
1621: okl_txl_assets_b txl
1622: WHERE cle.id = txl.kle_id
1623: AND cle.lse_id = lse.id
1624: AND lse.lty_code = 'FIXED_ASSET'
1625: AND cle.cle_id = l_link_asset_tbl(i).fin_asset_id;