[Home] [Help] [Dependency Information]
Object Name: | BIM_SUMV_EVENT_PERF |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | BIM.BIM_SUMV_EVENT_PERF |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
BIM_SUMV_EVENT_PERF is a view that joins the summary table to the dimension views. It is used by the following reports: Event Offering Performance, Event Performance Over Period.
.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EVENT_ID | VARCHAR2 | (80) | Yes | evnet id |
EVENT_OFFERING_ID | VARCHAR2 | (80) | Yes | event offering id |
EVENT_NAME | VARCHAR2 | (240) | event name | |
EVENT_OFFERING_NAME | VARCHAR2 | (240) | event offering name | |
EVENT_TYPE | VARCHAR2 | (30) | event type | |
CAMPAIGN_ID | NUMBER | Yes | campaign id | |
PERIOD_NAME | VARCHAR2 | (25) | Yes | period name |
START_DATE | DATE | Yes | start date | |
END_DATE | DATE | Yes | end date | |
MARKET_SEGMENT_ID | NUMBER | Yes | market segment id | |
MARKET_SEGMENT_NAME | VARCHAR2 | (120) | market segment name | |
SALES_CHANNEL_CODE | VARCHAR2 | (30) | Yes | sales channel code |
SALES_CHANNEL_NAME | VARCHAR2 | (80) | sales channel name | |
INTEREST_TYPE_ID | NUMBER | Yes | interest type id | |
INTEREST_TYPE | VARCHAR2 | (80) | interest type | |
PRIMARY_INTEREST_CODE_ID | NUMBER | Yes | primary interest code id | |
PRIMARY_INTEREST_CODE | VARCHAR2 | (100) | primary interest code | |
SECONDARY_INTEREST_CODE_ID | NUMBER | Yes | secondary interest code id | |
SECONDARY_INTEREST_CODE | VARCHAR2 | (100) | seconduary interest code | |
GEOGRAPHY_CODE | VARCHAR2 | (240) | Yes | geography code |
LEAD_ID | NUMBER | lead id | ||
INITIATED_REVENUE | NUMBER | initiated revenue |
Cut, paste (and edit) the following text to query this object:
SELECT EVENT_ID
, EVENT_OFFERING_ID
, EVENT_NAME
, EVENT_OFFERING_NAME
, EVENT_TYPE
, CAMPAIGN_ID
, PERIOD_NAME
, START_DATE
, END_DATE
, MARKET_SEGMENT_ID
, MARKET_SEGMENT_NAME
, SALES_CHANNEL_CODE
, SALES_CHANNEL_NAME
, INTEREST_TYPE_ID
, INTEREST_TYPE
, PRIMARY_INTEREST_CODE_ID
, PRIMARY_INTEREST_CODE
, SECONDARY_INTEREST_CODE_ID
, SECONDARY_INTEREST_CODE
, GEOGRAPHY_CODE
, LEAD_ID
, INITIATED_REVENUE
FROM APPS.BIM_SUMV_EVENT_PERF;
APPS.BIM_SUMV_EVENT_PERF is not referenced by any database object
|
|
|