Product: | PER - Human Resources |
---|---|
Description: | Used to support user-interface. |
Implementation/DBA Data: | APPS.PER_SHARED_TYPES_VL |
SELECT SHT.ROWID ROW_ID
, SHT.SHARED_TYPE_ID
, SHT.BUSINESS_GROUP_ID
, SHT.LOOKUP_TYPE
, SHT.SYSTEM_TYPE_CD
, STT.SHARED_TYPE_NAME
, SHT.INFORMATION1
, SHT.INFORMATION2
, SHT.INFORMATION3
, SHT.INFORMATION4
, SHT.INFORMATION5
, SHT.INFORMATION6
, SHT.INFORMATION7
, SHT.INFORMATION8
, SHT.INFORMATION9
, SHT.INFORMATION10
, SHT.INFORMATION11
, SHT.INFORMATION12
, SHT.INFORMATION13
, SHT.INFORMATION14
, SHT.INFORMATION15
, SHT.INFORMATION16
, SHT.INFORMATION17
, SHT.INFORMATION18
, SHT.INFORMATION19
, SHT.INFORMATION20
, SHT.INFORMATION21
, SHT.INFORMATION22
, SHT.INFORMATION23
, SHT.INFORMATION24
, SHT.INFORMATION25
, SHT.INFORMATION26
, SHT.INFORMATION27
, SHT.INFORMATION28
, SHT.INFORMATION29
, SHT.INFORMATION30
, SHT.INFORMATION_CATEGORY
, SHT.LAST_UPDATE_DATE
, SHT.LAST_UPDATED_BY
, SHT.LAST_UPDATE_LOGIN
, SHT.CREATED_BY
, SHT.CREATION_DATE
, SHT.OBJECT_VERSION_NUMBER
FROM PER_SHARED_TYPES SHT
, PER_SHARED_TYPES_TL STT
WHERE SHT.SHARED_TYPE_ID = STT.SHARED_TYPE_ID
AND STT.LANGUAGE = USERENV('LANG')