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: QP.QP_ARCH_CRITERIA_LINES

Object Details

Object Name:	QP_ARCH_CRITERIA_LINES
Object Type:	TABLE
Owner:	QP
FND Design Data:	QP.QP_ARCH_CRITERIA_LINES
Subobject Name:
Status:	VALID

Stores criteria for archive process

Storage Details

Tablespace:	APPS_TS_ARCHIVE
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
REQUEST_ID	NUMBER		Yes	Stores the request ID
PARAMETER_NAME	VARCHAR2	(30)	Yes	Stores the parameters for archive criteria
PARAMETER_VALUE	VARCHAR2	(1000)	Yes	Stores the values for parameters

Query Text

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


SELECT REQUEST_ID
,      PARAMETER_NAME
,      PARAMETER_VALUE
FROM QP.QP_ARCH_CRITERIA_LINES;

Dependencies

[top of page]

QP.QP_ARCH_CRITERIA_LINES does not reference any database object

QP.QP_ARCH_CRITERIA_LINES is referenced by following:

QP: QP_ARCH_CRITERIA_LINES#