FND Design Data [Home] [Help]

View: OKL_VALIDATION_SETS_V

Product: OKL - Lease and Finance Management
Description: View for OKL_VALIDATION_SETS_B and OKL_VALIDATION_SETS_TL
Implementation/DBA Data: ViewAPPS.OKL_VALIDATION_SETS_V
View Text

SELECT VLS.ROWID ROW_ID
, VLS.ID ID
, VLS.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, VLS.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, VLS.ATTRIBUTE1 ATTRIBUTE1
, VLS.ATTRIBUTE2 ATTRIBUTE2
, VLS.ATTRIBUTE3 ATTRIBUTE3
, VLS.ATTRIBUTE4 ATTRIBUTE4
, VLS.ATTRIBUTE5 ATTRIBUTE5
, VLS.ATTRIBUTE6 ATTRIBUTE6
, VLS.ATTRIBUTE7 ATTRIBUTE7
, VLS.ATTRIBUTE8 ATTRIBUTE8
, VLS.ATTRIBUTE9 ATTRIBUTE9
, VLS.ATTRIBUTE10 ATTRIBUTE10
, VLS.ATTRIBUTE11 ATTRIBUTE11
, VLS.ATTRIBUTE12 ATTRIBUTE12
, VLS.ATTRIBUTE13 ATTRIBUTE13
, VLS.ATTRIBUTE14 ATTRIBUTE14
, VLS.ATTRIBUTE15 ATTRIBUTE15
, VLS.CREATED_BY CREATED_BY
, VLS.CREATION_DATE CREATION_DATE
, VLS.LAST_UPDATED_BY LAST_UPDATED_BY
, VLS.LAST_UPDATE_DATE LAST_UPDATE_DATE
, VLS.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, VLS.ORG_ID ORG_ID
, VLS.VALIDATION_SET_NAME VALIDATION_SET_NAME
, VLS.EFFECTIVE_FROM EFFECTIVE_FROM
, VLS.EFFECTIVE_TO EFFECTIVE_TO
, VLST.SHORT_DESCRIPTION SHORT_DESCRIPTION
, VLST.DESCRIPTION DESCRIPTION
, VLST.COMMENTS COMMENTS
FROM OKL_VALIDATION_SETS_B VLS
, OKL_VALIDATION_SETS_TL VLST
WHERE VLS.ID = VLST.ID
AND VLST.LANGUAGE = USERENV('LANG')

Columns

Name
ROW_ID
ID
OBJECT_VERSION_NUMBER
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
ORG_ID
VALIDATION_SET_NAME
EFFECTIVE_FROM
EFFECTIVE_TO
SHORT_DESCRIPTION
DESCRIPTION
COMMENTS