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: ONT.OE_PURGE_SETS

Object Details

Object Name:	OE_PURGE_SETS
Object Type:	TABLE
Owner:	ONT
FND Design Data:	ONT.OE_PURGE_SETS
Subobject Name:
Status:	VALID

OE_PURGE_SETS stores purge set information.
When purge set is created using multiselect feature from Order Organizer, the number of orders, and their header_ids will be stored in this table.
When purge set is created using Generate Purge Set concurrent program, the where condition will be stored in this table.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OE_PURGE_SETS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PURGE_SET_ID
SYS_IL0000085650C00006$$	LOB	UNIQUE	APPS_TS_TX_DATA
OE_PURGE_SETS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PURGE_SET_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
PURGE_SET_ID	NUMBER		Yes	System Generated identifier for Purge Set
PURGE_SET_NAME	VARCHAR2	(50)	Yes	Purge Set Name
PURGE_SET_DESCRIPTION	VARCHAR2	(2000)		Purge Set Description
PURGE_SET_REQUEST_ID	NUMBER			Request Id for Purge Set Creation request
COUNT_SELECTED	NUMBER			Number of Orders selected for the purge set, if using multiselect purge set creation
SELECTED_IDS	CLOB	(4000)		Order Numbers of the selected orders for a purge set, if using multi-select purge set creation
WHERE_CONDITION	VARCHAR2	(4000)		Where condition for purge set creation if using concurrent request for purge set creation
PURGE_SET_SUBMIT_DATETIME	DATE			Datetime for purge set creation submission
PURGE_PROCESSED	VARCHAR2	(1)		Flag to indicate if the purge set has been processed
PURGE_SET_PURGED	VARCHAR2	(1)		Flag to indicate if the purge set has been purged
PURGED_BY	NUMBER			User who purged the purge set
PURGE_SUBMIT_DATETIME	DATE			Datetime for purge submission
PURGE_REQUEST_ID	NUMBER			Request id for the Order Purge
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
PROGRAM_APPLICATION_ID	NUMBER			Application of concurrent program which last updated row
PROGRAM_ID	NUMBER			Concurrent Program that last updated row
PROGRAM_UPDATE_DATE	DATE			Last date changed by concurrent program
ORDERS_PER_COMMIT	NUMBER			Number of orders that will be commited by the order purge.

Query Text

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


SELECT PURGE_SET_ID
,      PURGE_SET_NAME
,      PURGE_SET_DESCRIPTION
,      PURGE_SET_REQUEST_ID
,      COUNT_SELECTED
,      SELECTED_IDS
,      WHERE_CONDITION
,      PURGE_SET_SUBMIT_DATETIME
,      PURGE_PROCESSED
,      PURGE_SET_PURGED
,      PURGED_BY
,      PURGE_SUBMIT_DATETIME
,      PURGE_REQUEST_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ORDERS_PER_COMMIT
FROM ONT.OE_PURGE_SETS;

Dependencies

[top of page]

ONT.OE_PURGE_SETS does not reference any database object

ONT.OE_PURGE_SETS is referenced by following:

ONT: OE_PURGE_SETS#