Skip to content

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

VIEW: OKC.OKC_REVIEW_UPLD_TERMS#

Object Details
Object Name: OKC_REVIEW_UPLD_TERMS#
Object Type: VIEW
Owner: OKC
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
REVIEW_UPLD_TERMS_ID NUMBER

DOCUMENT_ID NUMBER

DOCUMENT_TYPE VARCHAR2 (30)
OBJECT_ID NUMBER

OBJECT_TYPE VARCHAR2 (30)
OBJECT_TEXT CLOB (4000)
PARENT_OBJECT_TYPE VARCHAR2 (30)
PARENT_ID NUMBER

ARTICLE_ID NUMBER

ARTICLE_VERSION_ID NUMBER

OBJECT_VERSION_NUMBER NUMBER (9)
LABEL VARCHAR2 (60)
DISPLAY_SEQ NUMBER

ACTION VARCHAR2 (30)
ERROR_MESSAGE_COUNT NUMBER

WARNING_MESSAGE_COUNT NUMBER

LAST_UPDATE_LOGIN NUMBER

CREATED_BY NUMBER

CREATION_DATE DATE

LAST_UPDATED_BY NUMBER

LAST_UPDATE_DATE DATE

NON_STANDARD_FLAG VARCHAR2 (1)
MANDATORY_FLAG VARCHAR2 (1)
LOCK_TEXT VARCHAR2 (1)
NEW_PARENT_ID NUMBER

OBJECT_TITLE CLOB (4000)
UPLOAD_LEVEL NUMBER

OLD_REVIEW_UPLD_TERMS_ID NUMBER

Query Text

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


SELECT REVIEW_UPLD_TERMS_ID
,      DOCUMENT_ID
,      DOCUMENT_TYPE
,      OBJECT_ID
,      OBJECT_TYPE
,      OBJECT_TEXT
,      PARENT_OBJECT_TYPE
,      PARENT_ID
,      ARTICLE_ID
,      ARTICLE_VERSION_ID
,      OBJECT_VERSION_NUMBER
,      LABEL
,      DISPLAY_SEQ
,      ACTION
,      ERROR_MESSAGE_COUNT
,      WARNING_MESSAGE_COUNT
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      NON_STANDARD_FLAG
,      MANDATORY_FLAG
,      LOCK_TEXT
,      NEW_PARENT_ID
,      OBJECT_TITLE
,      UPLOAD_LEVEL
,      OLD_REVIEW_UPLD_TERMS_ID
FROM OKC.OKC_REVIEW_UPLD_TERMS#;

Dependencies

[top of page]

OKC.OKC_REVIEW_UPLD_TERMS# references the following:

SchemaOKC
TableOKC_REVIEW_UPLD_TERMS
OKC.OKC_REVIEW_UPLD_TERMS# is referenced by following:

SchemaAPPS
SynonymOKC_REVIEW_UPLD_TERMS