Skip to content

DBA Data[Home] [Help] [Dependency Information]

VIEW: BIM.EDW_BIM_EVNT_EVTOFFERS_LTC#

Object Details
Object Name: EDW_BIM_EVNT_EVTOFFERS_LTC#
Object Type: VIEW
Owner: BIM
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
EVTOFFER_PK VARCHAR2 (320)
EVTOFFER_PK_KEY NUMBER

EVENT_FK VARCHAR2 (320)
EVENT_FK_KEY NUMBER

EVTOFFER_DP VARCHAR2 (240)
NAME VARCHAR2 (320)
LEVEL_NAME VARCHAR2 (80)
EVTOFFER_ID NUMBER

PARENT_EVENT_OFFER_ID NUMBER

EVENT_HEADER_ID NUMBER

EVENT_LEVEL VARCHAR2 (40)
EVENT_TYPE_CODE VARCHAR2 (40)
USER_STATUS_ID NUMBER

SYSTEM_STATUS_CODE VARCHAR2 (40)
LAST_STATUS_DATE DATE

TIMEZONE_ID NUMBER

REG_WAITLIST_PCT NUMBER

REG_OVERBOOK_PCT NUMBER

REG_MINIMUM_CAPACITY NUMBER

REG_MAXIMUM_CAPACITY NUMBER

REG_EFFECTIVE_CAPACITY NUMBER

PRICELIST_LINE_ID NUMBER

PRICELIST_HEADER_ID NUMBER

OWNER_USER_ID NUMBER

ORG_ID NUMBER

INVENTORY_ITEM_ID NUMBER

EVENT_LOCATION_ID NUMBER

EVENT_DURATION NUMBER

EVENT_DELIVERY_METHOD_ID NUMBER

COORDINATOR_ID NUMBER

CERTIFICATION_CREDITS NUMBER

WAITLIST_ACTION_TYPE_CODE VARCHAR2 (40)
STREAM_TYPE_CODE VARCHAR2 (40)
SOURCE_CODE VARCHAR2 (40)
REG_WAITLIST_ALLOWED_FLAG VARCHAR2 (20)
REG_START_TIME DATE

REG_REQUIRED_FLAG VARCHAR2 (20)
REG_OVERBOOK_ALLOWED_FLAG VARCHAR2 (20)
REG_INVITED_ONLY_FLAG VARCHAR2 (20)
REG_FROZEN_FLAG VARCHAR2 (20)
REG_END_TIME DATE

REG_CHARGE_FLAG VARCHAR2 (20)
PRIORITY_TYPE_CODE VARCHAR2 (40)
PARTNER_FLAG VARCHAR2 (20)
OVERFLOW_FLAG VARCHAR2 (20)
EVENT_START_DATE_TIME DATE

EVENT_STANDALONE_FLAG VARCHAR2 (20)
EVENT_REQUIERED_FLAG VARCHAR2 (20)
EVENT_LANGUAGE_CODE VARCHAR2 (40)
EVENT_FULL_FLAG VARCHAR2 (20)
EVENT_END_DATE_TIME DATE

EVENT_DURATION_UOM_CODE VARCHAR2 (20)
CERT_CREDIT_TYPE_CODE VARCHAR2 (40)
CANCELLATION_REASON_CODE VARCHAR2 (40)
INBOUND_SCRIPT_NAME VARCHAR2 (320)
EMAIL VARCHAR2 (320)
PHONE VARCHAR2 (320)
URL VARCHAR2 (4000)
AUTO_REGISTER_FLAG VARCHAR2 (20)
EVENT_VENUE_ID NUMBER

REG_START_DATE DATE

REG_MINIMUM_REQ_BY_DATE DATE

REG_END_DATE DATE

EVENT_START_DATE DATE

EVENT_END_DATE DATE

EVENT_MKTG_MESSAGE VARCHAR2 (320)
EVENT_OFFER_NAME VARCHAR2 (320)
DESCRIPTION VARCHAR2 (4000)
INSTANCE VARCHAR2 (40)
USER_ATTRIBUTE1 VARCHAR2 (240)
USER_ATTRIBUTE2 VARCHAR2 (240)
USER_ATTRIBUTE3 VARCHAR2 (240)
USER_ATTRIBUTE4 VARCHAR2 (240)
USER_ATTRIBUTE5 VARCHAR2 (240)
LAST_UPDATE_DATE DATE
Yes
CREATION_DATE DATE
Yes
SECURITY_GROUP_ID NUMBER

EVENT_REQUIRED_FLAG VARCHAR2 (20)
Query Text

Cut, paste (and edit) the following text to query this object:


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

Dependencies

[top of page]

BIM.EDW_BIM_EVNT_EVTOFFERS_LTC# references the following:

SchemaBIM
TableEDW_BIM_EVNT_EVTOFFERS_LTC
BIM.EDW_BIM_EVNT_EVTOFFERS_LTC# is referenced by following:

SchemaAPPS
SynonymEDW_BIM_EVNT_EVTOFFERS_LTC