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: GMA.SY_PURG_DEF_CRIT

Object Details

Object Name:	SY_PURG_DEF_CRIT
Object Type:	TABLE
Owner:	GMA
FND Design Data:	GMA.SY_PURG_DEF_CRIT
Subobject Name:
Status:	VALID

Stores the Purge Criteria tags. These criteria are used to determine
what rows will be archived and purged.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
SY_PURG_DEF_CRIT_PK	NORMAL	UNIQUE	APPS_TS_SEED	PURGE_TYPE CRIT_TAG

Columns

Name	Datatype	Length	Mandatory	Comments
PURGE_TYPE	VARCHAR2	(4)	Yes	Purge Type - the name of the Purge and Archive routine (eg, PROD).
CRIT_TAG	VARCHAR2	(32)	Yes	Criteria tag. Serves as a placeholder where selection criteria will be entered
DEFAULT_VALUE	VARCHAR2	(32)		Default value for the Criteria Tag. Default Value is Blank, but can be updated by the end user.
MASK	VARCHAR2	(120)		Not Used
DESCRIPTION	VARCHAR2	(80)		Description of what criteria should be entered for a field on the form (eg, Enter Operator Code). This will be displayed at the time of criteria entry.
CREATION_DATE	DATE		Yes	Standard who column
CREATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
TRANS_CNT	NUMBER	(10)		Not currently used
DELETE_MARK	NUMBER	(5)	Yes	Standard: 0=Active record (default); 1=Marked for (logical) deletion.
TEXT_CODE	NUMBER	(10)		ID which joins any rows of text in this table to the Text Table for this Module
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
VALUE_MASK	VARCHAR2	(120)	Yes	Will handle masking of data in order to feed Criteria to SQL statement during execution (eg, CHAR, DATE, NUMBER).
SEQUENCE	NUMBER	(15)		Purge Sequence
LOV_TABLE	VARCHAR2	(4000)		Holds the base table for the Purge Criteria LOV.
LOV_FIELD	VARCHAR2	(4000)		Holds the field name for the Purge Criteria LOV.

Query Text

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


SELECT PURGE_TYPE
,      CRIT_TAG
,      DEFAULT_VALUE
,      MASK
,      DESCRIPTION
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      TRANS_CNT
,      DELETE_MARK
,      TEXT_CODE
,      LAST_UPDATE_LOGIN
,      VALUE_MASK
,      SEQUENCE
,      LOV_TABLE
,      LOV_FIELD
FROM GMA.SY_PURG_DEF_CRIT;

Dependencies

[top of page]

GMA.SY_PURG_DEF_CRIT does not reference any database object

GMA.SY_PURG_DEF_CRIT is referenced by following:

APPS: SY_PURG_DEF_CRIT