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_HIST_ATTRIBS

Object Details

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

Attribute values for each step of routing

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: PQH_ROUTING_HIST_ATTRIBS_PK

ROUTING_HIST_ATTRIB_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
PQH_ROUTING_HIST_ATTRIBS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	ROUTING_HIST_ATTRIB_ID
PQH_ROUTING_HIST_ATTRIBS_FK1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ROUTING_HISTORY_ID
PQH_ROUTING_HIST_ATTRIBS_FK2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ATTRIBUTE_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
PQH_ROUTING_HIST_ATTRIBS		PQH_ATTRIBUTES	PQH_ROUTING_HIST_ATTRIBS ATTRIBUTE_ID
PQH_ROUTING_HIST_ATTRIBS		PQH_ROUTING_HISTORY	PQH_ROUTING_HIST_ATTRIBS ROUTING_HISTORY_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ROUTING_HIST_ATTRIB_ID	NUMBER	(15)	Yes	Primary Key
ROUTING_HISTORY_ID	NUMBER	(15)	Yes	Routing history identifier
RANGE_TYPE_CD	VARCHAR2	(30)		Type of range (Next / list /current)
ATTRIBUTE_ID	NUMBER	(15)	Yes	Attribute identifier
FROM_CHAR	VARCHAR2	(240)		Range start varchar2
FROM_DATE	DATE			Range start date
FROM_NUMBER	NUMBER	(15)		Range start number
TO_CHAR	VARCHAR2	(240)		Range end varchar2
TO_DATE	DATE			Range end date
TO_NUMBER	NUMBER	(15)		Range end number
VALUE_DATE	DATE			Attribute value date
VALUE_NUMBER	NUMBER	(15)		Attribute value number
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column
CREATION_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)		Standard Who Column
LAST_UPDATE_DATE	DATE			Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who Column
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	Object version number
VALUE_CHAR	VARCHAR2	(240)		Attribute value varchar2

Query Text

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


SELECT ROUTING_HIST_ATTRIB_ID
,      ROUTING_HISTORY_ID
,      RANGE_TYPE_CD
,      ATTRIBUTE_ID
,      FROM_CHAR
,      FROM_DATE
,      FROM_NUMBER
,      TO_CHAR
,      TO_DATE
,      TO_NUMBER
,      VALUE_DATE
,      VALUE_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      VALUE_CHAR
FROM HR.PQH_ROUTING_HIST_ATTRIBS;

Dependencies

[top of page]

HR.PQH_ROUTING_HIST_ATTRIBS does not reference any database object

HR.PQH_ROUTING_HIST_ATTRIBS is referenced by following:

APPS: PQH_ROUTING_HIST_ATTRIBS; PQH_ROUTING_HIST_ATTRIBS_WHO
PUBLIC: PQH_ROUTING_HIST_ATTRIBS