APPS.OKL_AM_CREATE_QUOTE_PVT dependencies on OKX_ASSETS_V

Line 38: FROM okx_assets_v okx

34: --Updated the sql statement for performance issue #5484903
35: -- by excluding UPPER function to do Index scan
36: CURSOR asset_chk_curs1 (p_asset_number IN VARCHAR2) IS
37: SELECT 'Y' a
38: FROM okx_assets_v okx
39: WHERE UPPER(okx.asset_number) = p_asset_number
40: and
41: ( okx.asset_number like Initcap(substr(p_asset_number,1,2))||'%'
42: or