DBA Data[Home] [Help]

VIEW: HR.PER_SECURITY_ORGANIZATIONS#

Source

View Text - Preformatted

select SECURITY_ORGANIZATION_ID SECURITY_ORGANIZATION_ID, ORGANIZATION_ID ORGANIZATION_ID, SECURITY_PROFILE_ID SECURITY_PROFILE_ID, ENTRY_TYPE ENTRY_TYPE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER from "HR"."PER_SECURITY_ORGANIZATIONS"
View Text - HTML Formatted

SELECT SECURITY_ORGANIZATION_ID SECURITY_ORGANIZATION_ID
, ORGANIZATION_ID ORGANIZATION_ID
, SECURITY_PROFILE_ID SECURITY_PROFILE_ID
, ENTRY_TYPE ENTRY_TYPE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
FROM "HR"."PER_SECURITY_ORGANIZATIONS"