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

Object Details

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

PER_QUICKPAINT_RESULT_TEXT holds a single line text description for
the result of a single QuickPaint run.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: PER_QUICKPAINT_RESULT_TEXT_PK

QP_INVOCATION_ID
ASSIGNMENT_ID
LINE_NUMBER

Indexes

Index	Type	Uniqueness	Tablespace	Column
PER_QUICKPAINT_RESULT_TEXT_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	QP_INVOCATION_ID ASSIGNMENT_ID LINE_NUMBER
PER_QUICKPAINT_RESULT_TEXT_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ASSIGNMENT_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
PER_QUICKPAINT_RESULT_TEXT		PER_QUICKPAINT_INVOCATIONS	PER_QUICKPAINT_RESULT_TEXT QP_INVOCATION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
QP_INVOCATION_ID	NUMBER	(9)	Yes	Foreign key to PER_QUICKPAINT_INVOCATIONS.
ASSIGNMENT_ID	NUMBER	(10)	Yes	Foreign key to PER_ASSIGNMENTS.
LINE_NUMBER	NUMBER	(9)	Yes	Sequence number of the text line.
TEXT	VARCHAR2	(240)		Text for the report line.
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)		Standard Who column.
CREATION_DATE	DATE			Standard Who column.

Query Text

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


SELECT QP_INVOCATION_ID
,      ASSIGNMENT_ID
,      LINE_NUMBER
,      TEXT
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM HR.PER_QUICKPAINT_RESULT_TEXT;

Dependencies

[top of page]

HR.PER_QUICKPAINT_RESULT_TEXT does not reference any database object

HR.PER_QUICKPAINT_RESULT_TEXT is referenced by following:

APPS: PER_QUICKPAINT_RESULT_TEXT; PER_QUICKPAINT_RESULT_TEXT_WHO
PUBLIC: PER_QUICKPAINT_RESULT_TEXT