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_SS_TRANSACTION_HISTORY

Object Details

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

Self Service Transaction History - Transaction History

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PQH_SS_TRANSACTION_HISTORY_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	TRANSACTION_HISTORY_ID

Columns

Name	Datatype	Length	Mandatory	Comments
TRANSACTION_HISTORY_ID	NUMBER	(15)	Yes	Transaction History Identifier
CREATOR_PERSON_ID	NUMBER	(15)	Yes	Creator Person Identifier
ASSIGNMENT_ID	NUMBER	(15)		Assignment Identifier
SELECTED_PERSON_ID	NUMBER	(15)		Selected Person Identifier
ITEM_TYPE	VARCHAR2	(10)		Item Type
ITEM_KEY	VARCHAR2	(240)		Item Key
PROCESS_NAME	VARCHAR2	(30)		Process Name
APPROVAL_ITEM_TYPE	VARCHAR2	(10)		Approval Item Type
APPROVAL_ITEM_KEY	VARCHAR2	(240)		Approval Item Key
FUNCTION_ID	NUMBER	(10)		Function Identifier
RPTG_GRP_ID	NUMBER	(15)		Reporting Group Identifier
PLAN_ID	NUMBER	(15)		Plan Identifier
CREATED_BY	NUMBER	(15)		Standard WHO Column
CREATION_DATE	DATE			Standard WHO Column
LAST_UPDATE_DATE	DATE			Standard WHO Column
LAST_UPDATED_BY	NUMBER	(15)		Standard WHO Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO Column
TRANSACTION_GROUP	VARCHAR2	(60)		Transaction Group
TRANSACTION_IDENTIFIER	VARCHAR2	(60)		Transaction Identifier

Query Text

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


SELECT TRANSACTION_HISTORY_ID
,      CREATOR_PERSON_ID
,      ASSIGNMENT_ID
,      SELECTED_PERSON_ID
,      ITEM_TYPE
,      ITEM_KEY
,      PROCESS_NAME
,      APPROVAL_ITEM_TYPE
,      APPROVAL_ITEM_KEY
,      FUNCTION_ID
,      RPTG_GRP_ID
,      PLAN_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      TRANSACTION_GROUP
,      TRANSACTION_IDENTIFIER
FROM HR.PQH_SS_TRANSACTION_HISTORY;

Dependencies

[top of page]

HR.PQH_SS_TRANSACTION_HISTORY does not reference any database object

HR.PQH_SS_TRANSACTION_HISTORY is referenced by following:

APPS: PQH_SS_TRANSACTION_HISTORY; PQH_SS_TRANSACTION_HISTORY_WHO
PUBLIC: PQH_SS_TRANSACTION_HISTORY