XLE_LOCATIONS_V

Details

• Schema: FUSION

• Object owner: XLE

• Object type: VIEW

Columns

Name

LOCATION_ID LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN COUNTRY FORMATTED_ADDRESS EFFECTIVE_START_DATE EFFECTIVE_END_DATE ADDRESS_LINE_1 ADDRESS_LINE_2 ADDRESS_LINE_3 ADDRESS_LINE_4 TOWN_OR_CITY POSTAL_CODE BUILDING FLOOR_NUMBER LONG_POSTAL_CODE LANGUAGE LOCATION_NAME LOCATION_CODE DESCRIPTION OBJECT_VERSION_NUMBER CREATED_BY_MODULE LOCATION_LANGUAGE STATUS_FLAG ORIG_SYSTEM_REFERENCE STYLE REGION_1 REGION_2 REGION_3 ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 ATTRIBUTE16 ATTRIBUTE17 ATTRIBUTE18 ATTRIBUTE19 ATTRIBUTE20

Query

SQL_Statement

SELECT LOCATION_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, COUNTRY, HZ_FORMAT_PUB.format_address(LOCATION_ID) FORMATTED_ADDRESS, TO_DATE('0001/01/01','YYYY/MM/DD') EFFECTIVE_START_DATE, TO_DATE('4712/12/31','YYYY/MM/DD') EFFECTIVE_END_DATE, ADDRESS1 ADDRESS_LINE_1, ADDRESS2 ADDRESS_LINE_2, ADDRESS3 ADDRESS_LINE_3, ADDRESS4 ADDRESS_LINE_4, CITY TOWN_OR_CITY, POSTAL_CODE, BUILDING, FLOOR_NUMBER, POSTAL_PLUS4_CODE LONG_POSTAL_CODE, LOCATION_LANGUAGE LANGUAGE, SHORT_DESCRIPTION LOCATION_NAME, SHORT_DESCRIPTION LOCATION_CODE, DESCRIPTION, OBJECT_VERSION_NUMBER, CREATED_BY_MODULE, LOCATION_LANGUAGE, STATUS_FLAG, ORIG_SYSTEM_REFERENCE, ADDRESS_STYLE STYLE, COUNTY REGION_1, STATE REGION_2, NULL REGION_3, ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15, ATTRIBUTE16, ATTRIBUTE17, ATTRIBUTE18, ATTRIBUTE19, ATTRIBUTE20 FROM HZ_LOCATIONS WHERE INTERNAL_FLAG = 'Y'