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]

TABLE: HR.PER_SECURITY_ORGANIZATIONS

Object Details

Object Name:	PER_SECURITY_ORGANIZATIONS
Object Type:	TABLE
Owner:	HR
FND Design Data:	PER.PER_SECURITY_ORGANIZATIONS
Subobject Name:
Status:	VALID

Descrete list of organizations to exclude or include from
per_organization_list during security list maintainence

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PER_SECURITY_ORGANIZATIONS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	SECURITY_ORGANIZATION_ID
PER_SECURITY_ORGANIZATIONS_FK1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORGANIZATION_ID
PER_SECURITY_ORGANIZATIONS_FK2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SECURITY_PROFILE_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
PER_SECURITY_ORGANIZATIONS		HR_ALL_ORGANIZATION_UNITS	PER_SECURITY_ORGANIZATIONS ORGANIZATION_ID
PER_SECURITY_ORGANIZATIONS		PER_SECURITY_PROFILES	PER_SECURITY_ORGANIZATIONS SECURITY_PROFILE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
SECURITY_ORGANIZATION_ID	NUMBER	(15)	Yes	security organization identifier
ORGANIZATION_ID	NUMBER	(15)	Yes	organization identifier
SECURITY_PROFILE_ID	NUMBER	(15)	Yes	security profile identifier
ENTRY_TYPE	VARCHAR2	(1)	Yes	entry type
LAST_UPDATED_BY	NUMBER	(15)		WHO column
LAST_UPDATE_DATE	DATE			WHO column
LAST_UPDATE_LOGIN	NUMBER	(15)		WHO column
CREATED_BY	NUMBER	(15)		WHO column
CREATION_DATE	DATE			WHO column
OBJECT_VERSION_NUMBER	NUMBER	(15)		internal used by APIs

Query Text

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


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

Dependencies

[top of page]

HR.PER_SECURITY_ORGANIZATIONS does not reference any database object

HR.PER_SECURITY_ORGANIZATIONS is referenced by following:

HR: PER_SECURITY_ORGANIZATIONS#