[Home] [Help] [Dependency Information]

VIEW: APPS.OTFV_ENROLLED_EVENTS

Object Details

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

View Type

A Business Intelligence System view

This view shows the data for internal as well as external students enrolled on a specific class by their enrollment statuses.

[View Source]

Columns

Query Text

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

SELECT BUSINESS_GROUP_NAME
,      PERSON_NAME
,      EVENT_TITLE
,      EVENT_COMMENTS
,      COURSE_START_DATE
,      COURSE_END_DATE
,      DATE_BOOKING_PLACED
,      TRAINING_CENTER
,      ATTENDANCE_RESULT
,      FAILURE_REASON
,      SUCCESSFUL_ATTENDANCE_FLAG
,      TOTAL_TRAINING_TIME
,      PLAYER_STATUS
,      TEST_SCORE
,      NUMBER_OF_MODULES_COMPLETED
,      TOTAL_MODULES
,      CURRENT_EMPLOYEE_FLAG
,      INTERNAL_BOOKING_FLAG
,      CUSTOMER_NAME
,      ASSIGNMENT_NUMBER
,      ASSIGNMENT_ORGANIZATION
,      ASSIGNMENT_LOCATION
,      ASSIGNMENT_JOB_CATEGORY
,      ASSIGNMENT_JOB
,      BOOKING_STATUS
,      BOOKING_STATUS_TYPE
,      ACTIVITY_NAME
,      LANGUAGE
,      ORGANIZATION_NAME
,      NUMBER_OF_PLACES
,      NUMBER_OF_SUCCESSFUL_PLACES
,      REQUESTED_ENROLLMENT
,      ATTENDED_ENROLLMENT
,      PLACED_ENROLLMENT
,      WAITLISTED_ENROLLMENT
,      TRAINING_TARGET_TYPE
,      SUCC_ATT_INT_STUDENT_COUNT
,      SUCC_ATT_EXT_STUDENT_COUNT
,      NON_SUCC_ATT_INT_STUDENT_COUNT
,      NON_SUCC_ATT_EXT_STUDENT_COUNT
,      CONFIRMED_INT_STUDENT_COUNT
,      CONFIRMED_EXT_STUDENT_COUNT
,      ATTENDED_INT_STUDENT_COUNT
,      ATTENDED_EXT_STUDENT_COUNT
,      NON_ATTENDED_INT_STUDENT_COUNT
,      NON_ATTENDED_EXT_STUDENT_COUNT
,      CANCELLED_INT_STUDENT_COUNT
,      CANCELLED_EXT_STUDENT_COUNT
,      DURATION
,      DURATION_UNITS
,      DURATION_UNITS_CODE
,      ENROLMENT_COMMENTS
,      SPECIAL_REQUIREMENTS
,      SOURCE_OF_BOOKING_MEANING
,      CORRESPONDENCE_MEANING
,      CORRESPONDENCE_PHONE
,      CORRESPONDENCE_FAX
,      CORRESPONDENCE_EMAIL
,      ADDRESS_LINE_1
,      ADDRESS_LINE_2
,      ADDRESS_LINE_3
,      ADDRESS_LINE_4
,      CITY
,      STATE
,      POSTAL_CODE
,      COUNTRY
,      _DF
,      BUSINESS_GROUP_ID
,      ACTIVITY_VERSION_ID
,      ASSIGNMENT_ID
,      BOOKING_STATUS_TYPE_ID
,      CUSTOMER_ID
,      DELEGATE_CONTACT_ID
,      ENROLLMENT_ID
,      ORGANIZATION_ID
,      PERSON_ID
,      ORG_ID
,      LINE_ID
,      EVENT_ID
,      TRAINING_CENTER_ID
,      RCO_ID
,      OFFERING_ID
,      PLAYER_STATUS_CODE
FROM APPS.OTFV_ENROLLED_EVENTS;

Dependencies

[top of page]

APPS

HR_ALL_ORGANIZATION_UNITS_TL

HR_BIS - show dependent code

HR_LOCATIONS_ALL

HR_LOCATIONS_ALL_TL

HZ_CUST_ACCOUNTS

HZ_CUST_ACCOUNT_ROLES

HZ_CUST_ACCT_SITES

HZ_LOCATIONS

HZ_ORG_CONTACTS

HZ_PARTIES

HZ_PARTY_SITES

HZ_RELATIONSHIPS

OTA_ACTIVITY_VERSIONS

OTA_ACTIVITY_VERSIONS_TL

OTA_BOOKING_STATUS_TYPES

OTA_BOOKING_STATUS_TYPES_TL

OTA_DELEGATE_BOOKINGS

OTA_EVENTS

OTA_EVENTS_TL

OTA_GENERAL - show dependent code

OTA_LEARNING_OBJECTS

OTA_LO_UTILITY - show dependent code

OTA_OFFERINGS

OTA_PERFORMANCES

OTA_TDB_BUS - show dependent code

OTA_UTILITY - show dependent code

PER_ADDRESSES

PER_ALL_ASSIGNMENTS_F

PER_ALL_PEOPLE_F

PER_JOBS

PER_JOB_EXTRA_INFO

APPS.OTFV_ENROLLED_EVENTS is not referenced by any database object