eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.PER_SHARED_TYPES_VL

Source

View Text - Preformatted


SELECT sht.rowid row_id , SHT.SHARED_TYPE_ID SHARED_TYPE_ID , SHT.BUSINESS_GROUP_ID BUSINESS_GROUP_ID , SHT.LOOKUP_TYPE LOOKUP_TYPE , SHT.SYSTEM_TYPE_CD SYSTEM_TYPE_CD , STT.SHARED_TYPE_NAME SHARED_TYPE_NAME , SHT.INFORMATION1 INFORMATION1 , SHT.INFORMATION2 INFORMATION2 , SHT.INFORMATION3 INFORMATION3 , SHT.INFORMATION4 INFORMATION4 , SHT.INFORMATION5 INFORMATION5 , SHT.INFORMATION6 INFORMATION6 , SHT.INFORMATION7 INFORMATION7 , SHT.INFORMATION8 INFORMATION8 , SHT.INFORMATION9 INFORMATION9 , SHT.INFORMATION10 INFORMATION10 , SHT.INFORMATION11 INFORMATION11 , SHT.INFORMATION12 INFORMATION12 , SHT.INFORMATION13 INFORMATION13 , SHT.INFORMATION14 INFORMATION14 , SHT.INFORMATION15 INFORMATION15 , SHT.INFORMATION16 INFORMATION16 , SHT.INFORMATION17 INFORMATION17 , SHT.INFORMATION18 INFORMATION18 , SHT.INFORMATION19 INFORMATION19 , SHT.INFORMATION20 INFORMATION20 , SHT.INFORMATION21 INFORMATION21 , SHT.INFORMATION22 INFORMATION22 , SHT.INFORMATION23 INFORMATION23 , SHT.INFORMATION24 INFORMATION24 , SHT.INFORMATION25 INFORMATION25 , SHT.INFORMATION26 INFORMATION26 , SHT.INFORMATION27 INFORMATION27 , SHT.INFORMATION28 INFORMATION28 , SHT.INFORMATION29 INFORMATION29 , SHT.INFORMATION30 INFORMATION30 , SHT.INFORMATION_CATEGORY INFORMATION_CATEGORY , SHT.LAST_UPDATE_DATE LAST_UPDATE_DATE , SHT.LAST_UPDATED_BY LAST_UPDATED_BY , SHT.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN , SHT.CREATED_BY CREATED_BY , SHT.CREATION_DATE CREATION_DATE , SHT.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER ,SHT.SHARED_TYPE_CODE shared_type_code from per_shared_types sht , per_shared_types_tl stt WHERE sht.shared_type_id = stt.shared_type_id and stt.language = userenv('LANG')

View Text - HTML Formatted

SELECT SHT.ROWID ROW_ID
, SHT.SHARED_TYPE_ID SHARED_TYPE_ID
, SHT.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, SHT.LOOKUP_TYPE LOOKUP_TYPE
, SHT.SYSTEM_TYPE_CD SYSTEM_TYPE_CD
, STT.SHARED_TYPE_NAME SHARED_TYPE_NAME
, SHT.INFORMATION1 INFORMATION1
, SHT.INFORMATION2 INFORMATION2
, SHT.INFORMATION3 INFORMATION3
, SHT.INFORMATION4 INFORMATION4
, SHT.INFORMATION5 INFORMATION5
, SHT.INFORMATION6 INFORMATION6
, SHT.INFORMATION7 INFORMATION7
, SHT.INFORMATION8 INFORMATION8
, SHT.INFORMATION9 INFORMATION9
, SHT.INFORMATION10 INFORMATION10
, SHT.INFORMATION11 INFORMATION11
, SHT.INFORMATION12 INFORMATION12
, SHT.INFORMATION13 INFORMATION13
, SHT.INFORMATION14 INFORMATION14
, SHT.INFORMATION15 INFORMATION15
, SHT.INFORMATION16 INFORMATION16
, SHT.INFORMATION17 INFORMATION17
, SHT.INFORMATION18 INFORMATION18
, SHT.INFORMATION19 INFORMATION19
, SHT.INFORMATION20 INFORMATION20
, SHT.INFORMATION21 INFORMATION21
, SHT.INFORMATION22 INFORMATION22
, SHT.INFORMATION23 INFORMATION23
, SHT.INFORMATION24 INFORMATION24
, SHT.INFORMATION25 INFORMATION25
, SHT.INFORMATION26 INFORMATION26
, SHT.INFORMATION27 INFORMATION27
, SHT.INFORMATION28 INFORMATION28
, SHT.INFORMATION29 INFORMATION29
, SHT.INFORMATION30 INFORMATION30
, SHT.INFORMATION_CATEGORY INFORMATION_CATEGORY
, SHT.LAST_UPDATE_DATE LAST_UPDATE_DATE
, SHT.LAST_UPDATED_BY LAST_UPDATED_BY
, SHT.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, SHT.CREATED_BY CREATED_BY
, SHT.CREATION_DATE CREATION_DATE
, SHT.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, SHT.SHARED_TYPE_CODE SHARED_TYPE_CODE
FROM PER_SHARED_TYPES SHT
, PER_SHARED_TYPES_TL STT
WHERE SHT.SHARED_TYPE_ID = STT.SHARED_TYPE_ID
AND STT.LANGUAGE = USERENV('LANG')