[Home] [Help]
| Product: | OKL - Leasing and Finance Management |
|---|---|
| Description: | View for table OKL_CLCT_ROL_B |
| Implementation/DBA Data: | Not implemented in this database |
SELECT CLRB.ROWID ROW_ID
, CLRB.ID ID
, CLRB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CLRT.SFWT_FLAG SFWT_FLAG
, CLRT.NAME NAME
, CLRT.DESCRIPTION DESCRIPTION
, CLRB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, CLRB.ATTRIBUTE1 ATTRIBUTE1
, CLRB.ATTRIBUTE2 ATTRIBUTE2
, CLRB.ATTRIBUTE3 ATTRIBUTE3
, CLRB.ATTRIBUTE4 ATTRIBUTE4
, CLRB.ATTRIBUTE5 ATTRIBUTE5
, CLRB.ATTRIBUTE6 ATTRIBUTE6
, CLRB.ATTRIBUTE7 ATTRIBUTE7
, CLRB.ATTRIBUTE8 ATTRIBUTE8
, CLRB.ATTRIBUTE9 ATTRIBUTE9
, CLRB.ATTRIBUTE10 ATTRIBUTE10
, CLRB.ATTRIBUTE11 ATTRIBUTE11
, CLRB.ATTRIBUTE12 ATTRIBUTE12
, CLRB.ATTRIBUTE13 ATTRIBUTE13
, CLRB.ATTRIBUTE14 ATTRIBUTE14
, CLRB.ATTRIBUTE15 ATTRIBUTE15
, CLRB.REQUEST_ID REQUEST_ID
, CLRB.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, CLRB.PROGRAM_ID PROGRAM_ID
, CLRB.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, CLRB.CREATED_BY CREATED_BY
, CLRB.CREATION_DATE CREATION_DATE
, CLRB.LAST_UPDATED_BY LAST_UPDATED_BY
, CLRB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CLRB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM ZOKL_CLCT_ROLES_B CLRB
, ZOKL_CLCT_ROLES_TL CLRT
WHERE CLRB.ID = CLRT.ID
AND CLRT.LANGUAGE = USERENV('LANG')