VIEW: APPS.JTF_RS_GROUP_ORGS_V

Source

View Text - Preformatted

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

   

View Text - HTML Formatted

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