DBA Data[Home] [Help] [Dependency Information]


VIEW: OTA.OTA_CERTIFICATIONS_TL#

Object Details
Object Name: OTA_CERTIFICATIONS_TL#
Object Type: VIEW
Owner: OTA
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
CERTIFICATION_ID NUMBER (15) Yes
LANGUAGE VARCHAR2 (4) Yes
NAME VARCHAR2 (240) Yes
DESCRIPTION VARCHAR2 (4000)
SOURCE_LANG VARCHAR2 (4) Yes
OBJECTIVES VARCHAR2 (4000)
PURPOSE VARCHAR2 (4000)
KEYWORDS VARCHAR2 (2000)
END_DATE_COMMENTS VARCHAR2 (4000)
INITIAL_PERIOD_COMMENTS VARCHAR2 (4000)
RENEWAL_PERIOD_COMMENTS VARCHAR2 (4000)
CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
Query Text

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


SELECT CERTIFICATION_ID
,      LANGUAGE
,      NAME
,      DESCRIPTION
,      SOURCE_LANG
,      OBJECTIVES
,      PURPOSE
,      KEYWORDS
,      END_DATE_COMMENTS
,      INITIAL_PERIOD_COMMENTS
,      RENEWAL_PERIOD_COMMENTS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM OTA.OTA_CERTIFICATIONS_TL#;

Dependencies

[top of page]

OTA.OTA_CERTIFICATIONS_TL# references the following:

SchemaOTA
TableOTA_CERTIFICATIONS_TL
OTA.OTA_CERTIFICATIONS_TL# is referenced by following:

SchemaAPPS
TriggerOTA_CERTIFICATIONS_T034611_WHO
TriggerOTA_CERTIFICATIONS_T054742_WHO
SynonymOTA_CERTIFICATIONS_TL