SELECT VIEW_APPLICATION_ID AS APPLICATION_ID , LOOKUP_TYPE , LOOKUP_CODE , MEANING , DESCRIPTION , ENABLED_FLAG , START_DATE_ACTIVE , END_DATE_ACTIVE FROM FND_LOOKUP_VALUES LV WHERE LANGUAGE = USERENV('LANG') AND LV.LOOKUP_TYPE LIKE 'BSC%' AND SECURITY_GROUP_ID = 0