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_NOTRNG_HISTORIES_V

Object Details

Object Name:	OTA_NOTRNG_HISTORIES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OTA.OTA_NOTRNG_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	Mandatory	Comments
ROW_ID	ROWID	(10)
PERSON_ID	NUMBER	(10)	Yes	The ID of the person to which the training history applies
CONTACT_ID	NUMBER	(9)		The ID of the contact person associated with the training
TRNG_TITLE	VARCHAR2	(80)	Yes	The title of the training
PROVIDER	VARCHAR2	(80)	Yes	The name of the training supplier/provider
TYPE	VARCHAR2	(30)		The method which the training was achieved
CENTRE	VARCHAR2	(80)		The training location or centre name
COMPLETION_DATE	DATE		Yes	The date on which the training was aquired
AWARD	VARCHAR2	(80)		The award/distinction/achievenebt granted
RATING	VARCHAR2	(30)		The scholastic rating achieved
DURATION	NUMBER			The duration of the training
DURATION_UNITS	VARCHAR2	(30)		The units of the duration period
STATUS	VARCHAR2	(30)		The current status of the training
ACTIVITY_VERSION_ID	NUMBER	(9)		The ID of the OTA activity associated to this training
VERIFIED_BY_ID	NUMBER	(15)		the person that verified the taining
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
NTH_INFORMATION_CATEGORY	VARCHAR2	(30)		Descriptive Flexfied Segment atructure defining column
NTH_INFORMATION1	VARCHAR2	(150)		Descriptive Flexfied Segment(The system name that offered and booked the training)
NTH_INFORMATION2	VARCHAR2	(150)		Descriptive Flexfied Segment(the system's event/offering ID)
NTH_INFORMATION3	VARCHAR2	(150)		Descriptive Flexfied Segment(The system's person registration ID/tracking Identifier)
NTH_INFORMATION4	VARCHAR2	(150)		Descriptive Flexfied Segment
NTH_INFORMATION5	VARCHAR2	(150)		Descriptive Flexfied Segment
NTH_INFORMATION6	VARCHAR2	(150)		Descriptive Flexfied Segment
NTH_INFORMATION7	VARCHAR2	(150)		Descriptive Flexfied Segment
NTH_INFORMATION8	VARCHAR2	(150)		Descriptive Flexfied Segment
NTH_INFORMATION9	VARCHAR2	(150)		Descriptive Flexfied Segment
NTH_INFORMATION10	VARCHAR2	(150)		Descriptive Flexfied Segment
NTH_INFORMATION11	VARCHAR2	(150)		Descriptive Flexfied Segment
NTH_INFORMATION12	VARCHAR2	(150)		Descriptive Flexfied Segment
NTH_INFORMATION13	VARCHAR2	(150)		Descriptive Flexfied Segment
NTH_INFORMATION14	VARCHAR2	(150)		Descriptive Flexfied Segment
NTH_INFORMATION15	VARCHAR2	(150)		Descriptive Flexfied Segment
NTH_INFORMATION16	VARCHAR2	(150)		Descriptive Flexfied Segment
NTH_INFORMATION17	VARCHAR2	(150)		Descriptive Flexfied Segment
NTH_INFORMATION18	VARCHAR2	(150)		Descriptive Flexfied Segment
NTH_INFORMATION19	VARCHAR2	(150)		Descriptive Flexfied Segment
NTH_INFORMATION20	VARCHAR2	(150)		Descriptive Flexfied Segment
ORG_ID	NUMBER	(15)
BUSINESS_GROUP_ID	NUMBER	(9)	Yes	Version control parameter
OBJECT_VERSION_NUMBER	NUMBER	(5)	Yes
VERSION_NAME	VARCHAR2	(80)		The name of the OTA activity associated with this training
ORGANIZATION_ID	NUMBER	(15)
CUSTOMER_ID	NUMBER

Query Text

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


SELECT ROW_ID
,      PERSON_ID
,      CONTACT_ID
,      TRNG_TITLE
,      PROVIDER
,      TYPE
,      CENTRE
,      COMPLETION_DATE
,      AWARD
,      RATING
,      DURATION
,      DURATION_UNITS
,      STATUS
,      ACTIVITY_VERSION_ID
,      VERIFIED_BY_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      NTH_INFORMATION_CATEGORY
,      NTH_INFORMATION1
,      NTH_INFORMATION2
,      NTH_INFORMATION3
,      NTH_INFORMATION4
,      NTH_INFORMATION5
,      NTH_INFORMATION6
,      NTH_INFORMATION7
,      NTH_INFORMATION8
,      NTH_INFORMATION9
,      NTH_INFORMATION10
,      NTH_INFORMATION11
,      NTH_INFORMATION12
,      NTH_INFORMATION13
,      NTH_INFORMATION14
,      NTH_INFORMATION15
,      NTH_INFORMATION16
,      NTH_INFORMATION17
,      NTH_INFORMATION18
,      NTH_INFORMATION19
,      NTH_INFORMATION20
,      ORG_ID
,      BUSINESS_GROUP_ID
,      OBJECT_VERSION_NUMBER
,      VERSION_NAME
,      ORGANIZATION_ID
,      CUSTOMER_ID
FROM APPS.OTA_NOTRNG_HISTORIES_V;

Dependencies

[top of page]

APPS.OTA_NOTRNG_HISTORIES_V references the following:

APPS: OTA_ACTIVITY_VERSIONS_TL; OTA_NOTRNG_HISTORIES

APPS.OTA_NOTRNG_HISTORIES_V is referenced by following:

APPS: OTA_CTRNG_HISTORIES_V