VIEW: APPLSYS.AD_SNAPSHOT_FILES#

Source

View Text - Preformatted

select SNAPSHOT_FILE_ID SNAPSHOT_FILE_ID, SNAPSHOT_ID SNAPSHOT_ID, FILE_ID FILE_ID, CONTAINING_FILE_ID CONTAINING_FILE_ID, FILE_SIZE FILE_SIZE, CHECKSUM CHECKSUM, FILE_VERSION_ID FILE_VERSION_ID, UPDATE_SOURCE_ID UPDATE_SOURCE_ID, UPDATE_TYPE UPDATE_TYPE, CREATION_DATE CREATION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATED_BY CREATED_BY, APPL_TOP_ID APPL_TOP_ID, INCONSISTENT_FLAG INCONSISTENT_FLAG, SERVER_TYPE_ADMIN_FLAG SERVER_TYPE_ADMIN_FLAG, SERVER_TYPE_FORMS_FLAG SERVER_TYPE_FORMS_FLAG, SERVER_TYPE_NODE_FLAG SERVER_TYPE_NODE_FLAG, SERVER_TYPE_WEB_FLAG SERVER_TYPE_WEB_FLAG, DEST_FILE_ID DEST_FILE_ID, FILE_TYPE_FLAG FILE_TYPE_FLAG, IREP_GATHERED_FLAG IREP_GATHERED_FLAG, LAST_PATCHED_DATE LAST_PATCHED_DATE from "APPLSYS"."AD_SNAPSHOT_FILES"

View Text - HTML Formatted

SELECT SNAPSHOT_FILE_ID SNAPSHOT_FILE_ID
, SNAPSHOT_ID SNAPSHOT_ID
, FILE_ID FILE_ID
, CONTAINING_FILE_ID CONTAINING_FILE_ID
, FILE_SIZE FILE_SIZE
, CHECKSUM CHECKSUM
, FILE_VERSION_ID FILE_VERSION_ID
, UPDATE_SOURCE_ID UPDATE_SOURCE_ID
, UPDATE_TYPE UPDATE_TYPE
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATED_BY CREATED_BY
, APPL_TOP_ID APPL_TOP_ID
, INCONSISTENT_FLAG INCONSISTENT_FLAG
, SERVER_TYPE_ADMIN_FLAG SERVER_TYPE_ADMIN_FLAG
, SERVER_TYPE_FORMS_FLAG SERVER_TYPE_FORMS_FLAG
, SERVER_TYPE_NODE_FLAG SERVER_TYPE_NODE_FLAG
, SERVER_TYPE_WEB_FLAG SERVER_TYPE_WEB_FLAG
, DEST_FILE_ID DEST_FILE_ID
, FILE_TYPE_FLAG FILE_TYPE_FLAG
, IREP_GATHERED_FLAG IREP_GATHERED_FLAG
, LAST_PATCHED_DATE LAST_PATCHED_DATE
FROM "APPLSYS"."AD_SNAPSHOT_FILES"