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.FND_IMP_DEPOBJECTS

Object Details

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

FND_IMP_DEPOBJECTS

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FND_IMP_DEPOBJECTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	SNAPSHOT_ID OBJECT_TYPE OBJECT_NAME
FND_IMP_DEPOBJECTS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	OBJECT_ID
FND_IMP_DEPOBJECTS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SNAPSHOT_ID OBJECT_TYPE APP_SHORT_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
SNAPSHOT_ID	NUMBER		Yes	SNAPSHOT_ID
OBJECT_ID	NUMBER		Yes	OBJECT_ID
OBJECT_NAME	VARCHAR2	(256)	Yes	OBJECT_NAME
OBJECT_TYPE	VARCHAR2	(50)	Yes	OBJECT_TYPE
APP_SHORT_NAME	VARCHAR2	(50)		APP_SHORT_NAME
FILE_DIRECTORY	VARCHAR2	(256)		FILE_DIRECTORY
FILENAME	VARCHAR2	(128)		FILENAME
FILE_TYPE	VARCHAR2	(50)		FILE_TYPE
RCS_ID	VARCHAR2	(150)		RCS_ID
OCHKSUM	NUMBER			OCHKSUM
FCHKSUM	NUMBER			FCHKSUM
ATTRIB0	VARCHAR2	(128)		ATTRIB0
ATTRIB1	VARCHAR2	(128)		ATTRIB1
ATTRIB2	VARCHAR2	(128)		ATTRIB2
ATTRIB3	VARCHAR2	(128)		ATTRIB3
ATTRIB4	VARCHAR2	(128)		ATTRIB4
ATTRIB5	VARCHAR2	(128)		ATTRIB5
ATTRIB6	VARCHAR2	(128)		ATTRIB6
ATTRIB7	VARCHAR2	(128)		ATTRIB7
ATTRIB8	VARCHAR2	(128)		ATTRIB8
ATTRIB9	VARCHAR2	(128)		ATTRIB9
OBJECT_VERSION_NUMBER	NUMBER		Yes	OBJECT_VERSION_NUMBER
CREATED_BY	NUMBER	(15)	Yes	CREATED_BY
CREATION_DATE	DATE		Yes	CREATION_DATE
LAST_UPDATED_BY	NUMBER	(15)	Yes	LAST_UPDATED_BY
LAST_UPDATE_DATE	DATE		Yes	LAST_UPDATE_DATE
LAST_UPDATE_LOGIN	NUMBER	(15)		LAST_UPDATE_LOGIN
SECURITY_GROUP_ID	NUMBER			SECURITY_GROUP_ID

Query Text

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


SELECT SNAPSHOT_ID
,      OBJECT_ID
,      OBJECT_NAME
,      OBJECT_TYPE
,      APP_SHORT_NAME
,      FILE_DIRECTORY
,      FILENAME
,      FILE_TYPE
,      RCS_ID
,      OCHKSUM
,      FCHKSUM
,      ATTRIB0
,      ATTRIB1
,      ATTRIB2
,      ATTRIB3
,      ATTRIB4
,      ATTRIB5
,      ATTRIB6
,      ATTRIB7
,      ATTRIB8
,      ATTRIB9
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
FROM APPLSYS.FND_IMP_DEPOBJECTS;

Dependencies

[top of page]

APPLSYS.FND_IMP_DEPOBJECTS does not reference any database object

APPLSYS.FND_IMP_DEPOBJECTS is referenced by following:

APPS: FND_IMP_DEPOBJECTS