VIEW: MSC.MSC_REGIONS#

Source

View Text - Preformatted

select REGION_ID REGION_ID, REGION_TYPE REGION_TYPE, PARENT_REGION_ID PARENT_REGION_ID, COUNTRY_CODE COUNTRY_CODE, COUNTRY_REGION_CODE COUNTRY_REGION_CODE, STATE_CODE STATE_CODE, CITY_CODE CITY_CODE, PORT_FLAG PORT_FLAG, AIRPORT_FLAG AIRPORT_FLAG, ROAD_TERMINAL_FLAG ROAD_TERMINAL_FLAG, RAIL_TERMINAL_FLAG RAIL_TERMINAL_FLAG, LONGITUDE LONGITUDE, TIMEZONE TIMEZONE, SR_INSTANCE_ID SR_INSTANCE_ID, REFRESH_NUMBER REFRESH_NUMBER, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, LATITUDE LATITUDE, CONTINENT CONTINENT, COUNTRY COUNTRY, COUNTRY_REGION COUNTRY_REGION, STATE STATE, CITY CITY, ZONE ZONE, ZONE_LEVEL ZONE_LEVEL, POSTAL_CODE_FROM POSTAL_CODE_FROM, POSTAL_CODE_TO POSTAL_CODE_TO, ALTERNATE_NAME ALTERNATE_NAME, COUNTY COUNTY, ZONE_USAGE ZONE_USAGE, SR_INSTANCE_CODE SR_INSTANCE_CODE, DELETED_FLAG DELETED_FLAG, PROCESS_FLAG PROCESS_FLAG, DATA_SOURCE_TYPE DATA_SOURCE_TYPE, ST_TRANSACTION_ID ST_TRANSACTION_ID, ERROR_TEXT ERROR_TEXT, BATCH_ID BATCH_ID, MESSAGE_ID MESSAGE_ID, COMPANY_NAME COMPANY_NAME from "MSC"."MSC_REGIONS"

View Text - HTML Formatted

SELECT REGION_ID REGION_ID
, REGION_TYPE REGION_TYPE
, PARENT_REGION_ID PARENT_REGION_ID
, COUNTRY_CODE COUNTRY_CODE
, COUNTRY_REGION_CODE COUNTRY_REGION_CODE
, STATE_CODE STATE_CODE
, CITY_CODE CITY_CODE
, PORT_FLAG PORT_FLAG
, AIRPORT_FLAG AIRPORT_FLAG
, ROAD_TERMINAL_FLAG ROAD_TERMINAL_FLAG
, RAIL_TERMINAL_FLAG RAIL_TERMINAL_FLAG
, LONGITUDE LONGITUDE
, TIMEZONE TIMEZONE
, SR_INSTANCE_ID SR_INSTANCE_ID
, REFRESH_NUMBER REFRESH_NUMBER
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, LATITUDE LATITUDE
, CONTINENT CONTINENT
, COUNTRY COUNTRY
, COUNTRY_REGION COUNTRY_REGION
, STATE STATE
, CITY CITY
, ZONE ZONE
, ZONE_LEVEL ZONE_LEVEL
, POSTAL_CODE_FROM POSTAL_CODE_FROM
, POSTAL_CODE_TO POSTAL_CODE_TO
, ALTERNATE_NAME ALTERNATE_NAME
, COUNTY COUNTY
, ZONE_USAGE ZONE_USAGE
, SR_INSTANCE_CODE SR_INSTANCE_CODE
, DELETED_FLAG DELETED_FLAG
, PROCESS_FLAG PROCESS_FLAG
, DATA_SOURCE_TYPE DATA_SOURCE_TYPE
, ST_TRANSACTION_ID ST_TRANSACTION_ID
, ERROR_TEXT ERROR_TEXT
, BATCH_ID BATCH_ID
, MESSAGE_ID MESSAGE_ID
, COMPANY_NAME COMPANY_NAME
FROM "MSC"."MSC_REGIONS"