View: JTF_RS_ROLE_RELATIONS_VL

Product:	JTF - CRM Foundation
Description:	This view shows the listing of details of roles attached to resource.
Implementation/DBA Data:	APPS.JTF_RS_ROLE_RELATIONS_VL

View Text

SELECT RRT.ROLE_RELATE_ID
, RRT.ROLE_RESOURCE_TYPE
, RRT.ROLE_RESOURCE_ID
, RRT.ROLE_ID
, RRT.START_DATE_ACTIVE
, RRT.END_DATE_ACTIVE
, ROL.ROLE_NAME
, ROL. MEMBER_FLAG
, ROL.ADMIN_FLAG
, ROL.LEAD_FLAG
, ROL.MANAGER_FLAG
, ROL.ROLE_TYPE_CODE
, FND.MEANING
, ROL.ROLE_CODE
FROM JTF_RS_ROLE_RELATIONS RRT
, JTF_RS_ROLES_VL ROL
, FND_LOOKUPS FND
WHERE NVL(RRT.DELETE_FLAG
, 'N') <> 'Y'
AND RRT.ROLE_ID = ROL.ROLE_ID
AND ROL.ROLE_TYPE_CODE = FND.LOOKUP_CODE
AND FND.LOOKUP_TYPE = 'JTF_RS_ROLE_TYPE'

Columns