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

VIEW: APPS.OKL_K_ARTICLES_UV

Object Details
Object Name: OKL_K_ARTICLES_UV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKL.OKL_K_ARTICLES_UV
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
ID NUMBER

Primary key column
CHR_ID NUMBER

Contract Identifier
CLE_ID NUMBER

CAT_ID NUMBER

Foreign key to view OKL_CASH_ALLCTN_RLS_V
OBJECT_VERSION_NUMBER NUMBER (9)
Column used for locking records during updates
SFWT_FLAG VARCHAR2 (0)
Column used by the translation batch program
SAV_SAE_ID NUMBER

SAV_SAV_RELEASE VARCHAR2 (50)
SBT_CODE VARCHAR2 (30)
DNZ_CHR_ID NUMBER

COMMENTS VARCHAR2 (2000)
User entered comments
FULLTEXT_YN VARCHAR2 (3)
VARIATION_DESCRIPTION VARCHAR2 (240)
NAME VARCHAR2 (450)
Name
CAT_TYPE VARCHAR2 (3)
CREATED_BY NUMBER (15)
Standard Who column
CREATION_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER (15)
Standard Who column
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
Query Text

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


SELECT ID
,      CHR_ID
,      CLE_ID
,      CAT_ID
,      OBJECT_VERSION_NUMBER
,      SFWT_FLAG
,      SAV_SAE_ID
,      SAV_SAV_RELEASE
,      SBT_CODE
,      DNZ_CHR_ID
,      COMMENTS
,      FULLTEXT_YN
,      VARIATION_DESCRIPTION
,      NAME
,      CAT_TYPE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM APPS.OKL_K_ARTICLES_UV;

Dependencies

[top of page]

APPS.OKL_K_ARTICLES_UV references the following:

SchemaAPPS
PL/SQL PackageMO_GLOBAL - show dependent code
ViewOKC_K_ARTICLES_V
ViewOKC_STD_ARTICLES_V

APPS.OKL_K_ARTICLES_UV is not referenced by any database object