[Home] [Help]
View: JTF_RS_GROUP_ORGS_V
View Text
SELECT GO.ROWID ROW_ID
,
GO.ATTRIBUTE1
,
GO.ATTRIBUTE2
,
GO.ATTRIBUTE3
,
GO.ATTRIBUTE4
,
GO.ATTRIBUTE5
,
GO.ATTRIBUTE6
,
GO.ATTRIBUTE7
,
GO.ATTRIBUTE8
,
GO.ATTRIBUTE9
,
GO.ATTRIBUTE10
,
GO.ATTRIBUTE11
,
GO.ATTRIBUTE12
,
GO.ATTRIBUTE13
,
GO.ATTRIBUTE14
,
GO.ATTRIBUTE15
,
GO.ATTRIBUTE_CATEGORY
,
GO.GROUP_ID
,
GO.ORGANIZATION_ID
,
GO.CREATED_BY
,
GO.CREATION_DATE
,
GO.LAST_UPDATED_BY
,
GO.LAST_UPDATE_DATE
,
GO.LAST_UPDATE_LOGIN
,
GO.OBJECT_VERSION_NUMBER
,
GTL.GROUP_NAME
,
GTL.GROUP_DESC
,
OTL.NAME ORGANIZATION_NAME
FROM JTF_RS_GROUP_ORGANIZATIONS GO
,
JTF_RS_GROUPS_TL GTL
,
HR_ALL_ORGANIZATION_UNITS_TL OTL
WHERE GO.GROUP_ID = GTL.GROUP_ID
AND GO.ORGANIZATION_ID = OTL.ORGANIZATION_ID
AND OTL.LANGUAGE = USERENV('LANG')
AND GTL.LANGUAGE = USERENV('LANG')