[Home] [Help] [Dependency Information]
Object Name: | OE_PURGE_SETS# |
---|---|
Object Type: | VIEW |
Owner: | ONT |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PURGE_SET_ID | NUMBER | Yes | ||
PURGE_SET_NAME | VARCHAR2 | (50) | Yes | |
PURGE_SET_DESCRIPTION | VARCHAR2 | (2000) | ||
PURGE_SET_REQUEST_ID | NUMBER | |||
COUNT_SELECTED | NUMBER | |||
SELECTED_IDS | CLOB | (4000) | ||
WHERE_CONDITION | VARCHAR2 | (4000) | ||
PURGE_SET_SUBMIT_DATETIME | DATE | |||
PURGE_PROCESSED | VARCHAR2 | (1) | ||
PURGE_SET_PURGED | VARCHAR2 | (1) | ||
PURGED_BY | NUMBER | |||
PURGE_SUBMIT_DATETIME | DATE | |||
PURGE_REQUEST_ID | NUMBER | |||
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | Yes | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | |||
PROGRAM_APPLICATION_ID | NUMBER | |||
PROGRAM_ID | NUMBER | |||
PROGRAM_UPDATE_DATE | DATE | |||
ORDERS_PER_COMMIT | NUMBER |
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#;
|
|
|