[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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. |
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;
ONT.OE_PURGE_SETS does not reference any database object
ONT.OE_PURGE_SETS is referenced by following:
|
|
|