View: JTF_RS_ROLE_DETAILS_VL

Product:	JTF - CRM Foundation
Description:	This View shows Roles and its details like Role type, Role name, etc.
Implementation/DBA Data:	APPS.JTF_RS_ROLE_DETAILS_VL

View Text

SELECT R.ROW_ID ROW_ID
, R.ROLE_ID ROLE_ID
, R.ROLE_CODE ROLE_CODE
, R.ROLE_NAME ROLE_NAME
, R.ROLE_TYPE_CODE ROLE_TYPE_CODE
, R.ACTIVE_FLAG ACTIVE_FLAG
, R.SEEDED_FLAG SEEDED_FLAG
, R.ROLE_DESC ROLE_DESC
, R.MEMBER_FLAG MEMBER_FLAG
, R.ADMIN_FLAG ADMIN_FLAG
, R.LEAD_FLAG LEAD_FLAG
, R.MANAGER_FLAG MANAGER_FLAG
, R.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, R.ATTRIBUTE1 ATTRIBUTE1
, R.ATTRIBUTE2 ATTRIBUTE2
, R.ATTRIBUTE3 ATTRIBUTE3
, R.ATTRIBUTE4 ATTRIBUTE4
, R.ATTRIBUTE5 ATTRIBUTE5
, R.ATTRIBUTE6 ATTRIBUTE6
, R.ATTRIBUTE7 ATTRIBUTE7
, R.ATTRIBUTE8 ATTRIBUTE8
, R.ATTRIBUTE9 ATTRIBUTE9
, R.ATTRIBUTE10 ATTRIBUTE10
, R.ATTRIBUTE11 ATTRIBUTE11
, R.ATTRIBUTE12 ATTRIBUTE12
, R.ATTRIBUTE13 ATTRIBUTE13
, R.ATTRIBUTE14 ATTRIBUTE14
, R.ATTRIBUTE15 ATTRIBUTE15
, R.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, R.CREATED_BY CREATED_BY
, R.CREATION_DATE CREATION_DATE
, R.LAST_UPDATED_BY LAST_UPDATED_BY
, R.LAST_UPDATE_DATE LAST_UPDATE_DATE
, R.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, F.MEANING ROLE_TYPE
FROM JTF_RS_ROLES_VL R
, FND_LOOKUPS F
WHERE R.ROLE_TYPE_CODE = F.LOOKUP_CODE
AND F.LOOKUP_TYPE = 'JTF_RS_ROLE_TYPE'
AND F.ENABLED_FLAG = 'Y'

Columns