[Home] [Help]
View: JTF_RS_GRP_HIER_V
Product: | JTF - CRM Foundation |
Description: | This view is used for defining the Meta data for the 'Groups' spreadtable in Group Hierarchy Form. |
Implementation/DBA Data: |
APPS.JTF_RS_GRP_HIER_V
|
View Text
SELECT DISTINCT(REP.GROUP_ID) GROUP_ID
, REP.PARENT_RESOURCE_ID
, GRP.GROUP_NUMBER
, GRP.GROUP_NAME
, GRP.GROUP_DESC
, GRP.START_DATE_ACTIVE
, GRP.END_DATE_ACTIVE
FROM JTF_RS_REP_MANAGERS REP
, JTF_RS_GROUPS_VL GRP
WHERE REP.GROUP_ID = GRP.GROUP_ID
Columns
Name |
GROUP_ID |
PARENT_RESOURCE_ID |
GROUP_NUMBER |
GROUP_NAME |
GROUP_DESC |
START_DATE_ACTIVE |
END_DATE_ACTIVE |