APPS.OKL_K_LINE_FIN_EXT_PVT dependencies on FA_ASSET_KEYWORDS

Line 1588: --fa_asset_keywords_kfv asset_kfv_fa, -- 21-jan-2008 sechawla 7830362

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,
1591: okc_k_items item
1592: WHERE ITEM.cle_id = cleb_fa.id

Line 1589: fa_asset_keywords asset_kfv_fa, -- 21-jan-2008 sechawla 7830362

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,
1591: okc_k_items item
1592: WHERE ITEM.cle_id = cleb_fa.id
1593: AND fa_add.asset_id = to_number(item.object1_id1)

Line 3703: --fa_asset_keywords_kfv asset_kfv_fa, -- 21-jan-2008 sechawla 7830362

3699: decode(asset_kfv_fa.segment10,null,null,'.'||ltrim(rtrim(asset_kfv_fa.segment10,' '),' ')) Asset_Key
3700: FROM okl_txl_assets_b txl,
3701: okc_k_lines_b cleb_fa,
3702: okc_k_items cim_fa,
3703: --fa_asset_keywords_kfv asset_kfv_fa, -- 21-jan-2008 sechawla 7830362
3704: fa_asset_keywords asset_kfv_fa, -- 21-jan-2008 sechawla 7830362
3705: fa_locations_kfv loc_kfv_fa
3706: WHERE cleb_fa.lse_id = 42
3707: AND cleb_fa.id = txl.kle_id

Line 3704: fa_asset_keywords asset_kfv_fa, -- 21-jan-2008 sechawla 7830362

3700: FROM okl_txl_assets_b txl,
3701: okc_k_lines_b cleb_fa,
3702: okc_k_items cim_fa,
3703: --fa_asset_keywords_kfv asset_kfv_fa, -- 21-jan-2008 sechawla 7830362
3704: fa_asset_keywords asset_kfv_fa, -- 21-jan-2008 sechawla 7830362
3705: fa_locations_kfv loc_kfv_fa
3706: WHERE cleb_fa.lse_id = 42
3707: AND cleb_fa.id = txl.kle_id
3708: AND txl.fa_location_id = loc_kfv_fa.location_id(+)