DBA Data[Home] [Help] [Dependency Information]

TABLE: APPLSYS.AD_SNAPSHOT_FILES_TEMP

Object Details
Object Name: AD_SNAPSHOT_FILES_TEMP
Object Type: TABLE
Owner: APPLSYS
FND Design Data: TableAD.AD_SNAPSHOT_FILES_TEMP
Subobject Name:
Status: VALID


This is a temporary table used during updation of the snapshot of the Application System.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
SNAPSHOT_FILE_ID NUMBER
Yes This column stores the snapshot_file_id for the specific file(corresponds to ad_snapshot_files).
FILE_ID NUMBER
Yes This column stores the file_id for the specific file(corresponds to ad_files)
UPDATE_SOURCE_ID NUMBER
Yes Source file_id that needs to be updated.
UPDATE_TYPE VARCHAR2 (1) Yes The update text.
INCONSISTENT_FLAG VARCHAR2 (1) Yes Flag to indicate whether the file is not at the same level in all the APPL_TOPS.
CONTAINING_FILE_ID NUMBER

The file id of the file (e.g. library modules), that contain this file.
FILE_SIZE NUMBER

Size of the file.
CHECKSUM NUMBER

Checksum computed for the file.
FILE_VERSION_ID NUMBER

This column stores the file_version_id for the specific file(corresponds to ad_file_versions).
APPL_TOP_ID NUMBER

The id of the APPL_TOP, to which this information corresponds to.
DEST_FILE_ID NUMBER

FILE_ID of a file in its copy location
FILE_TYPE_FLAG VARCHAR2 (1)
Mirror or Nomirror Flag
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SNAPSHOT_FILE_ID
,      FILE_ID
,      UPDATE_SOURCE_ID
,      UPDATE_TYPE
,      INCONSISTENT_FLAG
,      CONTAINING_FILE_ID
,      FILE_SIZE
,      CHECKSUM
,      FILE_VERSION_ID
,      APPL_TOP_ID
,      DEST_FILE_ID
,      FILE_TYPE_FLAG
FROM APPLSYS.AD_SNAPSHOT_FILES_TEMP;

Dependencies

[top of page]

APPLSYS.AD_SNAPSHOT_FILES_TEMP does not reference any database object

APPLSYS.AD_SNAPSHOT_FILES_TEMP is referenced by following:

SchemaAPPLSYS
ViewAD_SNAPSHOT_FILES_TEMP#