VIEW: APPS.JTF_RS_GRP_DENORM_VL

Source

View Text - Preformatted

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

View Text - HTML Formatted

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