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


TABLE: APPLSYS.FND_IMP_SFILEDEP

Object Details
Object Name: FND_IMP_SFILEDEP
Object Type: TABLE
Owner: APPLSYS
FND Design Data: TableFND.FND_IMP_SFILEDEP
Subobject Name:
Status: VALID


FND_IMP_SFILEDEP


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FND_IMP_SFILEDEP_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSNAPSHOT_ID
ColumnDEP_APP_SHORT_NAME
ColumnDEP_DIRECTORY
ColumnDEP_FILENAME
FND_IMP_SFILEDEP_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSNAPSHOT_ID
ColumnAPP_SHORT_NAME
ColumnDIRECTORY
ColumnFILENAME
Columns
Name Datatype Length Mandatory Comments
SNAPSHOT_ID NUMBER

SNAPSHOT_ID
APP_SHORT_NAME VARCHAR2 (50)
APP_SHORT_NAME
DIRECTORY VARCHAR2 (256) Yes DIRECTORY
FILENAME VARCHAR2 (128) Yes FILENAME
DEP_APP_SHORT_NAME VARCHAR2 (50)
DEP_APP_SHORT_NAME
DEP_DIRECTORY VARCHAR2 (256) Yes DEP_DIRECTORY
DEP_FILENAME VARCHAR2 (128) Yes DEP_FILENAME
Query Text

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


SELECT SNAPSHOT_ID
,      APP_SHORT_NAME
,      DIRECTORY
,      FILENAME
,      DEP_APP_SHORT_NAME
,      DEP_DIRECTORY
,      DEP_FILENAME
FROM APPLSYS.FND_IMP_SFILEDEP;

Dependencies

[top of page]

APPLSYS.FND_IMP_SFILEDEP does not reference any database object

APPLSYS.FND_IMP_SFILEDEP is referenced by following:

SchemaAPPS
SynonymFND_IMP_SFILEDEP