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.

[Home] [Help]

VIEW: HR.PER_SHARED_TYPES#

Source

View Text - Preformatted


select SHARED_TYPE_ID SHARED_TYPE_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, SHARED_TYPE_NAME SHARED_TYPE_NAME, LOOKUP_TYPE LOOKUP_TYPE, SYSTEM_TYPE_CD SYSTEM_TYPE_CD, INFORMATION1 INFORMATION1, INFORMATION2 INFORMATION2, INFORMATION3 INFORMATION3, INFORMATION4 INFORMATION4, INFORMATION5 INFORMATION5, INFORMATION6 INFORMATION6, INFORMATION7 INFORMATION7, INFORMATION8 INFORMATION8, INFORMATION9 INFORMATION9, INFORMATION10 INFORMATION10, INFORMATION11 INFORMATION11, INFORMATION12 INFORMATION12, INFORMATION13 INFORMATION13, INFORMATION14 INFORMATION14, INFORMATION15 INFORMATION15, INFORMATION16 INFORMATION16, INFORMATION17 INFORMATION17, INFORMATION18 INFORMATION18, INFORMATION19 INFORMATION19, INFORMATION20 INFORMATION20, INFORMATION21 INFORMATION21, INFORMATION22 INFORMATION22, INFORMATION23 INFORMATION23, INFORMATION24 INFORMATION24, INFORMATION25 INFORMATION25, INFORMATION26 INFORMATION26, INFORMATION27 INFORMATION27, INFORMATION28 INFORMATION28, INFORMATION29 INFORMATION29, INFORMATION30 INFORMATION30, INFORMATION_CATEGORY INFORMATION_CATEGORY, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, SHARED_TYPE_CODE SHARED_TYPE_CODE, ZD_EDITION_NAME ZD_EDITION_NAME from "HR"."PER_SHARED_TYPES"

View Text - HTML Formatted

SELECT SHARED_TYPE_ID SHARED_TYPE_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, SHARED_TYPE_NAME SHARED_TYPE_NAME
, LOOKUP_TYPE LOOKUP_TYPE
, SYSTEM_TYPE_CD SYSTEM_TYPE_CD
, INFORMATION1 INFORMATION1
, INFORMATION2 INFORMATION2
, INFORMATION3 INFORMATION3
, INFORMATION4 INFORMATION4
, INFORMATION5 INFORMATION5
, INFORMATION6 INFORMATION6
, INFORMATION7 INFORMATION7
, INFORMATION8 INFORMATION8
, INFORMATION9 INFORMATION9
, INFORMATION10 INFORMATION10
, INFORMATION11 INFORMATION11
, INFORMATION12 INFORMATION12
, INFORMATION13 INFORMATION13
, INFORMATION14 INFORMATION14
, INFORMATION15 INFORMATION15
, INFORMATION16 INFORMATION16
, INFORMATION17 INFORMATION17
, INFORMATION18 INFORMATION18
, INFORMATION19 INFORMATION19
, INFORMATION20 INFORMATION20
, INFORMATION21 INFORMATION21
, INFORMATION22 INFORMATION22
, INFORMATION23 INFORMATION23
, INFORMATION24 INFORMATION24
, INFORMATION25 INFORMATION25
, INFORMATION26 INFORMATION26
, INFORMATION27 INFORMATION27
, INFORMATION28 INFORMATION28
, INFORMATION29 INFORMATION29
, INFORMATION30 INFORMATION30
, INFORMATION_CATEGORY INFORMATION_CATEGORY
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, SHARED_TYPE_CODE SHARED_TYPE_CODE
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "HR"."PER_SHARED_TYPES"