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.PQH_ROUTING_HISTORY

Object Details

Object Name:	PQH_ROUTING_HISTORY
Object Type:	TABLE
Owner:	HR
FND Design Data:	PQH.PQH_ROUTING_HISTORY
Subobject Name:
Status:	VALID

ROUTING_HISTORY keeps track of each hop during the routing / approver process. It also has some pre-identified attributes stored with new values.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: PQH_ROUTING_HISTORY_PK

ROUTING_HISTORY_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
PQH_ROUTING_HISTORY_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	ROUTING_HISTORY_ID
PQH_ROUTING_HISTORY_FK1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ROUTING_CATEGORY_ID
PQH_ROUTING_HISTORY_FK4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRANSACTION_CATEGORY_ID
PQH_ROUTING_HISTORY_FK5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	FORWARDED_BY_MEMBER_ID
PQH_ROUTING_HISTORY_FK6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	FORWARDED_TO_MEMBER_ID
PQH_ROUTING_HISTORY_FK7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	POS_STRUCTURE_VERSION_ID
PQH_ROUTING_HISTORY_FK8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	FORWARDED_TO_ROLE_ID
PQH_ROUTING_HISTORY_FK9	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	FORWARDED_BY_ROLE_ID
PQH_ROUTING_HISTORY_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRANSACTION_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
PQH_ROUTING_HISTORY	PER_POS_STRUCTURE_VERSIONS	PQH_ROUTING_HISTORY POS_STRUCTURE_VERSION_ID
PQH_ROUTING_HISTORY	PQH_ROLES	PQH_ROUTING_HISTORY FORWARDED_TO_ROLE_ID
PQH_ROUTING_HISTORY	PQH_ROLES	PQH_ROUTING_HISTORY FORWARDED_BY_ROLE_ID
PQH_ROUTING_HISTORY	PQH_ROUTING_CATEGORIES	PQH_ROUTING_HISTORY ROUTING_CATEGORY_ID
PQH_ROUTING_HISTORY	PQH_ROUTING_LIST_MEMBERS	PQH_ROUTING_HISTORY FORWARDED_BY_MEMBER_ID
PQH_ROUTING_HISTORY	PQH_ROUTING_LIST_MEMBERS	PQH_ROUTING_HISTORY FORWARDED_TO_MEMBER_ID
PQH_ROUTING_HISTORY	PQH_TRANSACTION_CATEGORIES	PQH_ROUTING_HISTORY TRANSACTION_CATEGORY_ID
PQH_ROUTING_HIST_ATTRIBS	PQH_ROUTING_HISTORY	PQH_ROUTING_HIST_ATTRIBS ROUTING_HISTORY_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ROUTING_HISTORY_ID	NUMBER	(15)	Yes	Primary Key
APPROVAL_CD	VARCHAR2	(30)		Approved in the current step or not
COMMENTS	VARCHAR2	(2000)		General comments
FORWARDED_BY_ASSIGNMENT_ID	NUMBER	(15)		Assignment of the current person
FORWARDED_BY_MEMBER_ID	NUMBER	(15)		Routing list member of the current person
FORWARDED_BY_POSITION_ID	NUMBER	(15)		Position of the current person
FORWARDED_BY_USER_ID	NUMBER	(15)		Person ID of current user.
FORWARDED_TO_ASSIGNMENT_ID	NUMBER	(15)		Assignment of the next person
FORWARDED_TO_MEMBER_ID	NUMBER	(15)		Routing list member idetifier of the next person
FORWARDED_TO_POSITION_ID	NUMBER	(15)		position of the next person
FORWARDED_TO_USER_ID	NUMBER	(15)		Person ID of the next user
NOTIFICATION_DATE	DATE		Yes	Date on which notification was sent.
POS_STRUCTURE_VERSION_ID	NUMBER			Position hierarchy used in this step
ROUTING_CATEGORY_ID	NUMBER	(15)		Routing category used in this step
TRANSACTION_CATEGORY_ID	NUMBER	(15)	Yes	Transaction Category identifier
TRANSACTION_ID	NUMBER	(15)	Yes	Generic Transaction Id refers to transaction table based on transaction category
USER_ACTION_CD	VARCHAR2	(10)	Yes	Action user took.
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	Object version Number
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)	Yes	Standard Who Column
CREATION_DATE	DATE		Yes	Standard Who Column
FORWARDED_BY_ROLE_ID	NUMBER	(15)		Role of the current person
FORWARDED_TO_ROLE_ID	NUMBER	(15)		Role of the next person
FROM_RANGE_NAME	VARCHAR2	(30)		Current user's access rules
TO_RANGE_NAME	VARCHAR2	(30)		Next user's access rule
LIST_RANGE_NAME	VARCHAR2	(30)		Routing category access rule

Query Text

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


SELECT ROUTING_HISTORY_ID
,      APPROVAL_CD
,      COMMENTS
,      FORWARDED_BY_ASSIGNMENT_ID
,      FORWARDED_BY_MEMBER_ID
,      FORWARDED_BY_POSITION_ID
,      FORWARDED_BY_USER_ID
,      FORWARDED_TO_ASSIGNMENT_ID
,      FORWARDED_TO_MEMBER_ID
,      FORWARDED_TO_POSITION_ID
,      FORWARDED_TO_USER_ID
,      NOTIFICATION_DATE
,      POS_STRUCTURE_VERSION_ID
,      ROUTING_CATEGORY_ID
,      TRANSACTION_CATEGORY_ID
,      TRANSACTION_ID
,      USER_ACTION_CD
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      FORWARDED_BY_ROLE_ID
,      FORWARDED_TO_ROLE_ID
,      FROM_RANGE_NAME
,      TO_RANGE_NAME
,      LIST_RANGE_NAME
FROM HR.PQH_ROUTING_HISTORY;

Dependencies

[top of page]

HR.PQH_ROUTING_HISTORY does not reference any database object

HR.PQH_ROUTING_HISTORY is referenced by following:

APPS: PQH_ROUTING_HISTORY; PQH_ROUTING_HISTORY_WHO
PUBLIC: PQH_ROUTING_HISTORY