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]

TABLE: BIM.BIM_R_EVEN_LIS_MV

Object Details

Object Name:	BIM_R_EVEN_LIS_MV
Object Type:	TABLE
Owner:	BIM
Subobject Name:
Status:	VALID

Event List data

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	0
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
BIM_R_EVEN_LIS_MV_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	EVENT_HEADER_ID EVENT_OFFER_ID
BIM_R_EVEN_LIS_MV_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	QTR MONTH YEAR
BIM_R_EVEN_LIS_MV_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LEADS_OPEN
BIM_R_EVEN_LIS_MV_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ATTENDANCE

Columns

Name	Datatype	Length	Comments
EVENT_HEADER_ID	NUMBER		Event Header Identifier
EVENT_NAME	VARCHAR2	(240)	Event Name
EVENT_OFFER_ID	NUMBER		Event Offer Identifier
SOURCE_CODE	VARCHAR2	(30)	Source code
START_DATE	DATE		Start date
END_DATE	DATE		End date
EVENT_HEADER_AREA1	VARCHAR2	(30)	Event Header Area1
EVENT_HEADER_AREA2	VARCHAR2	(30)	Event Header Area2
EVENT_COUNTRY	VARCHAR2	(30)	Event Country
EVENT_TYPE	VARCHAR2	(30)	Type of the event
EVENT_OFFER_TYPE	VARCHAR2	(30)	Event offer type
BUSINESS_UNIT_ID	NUMBER		Business Unit Identifier
STATUS	VARCHAR2	(30)	Status
EVENT_VENUE_ID	NUMBER		Event venue identifier
MONTH	VARCHAR2	(30)	Month
QTR	VARCHAR2	(30)	Quarter
YEAR	VARCHAR2	(30)	Year
REGISTRATIONS	NUMBER		Number of registrations
CANCELLATIONS	NUMBER		Number of cancellations
LEADS_OPEN	NUMBER		Number of open leads
LEADS_OPEN_AMT	NUMBER		Amount of open leads
LEADS_CLOSED	NUMBER		Count of closed leads
LEADS_CLOSED_AMT	NUMBER		Amount of closed leads
OPPORTUNITIES	NUMBER		Opportunities
OPPORTUNITY_AMT	NUMBER		Opportunity Amount
ATTENDANCE	NUMBER		Attendance
FORECASTED_COST	NUMBER		Forecasted cost
FORECASTED_REVENUE	NUMBER		Forecasted revenue
ACTUAL_COST	NUMBER		Actual cost
REVENUE	NUMBER		revenue
ORDER_AMT	NUMBER		Order Amount
BUDGET_REQUESTED	NUMBER		Requested budget amount
BUDGET_APPROVED	NUMBER		Approved budget amount

Query Text

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


SELECT EVENT_HEADER_ID
,      EVENT_NAME
,      EVENT_OFFER_ID
,      SOURCE_CODE
,      START_DATE
,      END_DATE
,      EVENT_HEADER_AREA1
,      EVENT_HEADER_AREA2
,      EVENT_COUNTRY
,      EVENT_TYPE
,      EVENT_OFFER_TYPE
,      BUSINESS_UNIT_ID
,      STATUS
,      EVENT_VENUE_ID
,      MONTH
,      QTR
,      YEAR
,      REGISTRATIONS
,      CANCELLATIONS
,      LEADS_OPEN
,      LEADS_OPEN_AMT
,      LEADS_CLOSED
,      LEADS_CLOSED_AMT
,      OPPORTUNITIES
,      OPPORTUNITY_AMT
,      ATTENDANCE
,      FORECASTED_COST
,      FORECASTED_REVENUE
,      ACTUAL_COST
,      REVENUE
,      ORDER_AMT
,      BUDGET_REQUESTED
,      BUDGET_APPROVED
FROM BIM.BIM_R_EVEN_LIS_MV;

Dependencies

[top of page]

BIM.BIM_R_EVEN_LIS_MV does not reference any database object

BIM.BIM_R_EVEN_LIS_MV is referenced by following:

BIM: BIM_R_EVEN_LIS_MV#