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

VIEW: APPS.OKL_ITM_CAT_RV_PRCS_UV

Object Details
Object Name: OKL_ITM_CAT_RV_PRCS_UV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKL.OKL_ITM_CAT_RV_PRCS_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
Yes Primary key column
OBJECT_VERSION_NUMBER NUMBER (9) Yes Column used for locking records during updates
CAT_ID1 NUMBER

No Longer Used
CAT_ID2 VARCHAR2 (0)
No Longer Used
NAME VARCHAR2 (240)
Name
TERM_IN_MONTHS NUMBER

No Longer Used
RESIDUAL_VALUE_PERCENT NUMBER

No Longer Used
ITEM_RESIDUAL_ID NUMBER

Item residual Identifier
STS_CODE VARCHAR2 (30)
Status code of the version
VERSION_NUMBER VARCHAR2 (30)
Version Number of the Item Residual Version
START_DATE DATE

Start Date
END_DATE DATE

End Date
STATUS VARCHAR2 (1)
Status
CREATED_BY NUMBER (15) Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes 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
,      OBJECT_VERSION_NUMBER
,      CAT_ID1
,      CAT_ID2
,      NAME
,      TERM_IN_MONTHS
,      RESIDUAL_VALUE_PERCENT
,      ITEM_RESIDUAL_ID
,      STS_CODE
,      VERSION_NUMBER
,      START_DATE
,      END_DATE
,      STATUS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM APPS.OKL_ITM_CAT_RV_PRCS_UV;

Dependencies

[top of page]

APPS.OKL_ITM_CAT_RV_PRCS_UV references the following:

SchemaAPPS
SynonymOKL_ITM_CAT_RV_PRCS
ViewOKL_SYSTEM_ITEMS_UV

APPS.OKL_ITM_CAT_RV_PRCS_UV is not referenced by any database object