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

TABLE: HR.PER_RI_CONFIG_RESPONSIBILITY

Object Details
Object Name: PER_RI_CONFIG_RESPONSIBILITY
Object Type: TABLE
Owner: HR
Subobject Name:
Status: VALID


This table stores the seeded information about responsibilities needs to be assigned to the HRMS_SUPER_USER based on the countries (or business groups) and product selection made by user in the Organization Structures Configuration.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PER_RI_CONFIG_RESPONSIBILITY NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnRESPONSIBILITY_APPLICATION
ColumnRESPONSIBILITY_KEY
ColumnTERRITORY_CODE
Columns
Name Datatype Length Mandatory Comments
RESPONSIBILITY_APPLICATION VARCHAR2 (50) Yes Primary Key to the table
TERRITORY_CODE VARCHAR2 (2) Yes Foreign Key (FND_TERRITORIES.TERROTORY_CODE)
RESPONSIBILITY_KEY VARCHAR2 (30) Yes Foreign Key (FND_RESPONSIBILITY.RESPONSIBILITY_KEY)
LAST_UPDATE_DATE DATE

Standard WHO Column
LAST_UPDATED_BY NUMBER (15)
Standard WHO Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO Column
CREATED_BY NUMBER (15)
Standard WHO Column
CREATION_DATE DATE

Standard WHO Column
Query Text

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


SELECT RESPONSIBILITY_APPLICATION
,      TERRITORY_CODE
,      RESPONSIBILITY_KEY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM HR.PER_RI_CONFIG_RESPONSIBILITY;

Dependencies

[top of page]

HR.PER_RI_CONFIG_RESPONSIBILITY does not reference any database object

HR.PER_RI_CONFIG_RESPONSIBILITY is referenced by following:

SchemaAPPS
SynonymPER_RI_CONFIG_RESPONSIBILITY
TriggerPER_RI_CONFIG_RESPONSIBILI_WHO
SchemaPUBLIC
SynonymPER_RI_CONFIG_RESPONSIBILITY