1582: decode(asset_kfv_fa.segment9,null,null,'.'||ltrim(rtrim(asset_kfv_fa.segment9,' '),' '))||
1583: decode(asset_kfv_fa.segment10,null,null,'.'||ltrim(rtrim(asset_kfv_fa.segment10,' '),' ')) Asset_Key
1584: FROM
1585: okc_k_lines_b cleb_fa,
1586: fa_distribution_history fa_hist,
1587: fa_additions_b fa_add,
1588: --fa_asset_keywords_kfv asset_kfv_fa, -- 21-jan-2008 sechawla 7830362
1589: fa_asset_keywords asset_kfv_fa, -- 21-jan-2008 sechawla 7830362
1590: fa_locations_kfv loc_kfv_fa,