VIEW: XLE.XLE_ETB_PROFILES#

Source

View Text - Preformatted

select ESTABLISHMENT_ID ESTABLISHMENT_ID, PARTY_ID PARTY_ID, LEGAL_ENTITY_ID LEGAL_ENTITY_ID, GEOGRAPHY_ID GEOGRAPHY_ID, NAME NAME, MAIN_ESTABLISHMENT_FLAG MAIN_ESTABLISHMENT_FLAG, MAIN_EFFECTIVE_FROM MAIN_EFFECTIVE_FROM, MAIN_EFFECTIVE_TO MAIN_EFFECTIVE_TO, EFFECTIVE_FROM EFFECTIVE_FROM, EFFECTIVE_TO EFFECTIVE_TO, ETB_INFORMATION_CONTEXT ETB_INFORMATION_CONTEXT, ETB_INFORMATION1 ETB_INFORMATION1, ETB_INFORMATION2 ETB_INFORMATION2, ETB_INFORMATION3 ETB_INFORMATION3, ETB_INFORMATION4 ETB_INFORMATION4, ETB_INFORMATION5 ETB_INFORMATION5, ETB_INFORMATION6 ETB_INFORMATION6, ETB_INFORMATION7 ETB_INFORMATION7, ETB_INFORMATION8 ETB_INFORMATION8, ETB_INFORMATION9 ETB_INFORMATION9, ETB_INFORMATION10 ETB_INFORMATION10, ETB_INFORMATION11 ETB_INFORMATION11, ETB_INFORMATION12 ETB_INFORMATION12, ETB_INFORMATION13 ETB_INFORMATION13, ETB_INFORMATION14 ETB_INFORMATION14, ETB_INFORMATION15 ETB_INFORMATION15, ETB_INFORMATION16 ETB_INFORMATION16, ETB_INFORMATION17 ETB_INFORMATION17, ETB_INFORMATION18 ETB_INFORMATION18, ETB_INFORMATION19 ETB_INFORMATION19, ETB_INFORMATION20 ETB_INFORMATION20, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LAST_UPDATE_DATE LAST_UPDATE_DATE, CREATED_BY CREATED_BY, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, ATTRIBUTE16 ATTRIBUTE16, ATTRIBUTE17 ATTRIBUTE17, ATTRIBUTE18 ATTRIBUTE18, ATTRIBUTE19 ATTRIBUTE19, ATTRIBUTE20 ATTRIBUTE20, ACTIVITY_CODE ACTIVITY_CODE, SUB_ACTIVITY_CODE SUB_ACTIVITY_CODE, TYPE_OF_COMPANY TYPE_OF_COMPANY from "XLE"."XLE_ETB_PROFILES"

View Text - HTML Formatted

SELECT ESTABLISHMENT_ID ESTABLISHMENT_ID
, PARTY_ID PARTY_ID
, LEGAL_ENTITY_ID LEGAL_ENTITY_ID
, GEOGRAPHY_ID GEOGRAPHY_ID
, NAME NAME
, MAIN_ESTABLISHMENT_FLAG MAIN_ESTABLISHMENT_FLAG
, MAIN_EFFECTIVE_FROM MAIN_EFFECTIVE_FROM
, MAIN_EFFECTIVE_TO MAIN_EFFECTIVE_TO
, EFFECTIVE_FROM EFFECTIVE_FROM
, EFFECTIVE_TO EFFECTIVE_TO
, ETB_INFORMATION_CONTEXT ETB_INFORMATION_CONTEXT
, ETB_INFORMATION1 ETB_INFORMATION1
, ETB_INFORMATION2 ETB_INFORMATION2
, ETB_INFORMATION3 ETB_INFORMATION3
, ETB_INFORMATION4 ETB_INFORMATION4
, ETB_INFORMATION5 ETB_INFORMATION5
, ETB_INFORMATION6 ETB_INFORMATION6
, ETB_INFORMATION7 ETB_INFORMATION7
, ETB_INFORMATION8 ETB_INFORMATION8
, ETB_INFORMATION9 ETB_INFORMATION9
, ETB_INFORMATION10 ETB_INFORMATION10
, ETB_INFORMATION11 ETB_INFORMATION11
, ETB_INFORMATION12 ETB_INFORMATION12
, ETB_INFORMATION13 ETB_INFORMATION13
, ETB_INFORMATION14 ETB_INFORMATION14
, ETB_INFORMATION15 ETB_INFORMATION15
, ETB_INFORMATION16 ETB_INFORMATION16
, ETB_INFORMATION17 ETB_INFORMATION17
, ETB_INFORMATION18 ETB_INFORMATION18
, ETB_INFORMATION19 ETB_INFORMATION19
, ETB_INFORMATION20 ETB_INFORMATION20
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, CREATED_BY CREATED_BY
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, ATTRIBUTE16 ATTRIBUTE16
, ATTRIBUTE17 ATTRIBUTE17
, ATTRIBUTE18 ATTRIBUTE18
, ATTRIBUTE19 ATTRIBUTE19
, ATTRIBUTE20 ATTRIBUTE20
, ACTIVITY_CODE ACTIVITY_CODE
, SUB_ACTIVITY_CODE SUB_ACTIVITY_CODE
, TYPE_OF_COMPANY TYPE_OF_COMPANY
FROM "XLE"."XLE_ETB_PROFILES"