eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: APPLSYS.AD_CHECK_FILE_TEMP

Object Details

Object Name:	AD_CHECK_FILE_TEMP
Object Type:	TABLE
Owner:	APPLSYS
Subobject Name:
Status:	VALID

AD_CHECK_FILE_TEMP is a temporary staging area used to efficiently mass-load files, file-versions and/or checkfile repositories and/or file-system-snapshots.
.
FILE_ID, FILE_VERSION_ID and CHECK_FILE_ID are initially inserted as nulls, and updated later after the respective file, file-version and checkfile-repository records are identified/created.
.
JUNK is a dummy field to help manage storage space efficiently. It is purposely populated with a lengthy value that is later wiped out when the succeeding columns are updated. This helps avoid row chaining by letting Oracle allocate more space upfront for the row.
.
APP_SHORT_NAME_1, SUBDIR_1, FILENAME_1, FILE_SIZE and CHECK_SUM are currently used only when maintaining file-system-snapshots of an APPL_TOP.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
APP_SHORT_NAME	VARCHAR2	(50)	Yes	Application short name of the product owning the file
SUBDIR	VARCHAR2	(256)	Yes	Directory where the file resides (relative to the product-top)
FILENAME	VARCHAR2	(128)	Yes	File name
MANIFEST_VERS	VARCHAR2	(150)	Yes	Version of the file (to use when populating the file-versions repository)
TRANSLATION_LEVEL	NUMBER		Yes	Translation-level to use when populating the file-versions repository
EFFECTIVE_DATE	DATE		Yes	Effective date. Used to populate the creation-date WHO columns in the target tables
DISTINGUISHER	VARCHAR2	(80)		"Distinguisher" information to use when populating the checkfile-repository
JUNK	VARCHAR2	(80)		For internal use. Designed to help use storage space efficiently
FILE_ID	NUMBER			Identifies the file given by (APP_SHORT_NAME, SUBDIR, FILENAME)
FILE_VERSION_ID	NUMBER			Identifies the file-version given by (MANIFEST_VERS, TRANSLATION_LEVEL)
CHECK_FILE_ID	NUMBER			Identifies the "checkfile-repository" record for the given file and DISTINGUISHER
MANIFEST_VERS_HIGHER	VARCHAR2	(1)		Y if the version in this table is higher than what is already in the "checkfile-repository"
ACTIVE_FLAG	VARCHAR2	(1)		Y => enabled for processing
MANIFEST_VERS_2	VARCHAR2	(150)		Another kind of file-version (such as on-site version, as opposed to version in the patch), to use when populating the file-versions repository
FILE_VERSION_ID_2	NUMBER			Identifies the file-version given by MANIFEST_VERS_2
APP_SHORT_NAME_1	VARCHAR2	(50)		Application short name of the product owning the "containing" file (eg. the C archive library)
SUBDIR_1	VARCHAR2	(256)		Directory where the "containing" file resides (relative to the product-top)
FILENAME_1	VARCHAR2	(128)		Name of the "containing" file (eg. C archive library)
FILE_SIZE	NUMBER			File size in bytes
CHECK_SUM	NUMBER			For internal use only
INCONSISTENT_FLAG	VARCHAR2	(1)		For internal use only
APPL_TOP_ID	NUMBER			Appl_Top_Id
DEST_FILE_ID	NUMBER			FILE_ID of a file in its copy location
DEST_APPS_SHORT_NAME	VARCHAR2	(50)		Application Short Name of file copy destination location
DEST_SUBDIR	VARCHAR2	(256)		subdirectory of file copy destination location
DEST_FILENAME	VARCHAR2	(128)		Filename at copy destination location
FILE_TYPE_FLAG	VARCHAR2	(1)		For internal use only
SERVER_TYPE_ADMIN_FLAG	VARCHAR2	(1)		Indicates if the server is an admin server
SERVER_TYPE_FORMS_FLAG	VARCHAR2	(1)		Indicates if the server is a forms server
SERVER_TYPE_NODE_FLAG	VARCHAR2	(1)		Indicates if the server is a node server
SERVER_TYPE_WEB_FLAG	VARCHAR2	(1)		Indicates if the server is a web server
LANGUAGE	VARCHAR2	(4)		Language with which the bug number is associated.

Query Text

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


SELECT APP_SHORT_NAME
,      SUBDIR
,      FILENAME
,      MANIFEST_VERS
,      TRANSLATION_LEVEL
,      EFFECTIVE_DATE
,      DISTINGUISHER
,      JUNK
,      FILE_ID
,      FILE_VERSION_ID
,      CHECK_FILE_ID
,      MANIFEST_VERS_HIGHER
,      ACTIVE_FLAG
,      MANIFEST_VERS_2
,      FILE_VERSION_ID_2
,      APP_SHORT_NAME_1
,      SUBDIR_1
,      FILENAME_1
,      FILE_SIZE
,      CHECK_SUM
,      INCONSISTENT_FLAG
,      APPL_TOP_ID
,      DEST_FILE_ID
,      DEST_APPS_SHORT_NAME
,      DEST_SUBDIR
,      DEST_FILENAME
,      FILE_TYPE_FLAG
,      SERVER_TYPE_ADMIN_FLAG
,      SERVER_TYPE_FORMS_FLAG
,      SERVER_TYPE_NODE_FLAG
,      SERVER_TYPE_WEB_FLAG
,      LANGUAGE
FROM APPLSYS.AD_CHECK_FILE_TEMP;

Dependencies

[top of page]

APPLSYS.AD_CHECK_FILE_TEMP does not reference any database object

APPLSYS.AD_CHECK_FILE_TEMP is referenced by following:

APPS: AD_CHECK_FILE_TEMP