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

TABLE: HR.PQH_SS_VALUE_HISTORY

Object Details
Object Name: PQH_SS_VALUE_HISTORY
Object Type: TABLE
Owner: HR
FND Design Data: TablePQH.PQH_SS_VALUE_HISTORY
Subobject Name:
Status: VALID


Self Service Transaction History - Item Value History


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PQH_SS_VALUE_HISTORY_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRANSACTION_VALUE_ID
ColumnSTEP_HISTORY_ID
ColumnAPPROVAL_HISTORY_ID
PQH_SS_VALUE_HISTORY_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSTEP_HISTORY_ID
ColumnAPPROVAL_HISTORY_ID
Columns
Name Datatype Length Mandatory Comments
TRANSACTION_VALUE_ID NUMBER (15) Yes Transaction Value History Identifier
STEP_HISTORY_ID NUMBER (15) Yes Transaction Step History Identifier
APPROVAL_HISTORY_ID NUMBER (15) Yes Approval History Identifier
DATATYPE VARCHAR2 (30) Yes Item Data type
NAME VARCHAR2 (30) Yes Item Name
VALUE VARCHAR2 (2000)
Item Value
ORIGINAL_VALUE VARCHAR2 (2000)
Item Original Value
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
Query Text

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


SELECT TRANSACTION_VALUE_ID
,      STEP_HISTORY_ID
,      APPROVAL_HISTORY_ID
,      DATATYPE
,      NAME
,      VALUE
,      ORIGINAL_VALUE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM HR.PQH_SS_VALUE_HISTORY;

Dependencies

[top of page]

HR.PQH_SS_VALUE_HISTORY does not reference any database object

HR.PQH_SS_VALUE_HISTORY is referenced by following:

SchemaAPPS
SynonymPQH_SS_VALUE_HISTORY
TriggerPQH_SS_VALUE_HISTORY_WHO
SchemaPUBLIC
SynonymPQH_SS_VALUE_HISTORY