VIEW: XLE.XLE_ENTITY_PROFILES#

Source

View Text - Preformatted

select LEGAL_ENTITY_ID LEGAL_ENTITY_ID, PARTY_ID PARTY_ID, LEGAL_ENTITY_IDENTIFIER LEGAL_ENTITY_IDENTIFIER, NAME NAME, GEOGRAPHY_ID GEOGRAPHY_ID, TRANSACTING_ENTITY_FLAG TRANSACTING_ENTITY_FLAG, EFFECTIVE_FROM EFFECTIVE_FROM, EFFECTIVE_TO EFFECTIVE_TO, LE_INFORMATION_CONTEXT LE_INFORMATION_CONTEXT, LE_INFORMATION1 LE_INFORMATION1, LE_INFORMATION2 LE_INFORMATION2, LE_INFORMATION3 LE_INFORMATION3, LE_INFORMATION4 LE_INFORMATION4, LE_INFORMATION5 LE_INFORMATION5, LE_INFORMATION6 LE_INFORMATION6, LE_INFORMATION7 LE_INFORMATION7, LE_INFORMATION8 LE_INFORMATION8, LE_INFORMATION9 LE_INFORMATION9, LE_INFORMATION10 LE_INFORMATION10, LE_INFORMATION11 LE_INFORMATION11, LE_INFORMATION12 LE_INFORMATION12, LE_INFORMATION13 LE_INFORMATION13, LE_INFORMATION14 LE_INFORMATION14, LE_INFORMATION15 LE_INFORMATION15, LE_INFORMATION16 LE_INFORMATION16, LE_INFORMATION17 LE_INFORMATION17, LE_INFORMATION18 LE_INFORMATION18, LE_INFORMATION19 LE_INFORMATION19, LE_INFORMATION20 LE_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_ENTITY_PROFILES"

View Text - HTML Formatted

SELECT LEGAL_ENTITY_ID LEGAL_ENTITY_ID
, PARTY_ID PARTY_ID
, LEGAL_ENTITY_IDENTIFIER LEGAL_ENTITY_IDENTIFIER
, NAME NAME
, GEOGRAPHY_ID GEOGRAPHY_ID
, TRANSACTING_ENTITY_FLAG TRANSACTING_ENTITY_FLAG
, EFFECTIVE_FROM EFFECTIVE_FROM
, EFFECTIVE_TO EFFECTIVE_TO
, LE_INFORMATION_CONTEXT LE_INFORMATION_CONTEXT
, LE_INFORMATION1 LE_INFORMATION1
, LE_INFORMATION2 LE_INFORMATION2
, LE_INFORMATION3 LE_INFORMATION3
, LE_INFORMATION4 LE_INFORMATION4
, LE_INFORMATION5 LE_INFORMATION5
, LE_INFORMATION6 LE_INFORMATION6
, LE_INFORMATION7 LE_INFORMATION7
, LE_INFORMATION8 LE_INFORMATION8
, LE_INFORMATION9 LE_INFORMATION9
, LE_INFORMATION10 LE_INFORMATION10
, LE_INFORMATION11 LE_INFORMATION11
, LE_INFORMATION12 LE_INFORMATION12
, LE_INFORMATION13 LE_INFORMATION13
, LE_INFORMATION14 LE_INFORMATION14
, LE_INFORMATION15 LE_INFORMATION15
, LE_INFORMATION16 LE_INFORMATION16
, LE_INFORMATION17 LE_INFORMATION17
, LE_INFORMATION18 LE_INFORMATION18
, LE_INFORMATION19 LE_INFORMATION19
, LE_INFORMATION20 LE_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_ENTITY_PROFILES"