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: OTA.OTA_NOTRNG_HISTORIES#

Object Details

Object Name:	OTA_NOTRNG_HISTORIES#
Object Type:	VIEW
Owner:	OTA
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
NOTA_HISTORY_ID	NUMBER	(38)	Yes
PERSON_ID	NUMBER	(10)	Yes
CONTACT_ID	NUMBER	(9)
TRNG_TITLE	VARCHAR2	(80)	Yes
PROVIDER	VARCHAR2	(80)	Yes
TYPE	VARCHAR2	(30)
CENTRE	VARCHAR2	(80)
COMPLETION_DATE	DATE		Yes
AWARD	VARCHAR2	(80)
RATING	VARCHAR2	(30)
DURATION	NUMBER
DURATION_UNITS	VARCHAR2	(30)
ACTIVITY_VERSION_ID	NUMBER	(9)
STATUS	VARCHAR2	(30)
VERIFIED_BY_ID	NUMBER	(15)
LAST_UPDATE_DATE	DATE
LAST_UPDATED_BY	NUMBER	(15)
LAST_UPDATE_LOGIN	NUMBER	(15)
CREATED_BY	NUMBER	(15)
CREATION_DATE	DATE
NTH_INFORMATION_CATEGORY	VARCHAR2	(30)
NTH_INFORMATION1	VARCHAR2	(150)
NTH_INFORMATION2	VARCHAR2	(150)
NTH_INFORMATION3	VARCHAR2	(150)
NTH_INFORMATION4	VARCHAR2	(150)
NTH_INFORMATION5	VARCHAR2	(150)
NTH_INFORMATION6	VARCHAR2	(150)
NTH_INFORMATION7	VARCHAR2	(150)
NTH_INFORMATION8	VARCHAR2	(150)
NTH_INFORMATION9	VARCHAR2	(150)
NTH_INFORMATION10	VARCHAR2	(150)
NTH_INFORMATION11	VARCHAR2	(150)
NTH_INFORMATION12	VARCHAR2	(150)
NTH_INFORMATION13	VARCHAR2	(150)
NTH_INFORMATION14	VARCHAR2	(150)
NTH_INFORMATION15	VARCHAR2	(150)
NTH_INFORMATION16	VARCHAR2	(150)
NTH_INFORMATION17	VARCHAR2	(150)
NTH_INFORMATION18	VARCHAR2	(150)
NTH_INFORMATION19	VARCHAR2	(150)
NTH_INFORMATION20	VARCHAR2	(150)
ORG_ID	NUMBER	(15)
OBJECT_VERSION_NUMBER	NUMBER	(5)	Yes
BUSINESS_GROUP_ID	NUMBER	(9)	Yes
CUSTOMER_ID	NUMBER
ORGANIZATION_ID	NUMBER	(15)

Query Text

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


SELECT NOTA_HISTORY_ID
,      PERSON_ID
,      CONTACT_ID
,      TRNG_TITLE
,      PROVIDER
,      TYPE
,      CENTRE
,      COMPLETION_DATE
,      AWARD
,      RATING
,      DURATION
,      DURATION_UNITS
,      ACTIVITY_VERSION_ID
,      STATUS
,      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
,      OBJECT_VERSION_NUMBER
,      BUSINESS_GROUP_ID
,      CUSTOMER_ID
,      ORGANIZATION_ID
FROM OTA.OTA_NOTRNG_HISTORIES#;

Dependencies

[top of page]

OTA.OTA_NOTRNG_HISTORIES# references the following:

OTA: OTA_NOTRNG_HISTORIES

OTA.OTA_NOTRNG_HISTORIES# is referenced by following:

APPS: OTA_NOTRNG_HISTORIES; OTA_NOTRNG_HISTORIES_WHO