eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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
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:

BIM: EDW_BIM_EVNT_EVTOFFERS_LTC

BIM.EDW_BIM_EVNT_EVTOFFERS_LTC# is referenced by following:

APPS: EDW_BIM_EVNT_EVTOFFERS_LTC