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

VIEW: BIM.BIM_R_EVEN_LIS_MV#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
EVENT_HEADER_ID NUMBER

EVENT_NAME VARCHAR2 (240)
EVENT_OFFER_ID NUMBER

SOURCE_CODE VARCHAR2 (30)
START_DATE DATE

END_DATE DATE

EVENT_HEADER_AREA1 VARCHAR2 (30)
EVENT_HEADER_AREA2 VARCHAR2 (30)
EVENT_COUNTRY VARCHAR2 (30)
EVENT_TYPE VARCHAR2 (30)
EVENT_OFFER_TYPE VARCHAR2 (30)
BUSINESS_UNIT_ID NUMBER

STATUS VARCHAR2 (30)
EVENT_VENUE_ID NUMBER

MONTH VARCHAR2 (30)
QTR VARCHAR2 (30)
YEAR VARCHAR2 (30)
REGISTRATIONS NUMBER

CANCELLATIONS NUMBER

LEADS_OPEN NUMBER

LEADS_OPEN_AMT NUMBER

LEADS_CLOSED NUMBER

LEADS_CLOSED_AMT NUMBER

OPPORTUNITIES NUMBER

OPPORTUNITY_AMT NUMBER

ATTENDANCE NUMBER

FORECASTED_COST NUMBER

FORECASTED_REVENUE NUMBER

ACTUAL_COST NUMBER

REVENUE NUMBER

ORDER_AMT NUMBER

BUDGET_REQUESTED NUMBER

BUDGET_APPROVED NUMBER

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# references the following:

SchemaBIM
TableBIM_R_EVEN_LIS_MV
BIM.BIM_R_EVEN_LIS_MV# is referenced by following:

SchemaAPPS
SynonymBIM_R_EVEN_LIS_MV