eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.OTFV_TOTAL_ENROLLMENTS

Object Details

Object Name:	OTFV_TOTAL_ENROLLMENTS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OTA.OTFV_TOTAL_ENROLLMENTS
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

This view shows the enrollment information at event level

[View Source]

Columns

Name	Datatype	Length	Mandatory
EVENT_TITLE	VARCHAR2	(80)	Yes
TOTAL_ENROLLMENTS	NUMBER
TOTAL_ATTENDED_ENROLLMENTS	NUMBER
TOTAL_NON_ATTENDED_ENROLLMENTS	NUMBER
TOTAL_CANCELLED_ENROLLMENTS	NUMBER
TOTAL_PLACED_ENROLLMENTS	NUMBER
TOTAL_REQUESTED_ENROLLMENTS	NUMBER
TOTAL_WAITLISTED_ENROLLMENTS	NUMBER
TOTAL_INTERNAL_ENROLLMENTS	NUMBER
TOTAL_EXTERNAL_ENROLLMENTS	NUMBER
EVENT_ID	NUMBER	(9)	Yes
OFFERING_ID	NUMBER	(9)

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT EVENT_TITLE
,      TOTAL_ENROLLMENTS
,      TOTAL_ATTENDED_ENROLLMENTS
,      TOTAL_NON_ATTENDED_ENROLLMENTS
,      TOTAL_CANCELLED_ENROLLMENTS
,      TOTAL_PLACED_ENROLLMENTS
,      TOTAL_REQUESTED_ENROLLMENTS
,      TOTAL_WAITLISTED_ENROLLMENTS
,      TOTAL_INTERNAL_ENROLLMENTS
,      TOTAL_EXTERNAL_ENROLLMENTS
,      EVENT_ID
,      OFFERING_ID
FROM APPS.OTFV_TOTAL_ENROLLMENTS;

Dependencies

[top of page]

APPS.OTFV_TOTAL_ENROLLMENTS references the following:

APPS: OTA_BOOKING_STATUS_TYPES; OTA_DELEGATE_BOOKINGS; OTA_EVENTS; OTA_EVENTS_TL; OTA_GENERAL - show dependent code

APPS.OTFV_TOTAL_ENROLLMENTS is referenced by following:

PUBLIC: OTFV_TOTAL_ENROLLMENTS