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

VIEW: APPS.OKC_TERMS_ART_VERSIONS_V

Object Details
Object Name: OKC_TERMS_ART_VERSIONS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKC.OKC_TERMS_ART_VERSIONS_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
ARTICLE_ID NUMBER

ARTICLE_VERSION_ID NUMBER

ARTICLE_VERSION_NUMBER NUMBER

ARTICLE_TITLE VARCHAR2 (450)
ARTICLE_STATUS VARCHAR2 (30)
DISPLAY_NAME VARCHAR2 (450)
ARTICLE_TYPE VARCHAR2 (30)
ARTICLE_NUMBER VARCHAR2 (240)
ARTICLE_INTENT VARCHAR2 (1)
ARTICLE_TEXT CLOB (4000)
ARTICLE_DESCRIPTION VARCHAR2 (2000)
ADDITIONAL_INSTRUCTIONS VARCHAR2 (2000)
START_DATE DATE

END_DATE DATE

PROVISION_YN VARCHAR2 (1)
DEFAULT_SECTION VARCHAR2 (30)
ORG_ID NUMBER

LOCK_TEXT VARCHAR2 (1)
GLOBAL_YN VARCHAR2 (1)
INSERT_BY_REFERENCE VARCHAR2 (1)
ADOPTION_TYPE VARCHAR2 (30)
Query Text

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


SELECT ARTICLE_ID
,      ARTICLE_VERSION_ID
,      ARTICLE_VERSION_NUMBER
,      ARTICLE_TITLE
,      ARTICLE_STATUS
,      DISPLAY_NAME
,      ARTICLE_TYPE
,      ARTICLE_NUMBER
,      ARTICLE_INTENT
,      ARTICLE_TEXT
,      ARTICLE_DESCRIPTION
,      ADDITIONAL_INSTRUCTIONS
,      START_DATE
,      END_DATE
,      PROVISION_YN
,      DEFAULT_SECTION
,      ORG_ID
,      LOCK_TEXT
,      GLOBAL_YN
,      INSERT_BY_REFERENCE
,      ADOPTION_TYPE
FROM APPS.OKC_TERMS_ART_VERSIONS_V;

Dependencies

[top of page]

APPS.OKC_TERMS_ART_VERSIONS_V references the following:

SchemaAPPS
SynonymOKC_ARTICLES_ALL
SynonymOKC_ARTICLE_ADOPTIONS
SynonymOKC_ARTICLE_VERSIONS

APPS.OKC_TERMS_ART_VERSIONS_V is not referenced by any database object