[Home] [Help] [Dependency Information]
Object Name: | EDW_BIM_EVNT_EVTOFFERS_LTC# |
---|---|
Object Type: | VIEW |
Owner: | BIM |
Subobject Name: | |
Status: | VALID |
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) | ||
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) |
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#;
|
|
|