VIEW: JTF.JTF_MSITES_B#

Source

View Text - Preformatted

select MSITE_ID MSITE_ID, OBJECT_VERSION_NUMBER OBJECT_VERSION_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, STORE_ID STORE_ID, START_DATE_ACTIVE START_DATE_ACTIVE, END_DATE_ACTIVE END_DATE_ACTIVE, DEFAULT_LANGUAGE_CODE DEFAULT_LANGUAGE_CODE, DEFAULT_CURRENCY_CODE DEFAULT_CURRENCY_CODE, DEFAULT_DATE_FORMAT DEFAULT_DATE_FORMAT, DEFAULT_ORG_ID DEFAULT_ORG_ID, ATP_CHECK_FLAG ATP_CHECK_FLAG, WALKIN_ALLOWED_FLAG WALKIN_ALLOWED_FLAG, MSITE_ROOT_SECTION_ID MSITE_ROOT_SECTION_ID, PROFILE_ID PROFILE_ID, MASTER_MSITE_FLAG MASTER_MSITE_FLAG, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, SECURITY_GROUP_ID SECURITY_GROUP_ID, ACCESS_NAME ACCESS_NAME, RESP_ACCESS_FLAG RESP_ACCESS_FLAG, PARTY_ACCESS_CODE PARTY_ACCESS_CODE, URL URL, THEME_ID THEME_ID from "JTF"."JTF_MSITES_B"

View Text - HTML Formatted

SELECT MSITE_ID MSITE_ID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_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
, STORE_ID STORE_ID
, START_DATE_ACTIVE START_DATE_ACTIVE
, END_DATE_ACTIVE END_DATE_ACTIVE
, DEFAULT_LANGUAGE_CODE DEFAULT_LANGUAGE_CODE
, DEFAULT_CURRENCY_CODE DEFAULT_CURRENCY_CODE
, DEFAULT_DATE_FORMAT DEFAULT_DATE_FORMAT
, DEFAULT_ORG_ID DEFAULT_ORG_ID
, ATP_CHECK_FLAG ATP_CHECK_FLAG
, WALKIN_ALLOWED_FLAG WALKIN_ALLOWED_FLAG
, MSITE_ROOT_SECTION_ID MSITE_ROOT_SECTION_ID
, PROFILE_ID PROFILE_ID
, MASTER_MSITE_FLAG MASTER_MSITE_FLAG
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, ACCESS_NAME ACCESS_NAME
, RESP_ACCESS_FLAG RESP_ACCESS_FLAG
, PARTY_ACCESS_CODE PARTY_ACCESS_CODE
, URL URL
, THEME_ID THEME_ID
FROM "JTF"."JTF_MSITES_B"