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.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.PER_SECURITY_PROFILES_V

Object Details

Object Name:	PER_SECURITY_PROFILES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PER.PER_SECURITY_PROFILES_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory
ROW_ID	ROWID	(10)
SECURITY_PROFILE_ID	NUMBER	(15)	Yes
BUSINESS_GROUP_ID	NUMBER	(15)
BUSINESS_GROUP_NAME	VARCHAR2	(240)
POSITION_ID	NUMBER	(15)
TOP_POSITION	VARCHAR2	(4000)
ORGANIZATION_ID	NUMBER	(15)
TOP_ORGANIZATION	VARCHAR2	(240)
POSITION_STRUCTURE_ID	NUMBER	(15)
POSITION_HIERARCHY	VARCHAR2	(30)
POS_STRUCTURE_VERSION_ID	NUMBER
ORGANIZATION_STRUCTURE_ID	NUMBER	(15)
ORGANIZATION_HIERARCHY	VARCHAR2	(30)
ORG_STRUCTURE_VERSION_ID	NUMBER
INCLUDE_TOP_ORGANIZATION_FLAG	VARCHAR2	(30)	Yes
INCLUDE_TOP_POSITION_FLAG	VARCHAR2	(30)	Yes
SECURITY_PROFILE_NAME	VARCHAR2	(240)	Yes
VIEW_ALL_APPLICANTS_FLAG	VARCHAR2	(30)	Yes
VIEW_ALL_EMPLOYEES_FLAG	VARCHAR2	(30)	Yes
VIEW_ALL_CWK_FLAG	VARCHAR2	(30)	Yes
VIEW_ALL_CONTACTS_FLAG	VARCHAR2	(30)	Yes
VIEW_ALL_CANDIDATES_FLAG	VARCHAR2	(30)	Yes
VIEW_ALL_FLAG	VARCHAR2	(30)	Yes
VIEW_ALL_ORGANIZATIONS_FLAG	VARCHAR2	(30)	Yes
VIEW_ALL_PAYROLLS_FLAG	VARCHAR2	(30)	Yes
VIEW_ALL_POSITIONS_FLAG	VARCHAR2	(30)	Yes
INCLUDE_EXCLUDE_PAYROLL_FLAG	VARCHAR2	(30)
REPORTING_ORACLE_USERNAME	VARCHAR2	(30)
ALLOW_GRANTED_USERS_FLAG	VARCHAR2	(30)
RESTRICT_BY_SUPERVISOR_FLAG	VARCHAR2	(30)
SUPERVISOR_LEVELS	NUMBER
EXCLUDE_SECONDARY_ASGS_FLAG	VARCHAR2	(30)
EXCLUDE_PERSON_FLAG	VARCHAR2	(30)
NAMED_PERSON	VARCHAR2	(240)
NAMED_PERSON_ID	NUMBER	(10)
CUSTOM_RESTRICTION_FLAG	VARCHAR2	(30)
RESTRICTION_TEXT	VARCHAR2	(4000)
EXCLUDE_BUSINESS_GROUPS_FLAG	VARCHAR2	(30)
REQUEST_ID	NUMBER	(15)
PROGRAM_APPLICATION_ID	NUMBER	(15)
PROGRAM_ID	NUMBER	(15)
PROGRAM_UPDATE_DATE	DATE
LAST_UPDATE_DATE	DATE
LAST_UPDATED_BY	NUMBER	(15)
LAST_UPDATE_LOGIN	NUMBER	(15)
CREATED_BY	NUMBER	(15)
CREATION_DATE	DATE
ORG_SECURITY_MODE	VARCHAR2	(30)	Yes
RESTRICT_ON_INDIVIDUAL_ASG	VARCHAR2	(30)
TOP_ORGANIZATION_METHOD	VARCHAR2	(30)
TOP_POSITION_METHOD	VARCHAR2	(30)

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ROW_ID
,      SECURITY_PROFILE_ID
,      BUSINESS_GROUP_ID
,      BUSINESS_GROUP_NAME
,      POSITION_ID
,      TOP_POSITION
,      ORGANIZATION_ID
,      TOP_ORGANIZATION
,      POSITION_STRUCTURE_ID
,      POSITION_HIERARCHY
,      POS_STRUCTURE_VERSION_ID
,      ORGANIZATION_STRUCTURE_ID
,      ORGANIZATION_HIERARCHY
,      ORG_STRUCTURE_VERSION_ID
,      INCLUDE_TOP_ORGANIZATION_FLAG
,      INCLUDE_TOP_POSITION_FLAG
,      SECURITY_PROFILE_NAME
,      VIEW_ALL_APPLICANTS_FLAG
,      VIEW_ALL_EMPLOYEES_FLAG
,      VIEW_ALL_CWK_FLAG
,      VIEW_ALL_CONTACTS_FLAG
,      VIEW_ALL_CANDIDATES_FLAG
,      VIEW_ALL_FLAG
,      VIEW_ALL_ORGANIZATIONS_FLAG
,      VIEW_ALL_PAYROLLS_FLAG
,      VIEW_ALL_POSITIONS_FLAG
,      INCLUDE_EXCLUDE_PAYROLL_FLAG
,      REPORTING_ORACLE_USERNAME
,      ALLOW_GRANTED_USERS_FLAG
,      RESTRICT_BY_SUPERVISOR_FLAG
,      SUPERVISOR_LEVELS
,      EXCLUDE_SECONDARY_ASGS_FLAG
,      EXCLUDE_PERSON_FLAG
,      NAMED_PERSON
,      NAMED_PERSON_ID
,      CUSTOM_RESTRICTION_FLAG
,      RESTRICTION_TEXT
,      EXCLUDE_BUSINESS_GROUPS_FLAG
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      ORG_SECURITY_MODE
,      RESTRICT_ON_INDIVIDUAL_ASG
,      TOP_ORGANIZATION_METHOD
,      TOP_POSITION_METHOD
FROM APPS.PER_SECURITY_PROFILES_V;

Dependencies

[top of page]

APPS.PER_SECURITY_PROFILES_V references the following:

APPS: HR_ALL_ORGANIZATION_UNITS; HR_ALL_ORGANIZATION_UNITS_TL; HR_GENERAL - show dependent code; PER_ALL_PEOPLE_F; PER_BUSINESS_GROUPS_PERF; PER_ORGANIZATION_STRUCTURES; PER_ORG_STRUCTURE_VERSIONS; PER_POSITION_STRUCTURES; PER_POS_STRUCTURE_VERSIONS; PER_SECURITY_PROFILES

APPS.PER_SECURITY_PROFILES_V is referenced by following:

APPS: PAY_PYUCSLIS_PKG - show dependent code