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_MENU_DEP_SUMMARY2

Object Details

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

FND_IMP_MENU_DEP_SUMMARY2

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FND_IMP_MENU_DEP_SUMMARY2_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	SNAPSHOT_ID PATCH_ID APPLICATION_SHORT_NAME
FND_IMP_MENU_DEP_SUMMARY2_N2	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	SNAPSHOT_ID PATCH_ID RESPONSIBILITY_ID
FND_IMP_MENU_DEP_SUMMARY2_N3	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	SNAPSHOT_ID PATCH_ID FORM_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
SNAPSHOT_ID	NUMBER		Yes	SNAPSHOT_ID
BUG_NO	NUMBER			BUG_NO
PATH	VARCHAR2	(2000)	Yes	Relative path of a file
FORM_NAME	VARCHAR2	(200)	Yes	FORM_NAME
USER_CNT	NUMBER		Yes	USER_CNT
APPLICATION_SHORT_NAME	VARCHAR2	(50)	Yes	APPLICATION_SHORT_NAME
RESPONSIBILITY_NAME	VARCHAR2	(100)	Yes	RESPONSIBILITY_NAME
RESPONSIBILITY_ID	NUMBER	(15)	Yes	RESPONSIBILITY_ID
DESCRIPTION	VARCHAR2	(200)		DESCRIPTION
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 SNAPSHOT_ID
,      BUG_NO
,      PATH
,      FORM_NAME
,      USER_CNT
,      APPLICATION_SHORT_NAME
,      RESPONSIBILITY_NAME
,      RESPONSIBILITY_ID
,      DESCRIPTION
,      PATCH_ID
FROM APPLSYS.FND_IMP_MENU_DEP_SUMMARY2;

Dependencies

[top of page]

APPLSYS.FND_IMP_MENU_DEP_SUMMARY2 does not reference any database object

APPLSYS.FND_IMP_MENU_DEP_SUMMARY2 is referenced by following:

APPS: FND_IMP_MENU_DEP_SUMMARY2