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_ORGANIZATION_LIST

Object Details

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

PER_ORGANIZATION_LIST holds the list of organizations that a secure
user can access. This list is created and maintained by the LISTGEN
security process using the definition of the security profile. Rows
are created for all profiles that have the VIEW_ALL_ORGANIZATIONS_FLAG
set to N.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PER_ORGANIZATION_LIST_UK1	NORMAL	UNIQUE	APPS_TS_TX_IDX	SECURITY_PROFILE_ID ORGANIZATION_ID USER_ID
PER_ORGANIZATION_LIST_FK1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORGANIZATION_ID
PER_ORGANIZATION_LIST_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SECURITY_PROFILE_ID USER_ID

Foreign Keys

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

Columns

Name	Datatype	Length	Mandatory	Comments
SECURITY_PROFILE_ID	NUMBER	(15)	Yes	Foreign key to PER_SECURITY_PROFILES.
ORGANIZATION_ID	NUMBER	(15)	Yes	Foreign key to HR_ORGANIZATION_UNITS.
REQUEST_ID	NUMBER	(15)		Standard Who Column.
PROGRAM_APPLICATION_ID	NUMBER	(15)		Standard Who column.
PROGRAM_ID	NUMBER	(15)		Standard Who Column.
PROGRAM_UPDATE_DATE	DATE			Standard Who column.
USER_ID	NUMBER	(15)		Foreign key to FND_USER.

Query Text

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


SELECT SECURITY_PROFILE_ID
,      ORGANIZATION_ID
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      USER_ID
FROM HR.PER_ORGANIZATION_LIST;

Dependencies

[top of page]

HR.PER_ORGANIZATION_LIST does not reference any database object

HR.PER_ORGANIZATION_LIST is referenced by following:

APPS: PER_ORGANIZATION_LIST
PUBLIC: PER_ORGANIZATION_LIST