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: TablePER.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: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PER_SECURITY_ORGANIZATIONS_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSECURITY_ORGANIZATION_ID
PER_SECURITY_ORGANIZATIONS_FK1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnORGANIZATION_ID
PER_SECURITY_ORGANIZATIONS_FK2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSECURITY_PROFILE_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
PER_SECURITY_ORGANIZATIONS PER_SECURITY_ORGANIZATIONS_FK1 TableHR_ALL_ORGANIZATION_UNITS PER_SECURITY_ORGANIZATIONS ORGANIZATION_ID
PER_SECURITY_ORGANIZATIONS PER_SECURITY_ORGANIZATIONS_FK2 TablePER_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:

SchemaHR
ViewPER_SECURITY_ORGANIZATIONS#