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_CTRNG_HISTORIES_V

Object Details

Object Name:	OTA_CTRNG_HISTORIES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OTA.OTA_CTRNG_HISTORIES_V
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	Comments
REFERENCE_DATE	DATE		The date of the training
REFERENCE_TITLE	VARCHAR2	(80)	The title of the training
EVENT_CENTER_MEANING	VARCHAR2	(240)	The name of the site were training was taken
EVENT_ACTIVITY_VERSION_NAME	VARCHAR2	(80)	The name of an equivalent OTA activity
REFERENCE_STATUS	VARCHAR2	(4000)	The current status of the training
SUCCESSFUL_ATTENDANCE_MEANING	VARCHAR2	(4000)
FAILURE_REASON_MEANING	VARCHAR2	(4000)	The Delegate Booking Failure Reason
SCHOLASTIC_RATING	VARCHAR2	(40)	The scholastic rating achieved
PROVIDER	VARCHAR2	(240)
TRAINING_REFERENCE	VARCHAR2	(10)
PERSON_ID	NUMBER	(10)	The ID of the person to which the training history applies
CONTACT_ID	NUMBER		The ID of the contact person associated with the training
DURATION	NUMBER		Duration is the duration of the Event
DURATION_UNITS	VARCHAR2	(4000)	This is the Duration unit meaning
LAST_UPDATE_DATE	DATE
LAST_UPDATED_BY	NUMBER	(15)
LAST_UPDATE_LOGIN	NUMBER	(15)
CREATION_DATE	DATE
CREATED_BY	NUMBER	(15)
ORGANIZATION_ID	NUMBER
CUSTOMER_ID	NUMBER

Query Text

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


SELECT REFERENCE_DATE
,      REFERENCE_TITLE
,      EVENT_CENTER_MEANING
,      EVENT_ACTIVITY_VERSION_NAME
,      REFERENCE_STATUS
,      SUCCESSFUL_ATTENDANCE_MEANING
,      FAILURE_REASON_MEANING
,      SCHOLASTIC_RATING
,      PROVIDER
,      TRAINING_REFERENCE
,      PERSON_ID
,      CONTACT_ID
,      DURATION
,      DURATION_UNITS
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      ORGANIZATION_ID
,      CUSTOMER_ID
FROM APPS.OTA_CTRNG_HISTORIES_V;

Dependencies

[top of page]

APPS.OTA_CTRNG_HISTORIES_V references the following:

APPS: HR_ALL_ORGANIZATION_UNITS_TL; HR_GENERAL - show dependent code; OTA_ACTIVITY_VERSIONS_TL; OTA_BOOKING_STATUS_TYPES_TL; OTA_DELEGATE_BOOKINGS; OTA_EVENTS; OTA_EVENTS_TL; OTA_NOTRNG_HISTORIES_V; PO_VENDORS

APPS.OTA_CTRNG_HISTORIES_V is referenced by following:

PUBLIC: OTA_CTRNG_HISTORIES_V