VIEW: IBE.IBE_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, SECURITY_GROUP_ID SECURITY_GROUP_ID, 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, ACCESS_NAME ACCESS_NAME, RESP_ACCESS_FLAG RESP_ACCESS_FLAG, PARTY_ACCESS_CODE PARTY_ACCESS_CODE, URL URL, THEME_ID THEME_ID, 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, PAYMENT_THRESHOLD_ENABLE_FLAG PAYMENT_THRESHOLD_ENABLE_FLAG, DOMAIN_NAME DOMAIN_NAME, ENABLE_TRAFFIC_FILTER ENABLE_TRAFFIC_FILTER, REPORTING_STATUS REPORTING_STATUS, SITE_TYPE SITE_TYPE, ENABLE_COMPARISON ENABLE_COMPARISON, ZD_EDITION_NAME ZD_EDITION_NAME from "IBE"."IBE_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
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, 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
, ACCESS_NAME ACCESS_NAME
, RESP_ACCESS_FLAG RESP_ACCESS_FLAG
, PARTY_ACCESS_CODE PARTY_ACCESS_CODE
, URL URL
, THEME_ID THEME_ID
, 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
, PAYMENT_THRESHOLD_ENABLE_FLAG PAYMENT_THRESHOLD_ENABLE_FLAG
, DOMAIN_NAME DOMAIN_NAME
, ENABLE_TRAFFIC_FILTER ENABLE_TRAFFIC_FILTER
, REPORTING_STATUS REPORTING_STATUS
, SITE_TYPE SITE_TYPE
, ENABLE_COMPARISON ENABLE_COMPARISON
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "IBE"."IBE_MSITES_B"