[Home] [Help] [Dependency Information]
Object Name: | AD_SNAPSHOT_FILES# |
---|---|
Object Type: | VIEW |
Owner: | APPLSYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SNAPSHOT_FILE_ID | NUMBER | Yes | ||
SNAPSHOT_ID | NUMBER | Yes | ||
FILE_ID | NUMBER | Yes | ||
CONTAINING_FILE_ID | NUMBER | |||
FILE_SIZE | NUMBER | |||
CHECKSUM | NUMBER | |||
FILE_VERSION_ID | NUMBER | |||
UPDATE_SOURCE_ID | NUMBER | Yes | ||
UPDATE_TYPE | VARCHAR2 | (1) | Yes | |
CREATION_DATE | DATE | Yes | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | Yes | ||
CREATED_BY | NUMBER | Yes | ||
APPL_TOP_ID | NUMBER | |||
INCONSISTENT_FLAG | VARCHAR2 | (1) | ||
SERVER_TYPE_ADMIN_FLAG | VARCHAR2 | (1) | ||
SERVER_TYPE_FORMS_FLAG | VARCHAR2 | (1) | ||
SERVER_TYPE_NODE_FLAG | VARCHAR2 | (1) | ||
SERVER_TYPE_WEB_FLAG | VARCHAR2 | (1) | ||
DEST_FILE_ID | NUMBER | |||
FILE_TYPE_FLAG | VARCHAR2 | (1) | ||
IREP_GATHERED_FLAG | VARCHAR2 | (1) | ||
LAST_PATCHED_DATE | DATE |
Cut, paste (and edit) the following text to query this object:
SELECT SNAPSHOT_FILE_ID
, SNAPSHOT_ID
, FILE_ID
, CONTAINING_FILE_ID
, FILE_SIZE
, CHECKSUM
, FILE_VERSION_ID
, UPDATE_SOURCE_ID
, UPDATE_TYPE
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATED_BY
, APPL_TOP_ID
, INCONSISTENT_FLAG
, SERVER_TYPE_ADMIN_FLAG
, SERVER_TYPE_FORMS_FLAG
, SERVER_TYPE_NODE_FLAG
, SERVER_TYPE_WEB_FLAG
, DEST_FILE_ID
, FILE_TYPE_FLAG
, IREP_GATHERED_FLAG
, LAST_PATCHED_DATE
FROM APPLSYS.AD_SNAPSHOT_FILES#;
|
|
|