View: JTF_RS_GRP_HIER_MEM_V

Product:	JTF - CRM Foundation
Description:	This view is used for defining the Meta data for the 'Members' spreadtable in Group Hierarchy Form.
Implementation/DBA Data:	APPS.JTF_RS_GRP_HIER_MEM_V

View Text

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')

Columns