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

Object Details

Object Name:	HR_PUMP_BATCH_LINE_USER_KEYS
Object Type:	TABLE
Owner:	HR
FND Design Data:	PER.HR_PUMP_BATCH_LINE_USER_KEYS
Subobject Name:
Status:	VALID

HR_PUMP_BATCH_LINE_USER_KEYS holds data pump user key information.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Unique Key: HR_PUMP_BATCH_LINE_USER_KE_UK1

USER_KEY_VALUE

Indexes

Index	Type	Uniqueness	Tablespace	Column
HR_PUMP_BATCH_LINE_USER_KE_UK1	NORMAL	UNIQUE	APPS_TS_INTERFACE	USER_KEY_VALUE
HR_PUMP_BATCH_LINE_USER_KEY_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	USER_KEY_ID
HR_PUMP_BATCH_LINE_USER_KE_FK1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	BATCH_LINE_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
HR_PUMP_BATCH_LINE_USER_KEYS		HR_PUMP_BATCH_LINES	HR_PUMP_BATCH_LINE_USER_KEYS BATCH_LINE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
BATCH_LINE_ID	NUMBER	(15)		Foreign key to HR_PUMP_BATCH_LINES. Specifies the API call that created this user key.
CREATED_BY	NUMBER	(15)		Standard Who column.
CREATION_DATE	DATE			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.
UNIQUE_KEY_ID	NUMBER	(15)	Yes	System generated primary key.
USER_KEY_ID	NUMBER	(15)	Yes	Surrogate primary key value reference using this user key.
USER_KEY_VALUE	VARCHAR2	(240)	Yes	Name value used in data pump API calls.

Query Text

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


SELECT BATCH_LINE_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      UNIQUE_KEY_ID
,      USER_KEY_ID
,      USER_KEY_VALUE
FROM HR.HR_PUMP_BATCH_LINE_USER_KEYS;

Dependencies

[top of page]

HR.HR_PUMP_BATCH_LINE_USER_KEYS does not reference any database object

HR.HR_PUMP_BATCH_LINE_USER_KEYS is referenced by following:

APPS: HR_PUMP_BATCH_LINE_USER_KEYS; HR_PUMP_BATCH_LINE_USER_KE_WHO
PUBLIC: HR_PUMP_BATCH_LINE_USER_KEYS