DBA Data[Home] [Help]

VIEW: HR.PER_INFO_TYPE_SECURITY#

Source

View Text - Preformatted

select PER_INFO_TYPE_SECURITY_ID PER_INFO_TYPE_SECURITY_ID, APPLICATION_ID APPLICATION_ID, RESPONSIBILITY_ID RESPONSIBILITY_ID, INFO_TYPE_TABLE_NAME INFO_TYPE_TABLE_NAME, INFORMATION_TYPE INFORMATION_TYPE, 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, ZD_EDITION_NAME ZD_EDITION_NAME from "HR"."PER_INFO_TYPE_SECURITY"
View Text - HTML Formatted

SELECT PER_INFO_TYPE_SECURITY_ID PER_INFO_TYPE_SECURITY_ID
, APPLICATION_ID APPLICATION_ID
, RESPONSIBILITY_ID RESPONSIBILITY_ID
, INFO_TYPE_TABLE_NAME INFO_TYPE_TABLE_NAME
, INFORMATION_TYPE INFORMATION_TYPE
, 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
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "HR"."PER_INFO_TYPE_SECURITY"