VIEW: BIM.EDW_BIM_EVNT_EVTOFFERS_LTC#

Source

View Text - Preformatted

select EVTOFFER_PK EVTOFFER_PK, EVTOFFER_PK_KEY EVTOFFER_PK_KEY, EVENT_FK EVENT_FK, EVENT_FK_KEY EVENT_FK_KEY, EVTOFFER_DP EVTOFFER_DP, NAME NAME, LEVEL_NAME LEVEL_NAME, EVTOFFER_ID EVTOFFER_ID, PARENT_EVENT_OFFER_ID PARENT_EVENT_OFFER_ID, EVENT_HEADER_ID EVENT_HEADER_ID, EVENT_LEVEL EVENT_LEVEL, EVENT_TYPE_CODE EVENT_TYPE_CODE, USER_STATUS_ID USER_STATUS_ID, SYSTEM_STATUS_CODE SYSTEM_STATUS_CODE, LAST_STATUS_DATE LAST_STATUS_DATE, TIMEZONE_ID TIMEZONE_ID, REG_WAITLIST_PCT REG_WAITLIST_PCT, REG_OVERBOOK_PCT REG_OVERBOOK_PCT, REG_MINIMUM_CAPACITY REG_MINIMUM_CAPACITY, REG_MAXIMUM_CAPACITY REG_MAXIMUM_CAPACITY, REG_EFFECTIVE_CAPACITY REG_EFFECTIVE_CAPACITY, PRICELIST_LINE_ID PRICELIST_LINE_ID, PRICELIST_HEADER_ID PRICELIST_HEADER_ID, OWNER_USER_ID OWNER_USER_ID, ORG_ID ORG_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, EVENT_LOCATION_ID EVENT_LOCATION_ID, EVENT_DURATION EVENT_DURATION, EVENT_DELIVERY_METHOD_ID EVENT_DELIVERY_METHOD_ID, COORDINATOR_ID COORDINATOR_ID, CERTIFICATION_CREDITS CERTIFICATION_CREDITS, WAITLIST_ACTION_TYPE_CODE WAITLIST_ACTION_TYPE_CODE, STREAM_TYPE_CODE STREAM_TYPE_CODE, SOURCE_CODE SOURCE_CODE, REG_WAITLIST_ALLOWED_FLAG REG_WAITLIST_ALLOWED_FLAG, REG_START_TIME REG_START_TIME, REG_REQUIRED_FLAG REG_REQUIRED_FLAG, REG_OVERBOOK_ALLOWED_FLAG REG_OVERBOOK_ALLOWED_FLAG, REG_INVITED_ONLY_FLAG REG_INVITED_ONLY_FLAG, REG_FROZEN_FLAG REG_FROZEN_FLAG, REG_END_TIME REG_END_TIME, REG_CHARGE_FLAG REG_CHARGE_FLAG, PRIORITY_TYPE_CODE PRIORITY_TYPE_CODE, PARTNER_FLAG PARTNER_FLAG, OVERFLOW_FLAG OVERFLOW_FLAG, EVENT_START_DATE_TIME EVENT_START_DATE_TIME, EVENT_STANDALONE_FLAG EVENT_STANDALONE_FLAG, EVENT_REQUIERED_FLAG EVENT_REQUIERED_FLAG, EVENT_LANGUAGE_CODE EVENT_LANGUAGE_CODE, EVENT_FULL_FLAG EVENT_FULL_FLAG, EVENT_END_DATE_TIME EVENT_END_DATE_TIME, EVENT_DURATION_UOM_CODE EVENT_DURATION_UOM_CODE, CERT_CREDIT_TYPE_CODE CERT_CREDIT_TYPE_CODE, CANCELLATION_REASON_CODE CANCELLATION_REASON_CODE, INBOUND_SCRIPT_NAME INBOUND_SCRIPT_NAME, EMAIL EMAIL, PHONE PHONE, URL URL, AUTO_REGISTER_FLAG AUTO_REGISTER_FLAG, EVENT_VENUE_ID EVENT_VENUE_ID, REG_START_DATE REG_START_DATE, REG_MINIMUM_REQ_BY_DATE REG_MINIMUM_REQ_BY_DATE, REG_END_DATE REG_END_DATE, EVENT_START_DATE EVENT_START_DATE, EVENT_END_DATE EVENT_END_DATE, EVENT_MKTG_MESSAGE EVENT_MKTG_MESSAGE, EVENT_OFFER_NAME EVENT_OFFER_NAME, DESCRIPTION DESCRIPTION, INSTANCE INSTANCE, USER_ATTRIBUTE1 USER_ATTRIBUTE1, USER_ATTRIBUTE2 USER_ATTRIBUTE2, USER_ATTRIBUTE3 USER_ATTRIBUTE3, USER_ATTRIBUTE4 USER_ATTRIBUTE4, USER_ATTRIBUTE5 USER_ATTRIBUTE5, LAST_UPDATE_DATE LAST_UPDATE_DATE, CREATION_DATE CREATION_DATE, SECURITY_GROUP_ID SECURITY_GROUP_ID, EVENT_REQUIRED_FLAG EVENT_REQUIRED_FLAG from "BIM"."EDW_BIM_EVNT_EVTOFFERS_LTC"

View Text - HTML Formatted

SELECT EVTOFFER_PK EVTOFFER_PK
, EVTOFFER_PK_KEY EVTOFFER_PK_KEY
, EVENT_FK EVENT_FK
, EVENT_FK_KEY EVENT_FK_KEY
, EVTOFFER_DP EVTOFFER_DP
, NAME NAME
, LEVEL_NAME LEVEL_NAME
, EVTOFFER_ID EVTOFFER_ID
, PARENT_EVENT_OFFER_ID PARENT_EVENT_OFFER_ID
, EVENT_HEADER_ID EVENT_HEADER_ID
, EVENT_LEVEL EVENT_LEVEL
, EVENT_TYPE_CODE EVENT_TYPE_CODE
, USER_STATUS_ID USER_STATUS_ID
, SYSTEM_STATUS_CODE SYSTEM_STATUS_CODE
, LAST_STATUS_DATE LAST_STATUS_DATE
, TIMEZONE_ID TIMEZONE_ID
, REG_WAITLIST_PCT REG_WAITLIST_PCT
, REG_OVERBOOK_PCT REG_OVERBOOK_PCT
, REG_MINIMUM_CAPACITY REG_MINIMUM_CAPACITY
, REG_MAXIMUM_CAPACITY REG_MAXIMUM_CAPACITY
, REG_EFFECTIVE_CAPACITY REG_EFFECTIVE_CAPACITY
, PRICELIST_LINE_ID PRICELIST_LINE_ID
, PRICELIST_HEADER_ID PRICELIST_HEADER_ID
, OWNER_USER_ID OWNER_USER_ID
, ORG_ID ORG_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, EVENT_LOCATION_ID EVENT_LOCATION_ID
, EVENT_DURATION EVENT_DURATION
, EVENT_DELIVERY_METHOD_ID EVENT_DELIVERY_METHOD_ID
, COORDINATOR_ID COORDINATOR_ID
, CERTIFICATION_CREDITS CERTIFICATION_CREDITS
, WAITLIST_ACTION_TYPE_CODE WAITLIST_ACTION_TYPE_CODE
, STREAM_TYPE_CODE STREAM_TYPE_CODE
, SOURCE_CODE SOURCE_CODE
, REG_WAITLIST_ALLOWED_FLAG REG_WAITLIST_ALLOWED_FLAG
, REG_START_TIME REG_START_TIME
, REG_REQUIRED_FLAG REG_REQUIRED_FLAG
, REG_OVERBOOK_ALLOWED_FLAG REG_OVERBOOK_ALLOWED_FLAG
, REG_INVITED_ONLY_FLAG REG_INVITED_ONLY_FLAG
, REG_FROZEN_FLAG REG_FROZEN_FLAG
, REG_END_TIME REG_END_TIME
, REG_CHARGE_FLAG REG_CHARGE_FLAG
, PRIORITY_TYPE_CODE PRIORITY_TYPE_CODE
, PARTNER_FLAG PARTNER_FLAG
, OVERFLOW_FLAG OVERFLOW_FLAG
, EVENT_START_DATE_TIME EVENT_START_DATE_TIME
, EVENT_STANDALONE_FLAG EVENT_STANDALONE_FLAG
, EVENT_REQUIERED_FLAG EVENT_REQUIERED_FLAG
, EVENT_LANGUAGE_CODE EVENT_LANGUAGE_CODE
, EVENT_FULL_FLAG EVENT_FULL_FLAG
, EVENT_END_DATE_TIME EVENT_END_DATE_TIME
, EVENT_DURATION_UOM_CODE EVENT_DURATION_UOM_CODE
, CERT_CREDIT_TYPE_CODE CERT_CREDIT_TYPE_CODE
, CANCELLATION_REASON_CODE CANCELLATION_REASON_CODE
, INBOUND_SCRIPT_NAME INBOUND_SCRIPT_NAME
, EMAIL EMAIL
, PHONE PHONE
, URL URL
, AUTO_REGISTER_FLAG AUTO_REGISTER_FLAG
, EVENT_VENUE_ID EVENT_VENUE_ID
, REG_START_DATE REG_START_DATE
, REG_MINIMUM_REQ_BY_DATE REG_MINIMUM_REQ_BY_DATE
, REG_END_DATE REG_END_DATE
, EVENT_START_DATE EVENT_START_DATE
, EVENT_END_DATE EVENT_END_DATE
, EVENT_MKTG_MESSAGE EVENT_MKTG_MESSAGE
, EVENT_OFFER_NAME EVENT_OFFER_NAME
, DESCRIPTION DESCRIPTION
, INSTANCE INSTANCE
, USER_ATTRIBUTE1 USER_ATTRIBUTE1
, USER_ATTRIBUTE2 USER_ATTRIBUTE2
, USER_ATTRIBUTE3 USER_ATTRIBUTE3
, USER_ATTRIBUTE4 USER_ATTRIBUTE4
, USER_ATTRIBUTE5 USER_ATTRIBUTE5
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, CREATION_DATE CREATION_DATE
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, EVENT_REQUIRED_FLAG EVENT_REQUIRED_FLAG
FROM "BIM"."EDW_BIM_EVNT_EVTOFFERS_LTC"