FND Design Data [Home] [Help]

View: JTF_RS_DEFRESROLES_VL

Product: JTF - CRM Foundation
Description: This view is used by Define Resource Form roles,gmbr_roles,tmbr_roles block
Implementation/DBA Data: ViewAPPS.JTF_RS_DEFRESROLES_VL
View Text

SELECT RR.ROLE_RELATE_ID
, RR.ROLE_RESOURCE_ID
, RR.ROLE_ID
, RR.ROLE_RESOURCE_TYPE
, RR.CREATED_BY
, RR.CREATION_DATE
, RR.LAST_UPDATED_BY
, RR.LAST_UPDATE_DATE
, RR.LAST_UPDATE_LOGIN
, RR.ATTRIBUTE1
, RR.ATTRIBUTE2
, RR.ATTRIBUTE3
, RR.ATTRIBUTE4
, RR.ATTRIBUTE5
, RR.ATTRIBUTE6
, RR.ATTRIBUTE7
, RR.ATTRIBUTE8
, RR.ATTRIBUTE9
, RR.ATTRIBUTE10
, RR.ATTRIBUTE11
, RR.ATTRIBUTE12
, RR.ATTRIBUTE13
, RR.ATTRIBUTE14
, RR.ATTRIBUTE15
, RR.ATTRIBUTE_CATEGORY
, RL.ROLE_TYPE_CODE
, LKP.MEANING ROLE_TYPE_NAME
, RL.ROLE_NAME
, RL. MEMBER_FLAG
, RL. ADMIN_FLAG
, RL. LEAD_FLAG
, RL. MANAGER_FLAG
, RR.START_DATE_ACTIVE RES_RL_START_DATE
, RR.END_DATE_ACTIVE RES_RL_END_DATE
, RR.DELETE_FLAG
, RR.OBJECT_VERSION_NUMBER
FROM JTF_RS_ROLE_RELATIONS RR
, JTF_RS_ROLES_VL RL
, FND_LOOKUPS LKP
WHERE RR.ROLE_ID = RL.ROLE_ID
AND RL.ROLE_TYPE_CODE = LKP.LOOKUP_CODE
AND LKP.LOOKUP_TYPE = 'JTF_RS_ROLE_TYPE'

Columns

Name
ROLE_RELATE_ID
ROLE_RESOURCE_ID
ROLE_ID
ROLE_RESOURCE_TYPE
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
ATTRIBUTE_CATEGORY
ROLE_TYPE_CODE
ROLE_TYPE_NAME
ROLE_NAME
MEMBER_FLAG
ADMIN_FLAG
LEAD_FLAG
MANAGER_FLAG
RES_RL_START_DATE
RES_RL_END_DATE
DELETE_FLAG
OBJECT_VERSION_NUMBER