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

Object Details

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

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)
EVENT_ID	NUMBER	(9)	Yes
BUSINESS_GROUP_ID	NUMBER	(9)	Yes	Foreign key to HR_ALL_ORGANIZATION_UNITS
ORGANIZATION_ID	NUMBER	(9)		Foreign key to HR_ALL_ORGANIZATION_UNITS
ACTIVITY_VERSION_ID	NUMBER	(9)		Foreign key to OTA_ACTIVITY_VERSIONS
VENDOR_ID	NUMBER	(15)		Foreign key to PO_VENDORS.
PARENT_EVENT_ID	NUMBER	(9)		Foreign key to OTA_EVENTS
EVENT_TYPE	VARCHAR2	(30)	Yes	The type of module activity.
OBJECT_VERSION_NUMBER	NUMBER	(5)	Yes	Version control parameter
TITLE	VARCHAR2	(80)	Yes	The name or title associated with this event.
ACTUAL_COST	NUMBER			The actual cost of the Event
BUDGET_COST	NUMBER			The Budgetted Cost for the Event
BUDGET_CURRENCY_CODE	VARCHAR2	(30)		The Currency of the Budgetted and Actual Cost
CENTRE	VARCHAR2	(30)		The centre at which this event is to take place.
COMMENTS	VARCHAR2	(2000)		Any special comments or notes for this entry. Descriptive only.
COURSE_END_DATE	DATE			The Date on which the Event Ends
COURSE_END_TIME	VARCHAR2	(5)		The end time of the event
COURSE_START_DATE	DATE			The Date on which the Event Starts
COURSE_START_TIME	VARCHAR2	(5)		The start time of the event
DURATION	NUMBER			The duration of the event measured in units specified in UNIT
DURATION_UNITS	VARCHAR2	(30)		The units in which the duration is measured
ENROLMENT_END_DATE	DATE			The closing date for bookings of this entry.
ENROLMENT_START_DATE	DATE			The earliest date on which bookings may be taken for this entry.
LANGUAGE_ID	NUMBER	(9)		The language in which the course is taught.
PUBLIC_EVENT_FLAG	VARCHAR2	(30)		An indication of whether an Event can have associations
USER_STATUS	VARCHAR2	(80)		User Definition of the Event Status
DEVELOPMENT_EVENT_TYPE	VARCHAR2	(30)		The user description of the developement type defined.
EVENT_STATUS	VARCHAR2	(30)		The status of this schedule entry.
PRICE_BASIS	VARCHAR2	(30)		Price basis of the Event : Student or Customer
SECURE_EVENT_FLAG	VARCHAR2	(30)		An indication of whether an event can be maintained by employees of the administering organization only.
BOOK_INDEPENDENT_FLAG	VARCHAR2	(30)		Whether the Scheduled can be indepepndent of a program
CURRENCY_CODE	VARCHAR2	(30)		The currency in which the standard price is defined.
MAXIMUM_ATTENDEES	NUMBER	(9)		The maximum number of students who may attend
MAXIMUM_INTERNAL_ATTENDEES	NUMBER	(9)		The maximum number of internal students
MINIMUM_ATTENDEES	NUMBER	(9)		The minimum number of students for this entry to be viable.
STANDARD_PRICE	NUMBER			The standard price per (price basis) booking for this entry
CATEGORY_CODE	VARCHAR2	(30)		Identifies the programme of activities for the event group
LAST_UPDATE_DATE	DATE			Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)		Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who Column
CREATED_BY	NUMBER	(15)		Standard Who Column
CREATION_DATE	DATE			Standard Who Column
EVT_INFORMATION_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure defining column
EVT_INFORMATION1	VARCHAR2	(150)		Descriptive flexfield segment column
EVT_INFORMATION2	VARCHAR2	(150)		Descriptive flexfield segment column
EVT_INFORMATION3	VARCHAR2	(150)		Descriptive flexfield segment column
EVT_INFORMATION4	VARCHAR2	(150)		Descriptive flexfield segment column
EVT_INFORMATION5	VARCHAR2	(150)		Descriptive flexfield segment column
EVT_INFORMATION6	VARCHAR2	(150)		Descriptive flexfield segment column
EVT_INFORMATION7	VARCHAR2	(150)		Descriptive flexfield segment column
EVT_INFORMATION8	VARCHAR2	(150)		Descriptive flexfield segment column
EVT_INFORMATION9	VARCHAR2	(150)		Descriptive flexfield segment column
EVT_INFORMATION10	VARCHAR2	(150)		Descriptive flexfield segment column
EVT_INFORMATION11	VARCHAR2	(150)		Descriptive flexfield segment column
EVT_INFORMATION12	VARCHAR2	(150)		Descriptive flexfield segment column
EVT_INFORMATION13	VARCHAR2	(150)		Descriptive flexfield segment column
EVT_INFORMATION14	VARCHAR2	(150)		Descriptive flexfield segment column
EVT_INFORMATION15	VARCHAR2	(150)		Descriptive flexfield segment column
EVT_INFORMATION16	VARCHAR2	(150)		Descriptive flexfield segment column
EVT_INFORMATION17	VARCHAR2	(150)		Descriptive flexfield segment column
EVT_INFORMATION18	VARCHAR2	(150)		Descriptive flexfield segment column
EVT_INFORMATION19	VARCHAR2	(150)		Descriptive flexfield segment column
EVT_INFORMATION20	VARCHAR2	(150)		Descriptive flexfield segment column
PROJECT_ID	NUMBER	(15)		Foreign Key to PA_PROJECTS_ALL.
OWNER_ID	NUMBER	(10)		Foriegn key to PER_ALL_PEOPLE_F.
LINE_ID	NUMBER	(15)		Foriegn key to OE_ORDER_LINES_ALL.
ORG_ID	NUMBER	(15)		The number of the Org ID that is associated to the enrollment through OM or OTA.
TRAINING_CENTER_ID	NUMBER	(15)		Foriegn key to HR_ALL_ORGANIZATION_UNITS.
LOCATION_ID	NUMBER	(15)		Foriegn key to HR_LOCATIONS.
OFFERING_ID	NUMBER			iLearning Offering unique identifier
TIMEZONE	VARCHAR2	(30)		Timezone of the Event Date
PARENT_OFFERING_ID	NUMBER	(9)
DATA_SOURCE	VARCHAR2	(30)
EVENT_AVAILABILITY	VARCHAR2	(30)

Query Text

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


SELECT ROW_ID
,      EVENT_ID
,      BUSINESS_GROUP_ID
,      ORGANIZATION_ID
,      ACTIVITY_VERSION_ID
,      VENDOR_ID
,      PARENT_EVENT_ID
,      EVENT_TYPE
,      OBJECT_VERSION_NUMBER
,      TITLE
,      ACTUAL_COST
,      BUDGET_COST
,      BUDGET_CURRENCY_CODE
,      CENTRE
,      COMMENTS
,      COURSE_END_DATE
,      COURSE_END_TIME
,      COURSE_START_DATE
,      COURSE_START_TIME
,      DURATION
,      DURATION_UNITS
,      ENROLMENT_END_DATE
,      ENROLMENT_START_DATE
,      LANGUAGE_ID
,      PUBLIC_EVENT_FLAG
,      USER_STATUS
,      DEVELOPMENT_EVENT_TYPE
,      EVENT_STATUS
,      PRICE_BASIS
,      SECURE_EVENT_FLAG
,      BOOK_INDEPENDENT_FLAG
,      CURRENCY_CODE
,      MAXIMUM_ATTENDEES
,      MAXIMUM_INTERNAL_ATTENDEES
,      MINIMUM_ATTENDEES
,      STANDARD_PRICE
,      CATEGORY_CODE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      EVT_INFORMATION_CATEGORY
,      EVT_INFORMATION1
,      EVT_INFORMATION2
,      EVT_INFORMATION3
,      EVT_INFORMATION4
,      EVT_INFORMATION5
,      EVT_INFORMATION6
,      EVT_INFORMATION7
,      EVT_INFORMATION8
,      EVT_INFORMATION9
,      EVT_INFORMATION10
,      EVT_INFORMATION11
,      EVT_INFORMATION12
,      EVT_INFORMATION13
,      EVT_INFORMATION14
,      EVT_INFORMATION15
,      EVT_INFORMATION16
,      EVT_INFORMATION17
,      EVT_INFORMATION18
,      EVT_INFORMATION19
,      EVT_INFORMATION20
,      PROJECT_ID
,      OWNER_ID
,      LINE_ID
,      ORG_ID
,      TRAINING_CENTER_ID
,      LOCATION_ID
,      OFFERING_ID
,      TIMEZONE
,      PARENT_OFFERING_ID
,      DATA_SOURCE
,      EVENT_AVAILABILITY
FROM APPS.OTA_EVENTS_VL;

Dependencies

[top of page]

APPS.OTA_EVENTS_VL references the following:

APPS: OTA_EVENTS; OTA_EVENTS_TL

APPS.OTA_EVENTS_VL is referenced by following:

APPS: OTA_BULK_ENROLL_UTIL - show dependent code; OTA_CANCEL_API - show dependent code; OTA_CANCEL_TRAINING_SS - show dependent code; OTA_COMPETENCE_SS - show dependent code; OTA_DELEGATE_BOOKING_API - show dependent code; OTA_ENROLL_IN_TRAINING_SS - show dependent code; OTA_ENROLL_REVIEW_SS - show dependent code; OTA_EVT_BUS - show dependent code; OTA_EVT_SHD - show dependent code; OTA_GENERAL - show dependent code; OTA_ILEARNING - show dependent code; OTA_INITIALIZATION_WF - show dependent code; OTA_LEARNER_ENROLL_REVIEW_SS - show dependent code; OTA_LEARNER_ENROLL_SS - show dependent code; OTA_OM_UTIL - show dependent code; OTA_OTARPBUD_XMLP_PKG - show dependent code; OTA_TRAINING_SS - show dependent code; OTA_TRB_API_PROCEDURES - show dependent code; OTA_TRNG_ENROLL_SS - show dependent code; OTA_UTILITY - show dependent code; PQP_RIW_CLASS_WRAPPER - show dependent code