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

TABLE: APPLSYS.FND_IMP_AFFECTEDFILES

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


FND_IMP_AFFECTEDFILES


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FND_IMP_AFFECTEDFILES_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSNAPSHOT_ID
ColumnPATCH_ID
ColumnPATCHED_APP_SHORT_NAME
ColumnPATCHED_DIRECTORY
ColumnPATCHED_FILENAME
Columns
Name Datatype Length Mandatory Comments
BUG_NO NUMBER

BUG_NO
SNAPSHOT_ID NUMBER

SNAPSHOT_ID
DEP_APP_SHORT_NAME VARCHAR2 (50)
DEP_APP_SHORT_NAME
DEP_DIRECTORY VARCHAR2 (256) Yes DEP_DIRECTORY
DEP_FILENAME VARCHAR2 (128) Yes DEP_FILENAME
PATCHED_APP_SHORT_NAME VARCHAR2 (50)
PATCHED_APP_SHORT_NAME
PATCHED_DIRECTORY VARCHAR2 (80)
PATCHED_DIRECTORY
PATCHED_FILENAME VARCHAR2 (90)
PATCHED_FILENAME
TYPEID VARCHAR2 (11)
TYPEID
ACTION_REQUIRED VARCHAR2 (9)
ACTION_REQUIRED
OBJECTS_AFFECTED NUMBER

OBJECTS_AFFECTED
OBJECT_TYPE VARCHAR2 (4)
OBJECT_TYPE
PATCH_ID NUMBER

Generated number to uniquely indentify (bug_no, baseline) combination
Query Text

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


SELECT BUG_NO
,      SNAPSHOT_ID
,      DEP_APP_SHORT_NAME
,      DEP_DIRECTORY
,      DEP_FILENAME
,      PATCHED_APP_SHORT_NAME
,      PATCHED_DIRECTORY
,      PATCHED_FILENAME
,      TYPEID
,      ACTION_REQUIRED
,      OBJECTS_AFFECTED
,      OBJECT_TYPE
,      PATCH_ID
FROM APPLSYS.FND_IMP_AFFECTEDFILES;

Dependencies

[top of page]

APPLSYS.FND_IMP_AFFECTEDFILES does not reference any database object

APPLSYS.FND_IMP_AFFECTEDFILES is referenced by following:

SchemaAPPS
SynonymFND_IMP_AFFECTEDFILES