VIEW: ONT.OE_PURGE_SETS#

Source

View Text - Preformatted

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

View Text - HTML Formatted

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