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

VIEW: APPS.BIM_SUMV_EVENT_RSLTS

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

View Type

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


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


[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
NUM_AVAILABLE NUMBER

number available
NUM_TARGETED NUMBER

number of targeted
NUM_RESPONDED NUMBER

number of responded
NUM_ENROLLED NUMBER

number of enrolled
NUM_ATTENDED NUMBER

number of attended
NUM_CANCELLED NUMBER

number of cancelled
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
,      NUM_AVAILABLE
,      NUM_TARGETED
,      NUM_RESPONDED
,      NUM_ENROLLED
,      NUM_ATTENDED
,      NUM_CANCELLED
FROM APPS.BIM_SUMV_EVENT_RSLTS;

Dependencies

[top of page]

APPS.BIM_SUMV_EVENT_RSLTS references the following:

SchemaAPPS
ViewBIM_DIMV_EVENT_HIER
SynonymBIM_EVENT_RESP_SUMM
PL/SQL PackageFND_GLOBAL - show dependent code

APPS.BIM_SUMV_EVENT_RSLTS is not referenced by any database object