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_HEADERS

Object Details

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

Stores the header information for the archive process

Storage Details

Tablespace:	APPS_TS_ARCHIVE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
QP_ARCH_CRITERIA_HEADERS_U1	NORMAL	UNIQUE	APPS_TS_ARCHIVE	REQUEST_NAME
QP_ARCH_CRITERIA_HEADERS_U2	NORMAL	UNIQUE	APPS_TS_ARCHIVE	REQUEST_ID

Columns

Name	Datatype	Length	Mandatory	Comments
REQUEST_ID	NUMBER		Yes	Stores the request ID
REQUEST_NAME	VARCHAR2	(240)		Stores the archive name
REQUEST_TYPE	VARCHAR2	(30)	Yes	Stores the request type (Achive or Purge)
SOURCE_SYSTEM	VARCHAR2	(30)	Yes	Stores the source system code
CREATION_DATE	DATE		Yes	Stores the creation date
CREATED_BY	NUMBER		Yes	Stores the created by
REQUEST_STATUS	VARCHAR2	(1)	Yes	Completion status of the concurrent program:S(uccess) or F(ailure) or W(arning)
PURGE_FLAG	VARCHAR2	(1)	Yes	Y if purged and N if not purged

Query Text

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


SELECT REQUEST_ID
,      REQUEST_NAME
,      REQUEST_TYPE
,      SOURCE_SYSTEM
,      CREATION_DATE
,      CREATED_BY
,      REQUEST_STATUS
,      PURGE_FLAG
FROM QP.QP_ARCH_CRITERIA_HEADERS;

Dependencies

[top of page]

QP.QP_ARCH_CRITERIA_HEADERS does not reference any database object

QP.QP_ARCH_CRITERIA_HEADERS is referenced by following:

QP: QP_ARCH_CRITERIA_HEADERS#