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]

VIEW: APPS.FND_IMP_PISUMMARY2_VL

Object Details

Object Name:	FND_IMP_PISUMMARY2_VL
Object Type:	VIEW
Owner:	APPS
FND Design Data:	FND.FND_IMP_PISUMMARY2_VL
Subobject Name:
Status:	VALID

View Type

MultiLingual view (a language resolved view of the data.)

FND_IMP_PISUMMARY2_VL

[View Source]

Columns

Name	Datatype	Length	Comments
SNAPSHOT_ID	NUMBER		SNAPSHOT_ID
BUG_NO	NUMBER		BUG_NO
NEW	NUMBER		NEW
UPGRADE	NUMBER		UPGRADE
OVERWRITE	NUMBER		OVERWRITE
NOT_APPLIED	NUMBER		NOT_APPLIED
INSTALL_CNT	NUMBER		INSTALL_CNT
FILES_CNT	NUMBER		FILES_CNT
BUG_RELEASE_NAME	VARCHAR2	(30)	BUG_RELEASE_NAME
BUG_APP	VARCHAR2	(50)	BUG_APP
BUG_DESC	VARCHAR2	(240)	BUG_DESC
SNAPSHOT_NAME	VARCHAR2	(80)	SNAPSHOT_NAME
SNAPSHOT_TYPE	VARCHAR2	(1)	SNAPSHOT_TYPE
APPL_TOP_ID	NUMBER		APPL_TOP_ID
APPL_TOP_NAME	VARCHAR2	(50)	APPL_TOP_NAME
APPL_TOP_DESC	VARCHAR2	(150)	APPL_TOP_DESC
PATCH_ID	NUMBER		PATCH_ID

Query Text

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


SELECT SNAPSHOT_ID
,      BUG_NO
,      NEW
,      UPGRADE
,      OVERWRITE
,      NOT_APPLIED
,      INSTALL_CNT
,      FILES_CNT
,      BUG_RELEASE_NAME
,      BUG_APP
,      BUG_DESC
,      SNAPSHOT_NAME
,      SNAPSHOT_TYPE
,      APPL_TOP_ID
,      APPL_TOP_NAME
,      APPL_TOP_DESC
,      PATCH_ID
FROM APPS.FND_IMP_PISUMMARY2_VL;

Dependencies

[top of page]

APPS.FND_IMP_PISUMMARY2_VL references the following:

APPS: AD_PM_PATCHES; FND_IMP_PISUMMARY; FND_IMP_SSUMMARY_VL; FND_UMS_BUGFIXES

APPS.FND_IMP_PISUMMARY2_VL is not referenced by any database object