APPS.OKL_AM_PROCESS_ASSET_TRX_PVT dependencies on FND_LOOKUPS

Line 252: FROM OKL_TRX_ASSETS h, OKL_TXL_ASSETS_B l, OKL_TXD_ASSETS_B d, fa_book_controls fbc, FND_LOOKUPS fl -- SECHAWLA 19-FEB-04 3439647 : Use base tables instead of views

248: --,l.currency_code func_currency_code -- SECHAWLA 29-JUL-05 4456005 : added
249: --,l.DNZ_KHR_ID -- SECHAWLA 29-JUL-05 4456005 : added
250: -- SGORANTL 22-MAR-06 5097643: changes made by kbbhavsa for bug 4717511 has been reversed
251: ,h.try_id --akrangan added for sla populate sources cr
252: FROM OKL_TRX_ASSETS h, OKL_TXL_ASSETS_B l, OKL_TXD_ASSETS_B d, fa_book_controls fbc, FND_LOOKUPS fl -- SECHAWLA 19-FEB-04 3439647 : Use base tables instead of views
253: WHERE h.id = l.tas_id
254: AND l.id = d.tal_id(+)
255: AND FL.LOOKUP_CODE = h.TAS_TYPE AND FL.LOOKUP_TYPE = 'OKL_TRANS_HEADER_TYPE'
256: AND decode(d.tax_book,NULL, l.CORPORATE_BOOK,d.tax_book ) = fbc.book_type_code

Line 280: FROM OKL_TRX_ASSETS h, OKL_TXL_ASSETS_B l, OKL_TXD_ASSETS_B d, fa_book_controls fbc, FND_LOOKUPS fl -- SECHAWLA 19-FEB-04 3439647 : Use base tables instead of views

276: --,l.DNZ_KHR_ID -- SECHAWLA 29-JUL-05 4456005 : added
277: -- SGORANTL 22-MAR-06 5097643: changes made by kbbhavsa for bug 4717511 has been reversed
278: ,h.try_id --akrangan added for sla populate sources cr
279: ,l.id line_id --akrangan added for sla populate sources cr
280: FROM OKL_TRX_ASSETS h, OKL_TXL_ASSETS_B l, OKL_TXD_ASSETS_B d, fa_book_controls fbc, FND_LOOKUPS fl -- SECHAWLA 19-FEB-04 3439647 : Use base tables instead of views
281: WHERE h.id = l.tas_id
282: AND l.id = d.tal_id(+)
283: AND FL.LOOKUP_CODE = h.TAS_TYPE AND FL.LOOKUP_TYPE = 'OKL_TRANS_HEADER_TYPE'
284: AND decode(d.tax_book,NULL, l.CORPORATE_BOOK,d.tax_book ) = fbc.book_type_code