[Home] [Help] [Dependency Information]
Object Name: | BIM_R_EVEN_LIS_MV |
---|---|
Object Type: | TABLE |
Owner: | BIM |
Subobject Name: | |
Status: | VALID |
Event List data
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 0 |
PCT Used: |
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 |
Name | Datatype | Length | Mandatory | 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 |
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;
BIM.BIM_R_EVEN_LIS_MV does not reference any database object
BIM.BIM_R_EVEN_LIS_MV is referenced by following:
|
|
|