MSC_LOCATIONS_MSC_V

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
LOCATION_CODE LOCATION_ID REGION_ID DESCRIPTION ADDRESS1 ADDRESS2 ADDRESS3 ADDRESS4 FLOOR_NUMBER BUILDING CITY STATE PROVINCE COUNTY POSTAL_CODE COUNTRY_CODE ADDRESS_EFFECTIVE_DATE ADDRESS_EXPIRATION_DATE LOCATION_TYPE SR_INSTANCE_ID

Query

SQL_Statement
SELECT LOCATION_CODE, LOCATION_ID, REGION_ID, DESCRIPTION, ADDRESS1, ADDRESS2, ADDRESS3, ADDRESS4, FLOOR_NUMBER, BUILDING, CITY, STATE, PROVINCE, COUNTY, POSTAL_CODE, COUNTRY_CODE, ADDRESS_EFFECTIVE_DATE, ADDRESS_EXPIRATION_DATE, LOCATION_TYPE, SR_INSTANCE_ID FROM MSC_REGION_LOCATIONS Where LOCATION_TYPE ='R'