FND Design Data [Home] [Help]

View: OKL_CRTRN_USER_VALS_V

Product: OKL - Lease and Finance Management
Description: A list of user defined values for a user defined criterion
Implementation/DBA Data: ViewAPPS.OKL_CRTRN_USER_VALS_V
View Text

SELECT CUVB.ROWID ROW_ID
, CUVB.ID ID
, CUVB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CUVT.SFWT_FLAG SFWT_FLAG
, CUVB.CRN_ID CRN_ID
, CUVB.SEQUENCE_NUMBER SEQUENCE_NUMBER
, CUVB.VALUE VALUE
, CUVT.DESCRIPTION DESCRIPTION
, CUVB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, CUVB.ATTRIBUTE1 ATTRIBUTE1
, CUVB.ATTRIBUTE2 ATTRIBUTE2
, CUVB.ATTRIBUTE3 ATTRIBUTE3
, CUVB.ATTRIBUTE4 ATTRIBUTE4
, CUVB.ATTRIBUTE5 ATTRIBUTE5
, CUVB.ATTRIBUTE6 ATTRIBUTE6
, CUVB.ATTRIBUTE7 ATTRIBUTE7
, CUVB.ATTRIBUTE8 ATTRIBUTE8
, CUVB.ATTRIBUTE9 ATTRIBUTE9
, CUVB.ATTRIBUTE10 ATTRIBUTE10
, CUVB.ATTRIBUTE11 ATTRIBUTE11
, CUVB.ATTRIBUTE12 ATTRIBUTE12
, CUVB.ATTRIBUTE13 ATTRIBUTE13
, CUVB.ATTRIBUTE14 ATTRIBUTE14
, CUVB.ATTRIBUTE15 ATTRIBUTE15
, CUVB.CREATED_BY CREATED_BY
, CUVB.CREATION_DATE CREATION_DATE
, CUVB.LAST_UPDATED_BY LAST_UPDATED_BY
, CUVB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CUVB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM OKL_CRTRN_USER_VALS_B CUVB
, OKL_CRTRN_USER_VALS_TL CUVT
WHERE CUVB.ID = CUVT.ID
AND CUVT.LANGUAGE = USERENV('LANG')

Columns

Name
ROW_ID
ID
OBJECT_VERSION_NUMBER
SFWT_FLAG
CRN_ID
SEQUENCE_NUMBER
VALUE
DESCRIPTION
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN