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

VIEW: APPS.BIM_SUMV_EVENT_REV

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

View Type

A public view which may be useful for custom reporting or other data
requirements.


BIM_SUMV_EVENT_REV is a view that joins the summary table to the dimension views. It is used by the following reports: Event Costs, Event Revenue, Event Offering Costs, Event Offering Revenue.
.


[View Source]

Columns
Name Datatype Length Mandatory Comments
EVENT_ID VARCHAR2 (80) Yes event 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
PERIOD_NAME VARCHAR2 (25) Yes period name
START_DATE DATE
Yes start date
END_DATE DATE
Yes end date
REGISTRATION_REVENUE NUMBER

registration revenue
INITIATED_REVENUE NUMBER

initiated revenue
FORECASTED_REVENUE NUMBER

forecasted revenue
FORECASTED_COST NUMBER

forecasted cost
NUM_OF_LEADS NUMBER

number of leads
ACTUAL_COST NUMBER

actual cost
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
,      PERIOD_NAME
,      START_DATE
,      END_DATE
,      REGISTRATION_REVENUE
,      INITIATED_REVENUE
,      FORECASTED_REVENUE
,      FORECASTED_COST
,      NUM_OF_LEADS
,      ACTUAL_COST
FROM APPS.BIM_SUMV_EVENT_REV;

Dependencies

[top of page]

APPS.BIM_SUMV_EVENT_REV references the following:

SchemaAPPS
ViewBIM_DIMV_EVENT_HIER
SynonymBIM_EVENT_REVCOST_SUMM
PL/SQL PackageFND_GLOBAL - show dependent code

APPS.BIM_SUMV_EVENT_REV is not referenced by any database object