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_SUMMARY_MV

Object Details

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

Event Summary Data

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	0
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
BIM_R_EVEN_SUMMARY_MV_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RESOURCE_ID EVENT_HEADER_ID
BIM_R_EVEN_SUMMARY_MV_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RESOURCE_ID QTR MONTH YEAR
BIM_R_EVEN_SUMMARY_MV_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RESOURCE_ID LEADS_OPEN
BIM_R_EVEN_SUMMARY_MV_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RESOURCE_ID ATTENDANCE

Columns

Name	Datatype	Length	Comments
EVENT_HEADER_ID	NUMBER		Event Header Identifier
EVENT_NAME	VARCHAR2	(240)	Event Name
EVENT_HEADER_AREA2	VARCHAR2	(30)	Event Header Area
EVENT_COUNTRY	VARCHAR2	(30)	Event Country
EVENT_TYPE	VARCHAR2	(30)	Type of the event
BUSINESS_UNIT_ID	NUMBER		Business Unit identifier
ONE_OFF_FLAG	VARCHAR2	(1)	One off flag
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		Number 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
RESOURCE_ID	NUMBER		Resource Identifier

Query Text

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


SELECT EVENT_HEADER_ID
,      EVENT_NAME
,      EVENT_HEADER_AREA2
,      EVENT_COUNTRY
,      EVENT_TYPE
,      BUSINESS_UNIT_ID
,      ONE_OFF_FLAG
,      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
,      RESOURCE_ID
FROM BIM.BIM_R_EVEN_SUMMARY_MV;

Dependencies

[top of page]

BIM.BIM_R_EVEN_SUMMARY_MV does not reference any database object

BIM.BIM_R_EVEN_SUMMARY_MV is referenced by following:

BIM: BIM_R_EVEN_SUMMARY_MV#