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