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_ENTERPRISES#

Source

View Text - Preformatted


select ENTERPRISE_ID ENTERPRISE_ID, ENTERPRISE_SHORT_CODE ENTERPRISE_SHORT_CODE, ENTERPRISE_LABEL ENTERPRISE_LABEL, ENABLED_FLAG ENABLED_FLAG, ENT_INFORMATION_CATEGORY ENT_INFORMATION_CATEGORY, ENT_INFORMATION1 ENT_INFORMATION1, ENT_INFORMATION2 ENT_INFORMATION2, ENT_INFORMATION3 ENT_INFORMATION3, ENT_INFORMATION4 ENT_INFORMATION4, ENT_INFORMATION5 ENT_INFORMATION5, ENT_INFORMATION6 ENT_INFORMATION6, ENT_INFORMATION7 ENT_INFORMATION7, ENT_INFORMATION8 ENT_INFORMATION8, ENT_INFORMATION9 ENT_INFORMATION9, ENT_INFORMATION10 ENT_INFORMATION10, ENT_INFORMATION11 ENT_INFORMATION11, ENT_INFORMATION12 ENT_INFORMATION12, ENT_INFORMATION13 ENT_INFORMATION13, ENT_INFORMATION14 ENT_INFORMATION14, ENT_INFORMATION15 ENT_INFORMATION15, ENT_INFORMATION16 ENT_INFORMATION16, ENT_INFORMATION17 ENT_INFORMATION17, ENT_INFORMATION18 ENT_INFORMATION18, ENT_INFORMATION19 ENT_INFORMATION19, ENT_INFORMATION20 ENT_INFORMATION20, ENT_INFORMATION21 ENT_INFORMATION21, ENT_INFORMATION22 ENT_INFORMATION22, ENT_INFORMATION23 ENT_INFORMATION23, ENT_INFORMATION24 ENT_INFORMATION24, ENT_INFORMATION25 ENT_INFORMATION25, ENT_INFORMATION26 ENT_INFORMATION26, ENT_INFORMATION27 ENT_INFORMATION27, ENT_INFORMATION28 ENT_INFORMATION28, ENT_INFORMATION29 ENT_INFORMATION29, ENT_INFORMATION30 ENT_INFORMATION30, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN from "HR"."PER_ENTERPRISES"

View Text - HTML Formatted

SELECT ENTERPRISE_ID ENTERPRISE_ID
, ENTERPRISE_SHORT_CODE ENTERPRISE_SHORT_CODE
, ENTERPRISE_LABEL ENTERPRISE_LABEL
, ENABLED_FLAG ENABLED_FLAG
, ENT_INFORMATION_CATEGORY ENT_INFORMATION_CATEGORY
, ENT_INFORMATION1 ENT_INFORMATION1
, ENT_INFORMATION2 ENT_INFORMATION2
, ENT_INFORMATION3 ENT_INFORMATION3
, ENT_INFORMATION4 ENT_INFORMATION4
, ENT_INFORMATION5 ENT_INFORMATION5
, ENT_INFORMATION6 ENT_INFORMATION6
, ENT_INFORMATION7 ENT_INFORMATION7
, ENT_INFORMATION8 ENT_INFORMATION8
, ENT_INFORMATION9 ENT_INFORMATION9
, ENT_INFORMATION10 ENT_INFORMATION10
, ENT_INFORMATION11 ENT_INFORMATION11
, ENT_INFORMATION12 ENT_INFORMATION12
, ENT_INFORMATION13 ENT_INFORMATION13
, ENT_INFORMATION14 ENT_INFORMATION14
, ENT_INFORMATION15 ENT_INFORMATION15
, ENT_INFORMATION16 ENT_INFORMATION16
, ENT_INFORMATION17 ENT_INFORMATION17
, ENT_INFORMATION18 ENT_INFORMATION18
, ENT_INFORMATION19 ENT_INFORMATION19
, ENT_INFORMATION20 ENT_INFORMATION20
, ENT_INFORMATION21 ENT_INFORMATION21
, ENT_INFORMATION22 ENT_INFORMATION22
, ENT_INFORMATION23 ENT_INFORMATION23
, ENT_INFORMATION24 ENT_INFORMATION24
, ENT_INFORMATION25 ENT_INFORMATION25
, ENT_INFORMATION26 ENT_INFORMATION26
, ENT_INFORMATION27 ENT_INFORMATION27
, ENT_INFORMATION28 ENT_INFORMATION28
, ENT_INFORMATION29 ENT_INFORMATION29
, ENT_INFORMATION30 ENT_INFORMATION30
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM "HR"."PER_ENTERPRISES"