[Home] [Help] [Dependency Information]
Object Name: | PQH_ROUTING_CATEGORIES |
---|---|
Object Type: | TABLE |
Owner: | HR |
FND Design Data: | PQH.PQH_ROUTING_CATEGORIES |
Subobject Name: | |
Status: | VALID |
Transaction Routing Information
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PQH_ROUTING_CATEGORIES_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | ROUTING_CATEGORY_ID |
PQH_ROUTING_CATEGORIES_FK1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ROUTING_LIST_ID |
PQH_ROUTING_CATEGORIES_FK2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | TRANSACTION_CATEGORY_ID |
PQH_ROUTING_CATEGORIES_FK3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | POSITION_STRUCTURE_ID |
PQH_ROUTING_CATEGORIES_FK5 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | OVERRIDE_ROLE_ID |
Table | |
Foreign Table | Foreign Key Column | PQH_ROUTING_CATEGORIES | PER_POSITION_STRUCTURES | PQH_ROUTING_CATEGORIES POSITION_STRUCTURE_ID | PQH_ROUTING_CATEGORIES | PQH_ROUTING_LISTS | PQH_ROUTING_CATEGORIES ROUTING_LIST_ID | PQH_ROUTING_CATEGORIES | PQH_TRANSACTION_CATEGORIES | PQH_ROUTING_CATEGORIES TRANSACTION_CATEGORY_ID | PQH_ATTRIBUTE_RANGES | PQH_ROUTING_CATEGORIES | PQH_ATTRIBUTE_RANGES ROUTING_CATEGORY_ID | PQH_ROUTING_HISTORY | PQH_ROUTING_CATEGORIES | PQH_ROUTING_HISTORY ROUTING_CATEGORY_ID |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROUTING_CATEGORY_ID | NUMBER | (15) | Yes | Primary Key |
TRANSACTION_CATEGORY_ID | NUMBER | (15) | Yes | Transaction category identifier |
ROUTING_LIST_ID | NUMBER | (15) | Routing List identifier | |
POSITION_STRUCTURE_ID | NUMBER | (15) | System generated position structures primary key from Position hierarchy identifier | |
OVERRIDE_POSITION_ID | NUMBER | (15) | Assignment selected as override approver for the transaction category | |
OVERRIDE_ASSIGNMENT_ID | NUMBER | (15) | Assignment selected as override approver for the transaction category | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Object version Number |
LAST_UPDATE_DATE | DATE | Standard Who Column | ||
CREATION_DATE | DATE | Yes | Standard Who Column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who Column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (15) | Standard Who Column | |
OVERRIDE_ROLE_ID | NUMBER | (15) | Role selected as override approver for the transaction category | |
OVERRIDE_USER_ID | NUMBER | (15) | User selected as override approver for the transaction category | |
ENABLE_FLAG | VARCHAR2 | (10) | Yes | Indicates if routing category is enabled or not |
DEFAULT_FLAG | VARCHAR2 | (10) | Default Indicator | |
DELETE_FLAG | VARCHAR2 | (10) | Indicates if routing category is to be delete or not |
Cut, paste (and edit) the following text to query this object:
SELECT ROUTING_CATEGORY_ID
, TRANSACTION_CATEGORY_ID
, ROUTING_LIST_ID
, POSITION_STRUCTURE_ID
, OVERRIDE_POSITION_ID
, OVERRIDE_ASSIGNMENT_ID
, OBJECT_VERSION_NUMBER
, LAST_UPDATE_DATE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, LAST_UPDATED_BY
, OVERRIDE_ROLE_ID
, OVERRIDE_USER_ID
, ENABLE_FLAG
, DEFAULT_FLAG
, DELETE_FLAG
FROM HR.PQH_ROUTING_CATEGORIES;
HR.PQH_ROUTING_CATEGORIES does not reference any database object
HR.PQH_ROUTING_CATEGORIES is referenced by following:
|
|
|