userenv('LANG') in where clause
Would the use of userenv('LANG') in where clause cause the whole sql to not use indexes? The exact sql is at the end of this and I am seeing full table scan for one of the tables. By the way, this was after running SQL Tuning profile in Grid.
Regards,
SELECT items.cross_reference ITEM , to_number(null) ITEM_ID , nvl(items.description, T.description) ITEM_DESCRIPTION , B.inventory_item_id INVENTORY_ITEM_ID , items.cross_reference_type ITEM_IDENTIFIER_TYPE ,NULL item_identifier_type_meaning ,B.concatenated_segments INVENTORY_ITEM , NULL ADDRESS , NULL CUST_ADDRESS , NULL ITEM_DEFINITION_LEVEL FROM mtl_cross_reference_types types , mtl_cross_references items , MTL_SYSTEM_ITEMS_TL T , MTL_SYSTEM_ITEMS_B_KFV B WHERE (types.disable_date is null or types.disable_date>sysdate) and types.cross_reference_type = items.cross_reference_type AND items.inventory_item_id = B.inventory_item_id AND B.organization_id = :15 AND B.INVENTORY_ITEM_ID = T.INVENTORY_ITEM_ID AND B.ORGANIZATION_ID = T.ORGANIZATION_ID AND T.LANGUAGE = userenv('LANG') and B.customer_order_enabled_flag='Y'