VIEW: APPS.JTF_RS_DEFRESROLES_VL

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'