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

VIEW: APPS.OKL_LS_RT_FCTR_SETS_UV

Object Details
Object Name: OKL_LS_RT_FCTR_SETS_UV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKL.OKL_LS_RT_FCTR_SETS_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
SFWT_FLAG VARCHAR2 (3) Yes Column used by the translation batch program
TRY_ID NUMBER

Foreign key to view OKL_TRX_TYPES_V
PDT_ID NUMBER

Foreign key to view OKL_PRODUCTS_V
FRQ_CODE VARCHAR2 (30) Yes
FREQUENCY VARCHAR2 (80) Yes
ARREARS_YN VARCHAR2 (3) Yes Yes or No
ARREARS VARCHAR2 (80) Yes
START_DATE DATE

Start Date
END_DATE DATE

End Date
NAME VARCHAR2 (150)
Name
DESCRIPTION VARCHAR2 (1995)
User entered description
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
STS_CODE VARCHAR2 (30)
Status Code
ORG_ID NUMBER

Organization Id
CURRENCY_CODE VARCHAR2 (15)
Currency Code
LRS_TYPE_CODE VARCHAR2 (30)
Lease Rate Set Type
END_OF_TERM_ID NUMBER

End of Term Option identifier
ORIG_RATE_SET_ID NUMBER

Lease Rate Set Identifier from which this Lease Rate Set is duplicated
Query Text

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


SELECT ID
,      OBJECT_VERSION_NUMBER
,      SFWT_FLAG
,      TRY_ID
,      PDT_ID
,      FRQ_CODE
,      FREQUENCY
,      ARREARS_YN
,      ARREARS
,      START_DATE
,      END_DATE
,      NAME
,      DESCRIPTION
,      STATUS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      STS_CODE
,      ORG_ID
,      CURRENCY_CODE
,      LRS_TYPE_CODE
,      END_OF_TERM_ID
,      ORIG_RATE_SET_ID
FROM APPS.OKL_LS_RT_FCTR_SETS_UV;

Dependencies

[top of page]

APPS.OKL_LS_RT_FCTR_SETS_UV references the following:

SchemaAPPS
PL/SQL PackageFND_GLOBAL - show dependent code
ViewFND_LOOKUPS
SynonymOKL_LS_RT_FCTR_SETS_B
SynonymOKL_LS_RT_FCTR_SETS_TL

APPS.OKL_LS_RT_FCTR_SETS_UV is not referenced by any database object