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: PSP.PSP_ARCH_RET_REQUESTS

Object Details

Object Name:	PSP_ARCH_RET_REQUESTS
Object Type:	TABLE
Owner:	PSP
Subobject Name:
Status:	VALID

Psp Archive Restore Requests

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Comments
REQUEST_ID	NUMBER	(15)	This field stores REQUEST_ID info
START_DATE	DATE		This field stores START_DATE info
END_DATE	DATE		This field stores END_DATE info
ARCH_RET_FLAG	VARCHAR2	(1)	This field stores ARCH_RET_FLAG info
BATCH_NAME	VARCHAR2	(50)	This field stores BATCH_NAME info
ARCHIVAL_CODE	VARCHAR2	(50)	This field stores ARCHIVAL_CODE info
BATCH_SIZE	NUMBER		This field stores BATCH_SIZE info
ARCHIVED_BATCH_SIZE	NUMBER		This field stores ARCHIVED_BATCH_SIZE info
MIN_DIST_DATE	DATE		This field stores MIN_DIST_DATE info
MAX_DIST_DATE	DATE		This field stores MAX_DIST_DATE info

Query Text

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


SELECT REQUEST_ID
,      START_DATE
,      END_DATE
,      ARCH_RET_FLAG
,      BATCH_NAME
,      ARCHIVAL_CODE
,      BATCH_SIZE
,      ARCHIVED_BATCH_SIZE
,      MIN_DIST_DATE
,      MAX_DIST_DATE
FROM PSP.PSP_ARCH_RET_REQUESTS;

Dependencies

[top of page]

PSP.PSP_ARCH_RET_REQUESTS does not reference any database object

PSP.PSP_ARCH_RET_REQUESTS is referenced by following:

PSP: PSP_ARCH_RET_REQUESTS#