Product: | PER - Human Resources |
---|---|
Description: | multi lingual view of organizations |
Implementation/DBA Data: | APPS.HR_ALL_ORGANIZATION_UNITS_VL |
SELECT HAO.ORGANIZATION_ID
, HAO.ROWID
, HAO.BUSINESS_GROUP_ID
, HAO.COST_ALLOCATION_KEYFLEX_ID
, HAO.LOCATION_ID
, HAO.SOFT_CODING_KEYFLEX_ID
, HAO.DATE_FROM
, HAOTL.NAME
, HAO.COMMENTS
, HAO.DATE_TO
, HAO.INTERNAL_EXTERNAL_FLAG
, HAO.INTERNAL_ADDRESS_LINE
, HAO.TYPE
, HAO.REQUEST_ID
, HAO.PROGRAM_APPLICATION_ID
, HAO.PROGRAM_ID
, HAO.PROGRAM_UPDATE_DATE
, HAO.ATTRIBUTE_CATEGORY
, HAO.ATTRIBUTE1
, HAO.ATTRIBUTE2
, HAO.ATTRIBUTE3
, HAO.ATTRIBUTE4
, HAO.ATTRIBUTE5
, HAO.ATTRIBUTE6
, HAO.ATTRIBUTE7
, HAO.ATTRIBUTE8
, HAO.ATTRIBUTE9
, HAO.ATTRIBUTE10
, HAO.ATTRIBUTE11
, HAO.ATTRIBUTE12
, HAO.ATTRIBUTE13
, HAO.ATTRIBUTE14
, HAO.ATTRIBUTE15
, HAO.ATTRIBUTE16
, HAO.ATTRIBUTE17
, HAO.ATTRIBUTE18
, HAO.ATTRIBUTE19
, HAO.ATTRIBUTE20
, HAO.LAST_UPDATE_DATE
, HAO.LAST_UPDATED_BY
, HAO.LAST_UPDATE_LOGIN
, HAO.CREATED_BY
, HAO.CREATION_DATE
FROM HR_ALL_ORGANIZATION_UNITS HAO
, HR_ALL_ORGANIZATION_UNITS_TL HAOTL
WHERE HAO.ORGANIZATION_ID = HAOTL.ORGANIZATION_ID
AND HAOTL.LANGUAGE = USERENV('LANG')