VIEW: APPS.JTF_RS_ROLE_RELATIONS_VL

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'