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_FILES_SRC_DEST_TEMP

Object Details

Object Name:	AD_FILES_SRC_DEST_TEMP
Object Type:	TABLE
Owner:	APPLSYS
FND Design Data:	AD.AD_FILES_SRC_DEST_TEMP
Subobject Name:
Status:	VALID

A temporary table that stores the relation between a source file and its destination.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Comments
SRC_FILE_ID	NUMBER		Source File Id
SRC_APPS_SHORT_NAME	VARCHAR2	(50)	Applications Short Name of source file
SRC_SUBDIR	VARCHAR2	(256)	Source file subdirectory
SRC_FILENAME	VARCHAR2	(128)	Name of source file
DEST_FILE_ID	NUMBER		File _id of file at destination
DEST_APPS_SHORT_NAME	VARCHAR2	(50)	Applications Short Name of file at destination
DEST_SUBDIR	VARCHAR2	(256)	Subdirectory of file copy destination
DEST_FILENAME	VARCHAR2	(128)	Filename at copy destination
FILE_TYPE_FLAG	VARCHAR2	(1)	Mirror or Nomirror file

Query Text

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


SELECT SRC_FILE_ID
,      SRC_APPS_SHORT_NAME
,      SRC_SUBDIR
,      SRC_FILENAME
,      DEST_FILE_ID
,      DEST_APPS_SHORT_NAME
,      DEST_SUBDIR
,      DEST_FILENAME
,      FILE_TYPE_FLAG
FROM APPLSYS.AD_FILES_SRC_DEST_TEMP;

Dependencies

[top of page]

APPLSYS.AD_FILES_SRC_DEST_TEMP does not reference any database object

APPLSYS.AD_FILES_SRC_DEST_TEMP is referenced by following:

APPLSYS: AD_FILES_SRC_DEST_TEMP#