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

TABLE: APPS.BIM_R_EVEN_LIS_MV

Object Details
Object Name: BIM_R_EVEN_LIS_MV
Object Type: TABLE
Owner: APPS
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
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 APPS.BIM_R_EVEN_LIS_MV;

Dependencies

[top of page]

APPS.BIM_R_EVEN_LIS_MV does not reference any database object

APPS.BIM_R_EVEN_LIS_MV is not referenced by any database object