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

VIEW: APPS.BIM_SUMV_EVENT_PERF

Object Details
Object Name: BIM_SUMV_EVENT_PERF
Object Type: VIEW
Owner: APPS
FND Design Data: ViewBIM.BIM_SUMV_EVENT_PERF
Subobject Name:
Status: VALID

View Type

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.
.


[View Source]

Columns
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
Query Text

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;

Dependencies

[top of page]

APPS.BIM_SUMV_EVENT_PERF references the following:

SchemaAPPS
ViewBIM_DIMV_EVENT_HIER
ViewBIM_DIMV_MARKET_SGMTS
ViewBIM_DIMV_PROD_LOV
ViewBIM_DIMV_SALES_CHANNELS
SynonymBIM_EVENT_PERF_SUMM
PL/SQL PackageFND_GLOBAL - show dependent code

APPS.BIM_SUMV_EVENT_PERF is not referenced by any database object