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

Object Details

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

Temp table to store data to be inserted into AD_SNAPSHOT_BUGFIXES

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
BUGFIX_ID	NUMBER		Yes	Same as the bugfix_id in AD_SNAPSHOT_BUGFIXES, identifies the bugfix
BUG_STATUS	VARCHAR2	(30)	Yes	Same as the BUG_STATUS in AD_SNAPSHOT_BUGFIXES, (EXPLICIT/IMPLICIT)
SUCCESS_FLAG	VARCHAR2	(1)	Yes	Same as the SUCCESS_FLAG of AD_SNAPSHOT_BUGFIXES , Y=> the bug was successfully applied.
INCONSISTENT_FLAG	VARCHAR2	(1)		Signifies whether data is consistent across APPL_TOPS.
ACTION_FLAG	VARCHAR2	(1)		U/I => Signifies whether we update or insert into AD_SNAPSHOT_BUGFIXES.

Query Text

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


SELECT BUGFIX_ID
,      BUG_STATUS
,      SUCCESS_FLAG
,      INCONSISTENT_FLAG
,      ACTION_FLAG
FROM APPLSYS.AD_SNAPSHOT_BUGFIXES_TEMP;

Dependencies

[top of page]

APPLSYS.AD_SNAPSHOT_BUGFIXES_TEMP does not reference any database object

APPLSYS.AD_SNAPSHOT_BUGFIXES_TEMP is referenced by following:

APPLSYS: AD_SNAPSHOT_BUGFIXES_TEMP#