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: HR.PER_SECURITY_PROFILES#

Source

View Text - Preformatted


select SECURITY_PROFILE_ID SECURITY_PROFILE_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, POSITION_ID POSITION_ID, ORGANIZATION_ID ORGANIZATION_ID, POSITION_STRUCTURE_ID POSITION_STRUCTURE_ID, ORGANIZATION_STRUCTURE_ID ORGANIZATION_STRUCTURE_ID, INCLUDE_TOP_ORGANIZATION_FLAG INCLUDE_TOP_ORGANIZATION_FLAG, INCLUDE_TOP_POSITION_FLAG INCLUDE_TOP_POSITION_FLAG, SECURITY_PROFILE_NAME SECURITY_PROFILE_NAME, VIEW_ALL_APPLICANTS_FLAG VIEW_ALL_APPLICANTS_FLAG, VIEW_ALL_EMPLOYEES_FLAG VIEW_ALL_EMPLOYEES_FLAG, VIEW_ALL_FLAG VIEW_ALL_FLAG, VIEW_ALL_ORGANIZATIONS_FLAG VIEW_ALL_ORGANIZATIONS_FLAG, VIEW_ALL_PAYROLLS_FLAG VIEW_ALL_PAYROLLS_FLAG, VIEW_ALL_POSITIONS_FLAG VIEW_ALL_POSITIONS_FLAG, INCLUDE_EXCLUDE_PAYROLL_FLAG INCLUDE_EXCLUDE_PAYROLL_FLAG, REPORTING_ORACLE_USERNAME REPORTING_ORACLE_USERNAME, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, 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, ALLOW_GRANTED_USERS_FLAG ALLOW_GRANTED_USERS_FLAG, RESTRICT_BY_SUPERVISOR_FLAG RESTRICT_BY_SUPERVISOR_FLAG, SUPERVISOR_LEVELS SUPERVISOR_LEVELS, EXCLUDE_SECONDARY_ASGS_FLAG EXCLUDE_SECONDARY_ASGS_FLAG, EXCLUDE_PERSON_FLAG EXCLUDE_PERSON_FLAG, NAMED_PERSON_ID NAMED_PERSON_ID, CUSTOM_RESTRICTION_FLAG CUSTOM_RESTRICTION_FLAG, RESTRICTION_TEXT RESTRICTION_TEXT, EXCLUDE_BUSINESS_GROUPS_FLAG EXCLUDE_BUSINESS_GROUPS_FLAG, ORG_SECURITY_MODE ORG_SECURITY_MODE, VIEW_ALL_CWK_FLAG VIEW_ALL_CWK_FLAG, VIEW_ALL_CONTACTS_FLAG VIEW_ALL_CONTACTS_FLAG, RESTRICT_ON_INDIVIDUAL_ASG RESTRICT_ON_INDIVIDUAL_ASG, TOP_ORGANIZATION_METHOD TOP_ORGANIZATION_METHOD, TOP_POSITION_METHOD TOP_POSITION_METHOD, VIEW_ALL_CANDIDATES_FLAG VIEW_ALL_CANDIDATES_FLAG from "HR"."PER_SECURITY_PROFILES"

View Text - HTML Formatted

SELECT SECURITY_PROFILE_ID SECURITY_PROFILE_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, POSITION_ID POSITION_ID
, ORGANIZATION_ID ORGANIZATION_ID
, POSITION_STRUCTURE_ID POSITION_STRUCTURE_ID
, ORGANIZATION_STRUCTURE_ID ORGANIZATION_STRUCTURE_ID
, INCLUDE_TOP_ORGANIZATION_FLAG INCLUDE_TOP_ORGANIZATION_FLAG
, INCLUDE_TOP_POSITION_FLAG INCLUDE_TOP_POSITION_FLAG
, SECURITY_PROFILE_NAME SECURITY_PROFILE_NAME
, VIEW_ALL_APPLICANTS_FLAG VIEW_ALL_APPLICANTS_FLAG
, VIEW_ALL_EMPLOYEES_FLAG VIEW_ALL_EMPLOYEES_FLAG
, VIEW_ALL_FLAG VIEW_ALL_FLAG
, VIEW_ALL_ORGANIZATIONS_FLAG VIEW_ALL_ORGANIZATIONS_FLAG
, VIEW_ALL_PAYROLLS_FLAG VIEW_ALL_PAYROLLS_FLAG
, VIEW_ALL_POSITIONS_FLAG VIEW_ALL_POSITIONS_FLAG
, INCLUDE_EXCLUDE_PAYROLL_FLAG INCLUDE_EXCLUDE_PAYROLL_FLAG
, REPORTING_ORACLE_USERNAME REPORTING_ORACLE_USERNAME
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, 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
, ALLOW_GRANTED_USERS_FLAG ALLOW_GRANTED_USERS_FLAG
, RESTRICT_BY_SUPERVISOR_FLAG RESTRICT_BY_SUPERVISOR_FLAG
, SUPERVISOR_LEVELS SUPERVISOR_LEVELS
, EXCLUDE_SECONDARY_ASGS_FLAG EXCLUDE_SECONDARY_ASGS_FLAG
, EXCLUDE_PERSON_FLAG EXCLUDE_PERSON_FLAG
, NAMED_PERSON_ID NAMED_PERSON_ID
, CUSTOM_RESTRICTION_FLAG CUSTOM_RESTRICTION_FLAG
, RESTRICTION_TEXT RESTRICTION_TEXT
, EXCLUDE_BUSINESS_GROUPS_FLAG EXCLUDE_BUSINESS_GROUPS_FLAG
, ORG_SECURITY_MODE ORG_SECURITY_MODE
, VIEW_ALL_CWK_FLAG VIEW_ALL_CWK_FLAG
, VIEW_ALL_CONTACTS_FLAG VIEW_ALL_CONTACTS_FLAG
, RESTRICT_ON_INDIVIDUAL_ASG RESTRICT_ON_INDIVIDUAL_ASG
, TOP_ORGANIZATION_METHOD TOP_ORGANIZATION_METHOD
, TOP_POSITION_METHOD TOP_POSITION_METHOD
, VIEW_ALL_CANDIDATES_FLAG VIEW_ALL_CANDIDATES_FLAG
FROM "HR"."PER_SECURITY_PROFILES"