VIEW: APPS.JTF_RS_GRP_HIER_MEM_V

Source

View Text - Preformatted

SELECT distinct res.resource_name ,rol.role_name ,rep.start_date_active ,rep.end_date_active ,rep.category ,rep.reports_to_flag ,rep.parent_resource_id ,rep.group_id ,rep.resource_id FROM jtf_rs_role_relations_vl rol ,jtf_rs_resource_extns_tl res ,jtf_rs_rep_managers rep WHERE rep.resource_id = res.resource_id AND rep.child_role_relate_id = rol.role_relate_id AND res.language = userenv('LANG')

View Text - HTML Formatted

SELECT DISTINCT RES.RESOURCE_NAME
, ROL.ROLE_NAME
, REP.START_DATE_ACTIVE
, REP.END_DATE_ACTIVE
, REP.CATEGORY
, REP.REPORTS_TO_FLAG
, REP.PARENT_RESOURCE_ID
, REP.GROUP_ID
, REP.RESOURCE_ID
FROM JTF_RS_ROLE_RELATIONS_VL ROL
, JTF_RS_RESOURCE_EXTNS_TL RES
, JTF_RS_REP_MANAGERS REP
WHERE REP.RESOURCE_ID = RES.RESOURCE_ID
AND REP.CHILD_ROLE_RELATE_ID = ROL.ROLE_RELATE_ID
AND RES.LANGUAGE = USERENV('LANG')