SELECT LOOKUP_TYPE , LOOKUP_CODE , MEANING , DESCRIPTION , ENABLED_FLAG , START_DATE_ACTIVE , END_DATE_ACTIVE FROM FND_LOOKUP_VALUES LV WHERE LANGUAGE = USERENV('LANG') AND VIEW_APPLICATION_ID = 3 AND LOOKUP_TYPE = 'SHIP_METHOD' AND SECURITY_GROUP_ID = 0