[Home] [Help]
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
Name |
RESOURCE_NAME |
ROLE_NAME |
START_DATE_ACTIVE |
END_DATE_ACTIVE |
CATEGORY |
REPORTS_TO_FLAG |
PARENT_RESOURCE_ID |
GROUP_ID |
RESOURCE_ID |