View: JTF_RS_GRP_DENORM_VL

Product:	JTF - CRM Foundation
Description:	This view has the denorm records for all groups
Implementation/DBA Data:	APPS.JTF_RS_GRP_DENORM_VL

View Text

SELECT GD.GROUP_ID
, GD.PARENT_GROUP_ID
, GD.LAST_UPDATE_DATE
, GD.LAST_UPDATED_BY
, GD.CREATION_DATE
, GD.CREATED_BY
, GD.LAST_UPDATE_LOGIN
, GD.IMMEDIATE_PARENT_FLAG
, GD.ATTRIBUTE_CATEGORY
, GD.ATTRIBUTE1
, GD.ATTRIBUTE2
, GD.ATTRIBUTE3
, GD.ATTRIBUTE4
, GD.ATTRIBUTE5
, GD.ATTRIBUTE6
, GD.ATTRIBUTE7
, GD.ATTRIBUTE8
, GD.ATTRIBUTE9
, GD.ATTRIBUTE10
, GD.ATTRIBUTE11
, GD.ATTRIBUTE12
, GD.ATTRIBUTE13
, GD.ATTRIBUTE14
, GD.ATTRIBUTE15
, GD.START_DATE_ACTIVE
, GD.END_DATE_ACTIVE
, GD.DENORM_LEVEL
, CD.GROUP_NAME GROUP_NAME
, PT.GROUP_NAME PARENT_GROUP_NAME
FROM JTF_RS_GROUPS_DENORM GD
, JTF_RS_GROUPS_TL CD
, JTF_RS_GROUPS_TL PT
WHERE PT.GROUP_ID = GD.PARENT_GROUP_ID
AND CD.GROUP_ID = GD.GROUP_ID
AND CD.LANGUAGE = USERENV('LANG')
AND PT.LANGUAGE = USERENV('LANG')

Columns