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: BIS.BIS_OBJ_REFRESH_HISTORY

Object Details

Object Name:	BIS_OBJ_REFRESH_HISTORY
Object Type:	TABLE
Owner:	BIS
FND Design Data:	BIS.BIS_OBJ_REFRESH_HISTORY
Subobject Name:
Status:	VALID

Stores the refresh history of BIS objects.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
BIS_OBJ_REFRESH_HISTORY_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PROG_REQUEST_ID OBJECT_NAME OBJECT_TYPE
BIS_OBJ_REFRESH_HISTORY_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OBJECT_NAME OBJECT_TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
PROG_REQUEST_ID	NUMBER		Yes	Concurrent request id for the object refresh program
OBJECT_TYPE	VARCHAR2	(30)	Yes	Object type for the object refreshed by the program
OBJECT_NAME	VARCHAR2	(480)	Yes	Object name for the object refreshed by the program
REFRESH_TYPE	VARCHAR2	(30)		The way that the object gets refreshed in current run. Incremental (INCR), initial (INIT), or consider refresh for MV or analyzed.
OBJECT_ROW_COUNT	NUMBER			The number of rows in an object
OBJECT_SPACE_USAGE	NUMBER			The space occupied by the object
TABLESPACE_NAME	VARCHAR2	(30)		The tablespace name
FREE_TABLESPACE_SIZE	NUMBER			The size of the free tablespace
CREATION_DATE	DATE		Yes	Row Creation Date (Who Column)
CREATED_BY	NUMBER		Yes	Row created by (Who Column)
LAST_UPDATE_DATE	DATE		Yes	Row Last Update date (Who Column)
LAST_UPDATED_BY	NUMBER		Yes	row Last updated by (Who Column)

Query Text

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


SELECT PROG_REQUEST_ID
,      OBJECT_TYPE
,      OBJECT_NAME
,      REFRESH_TYPE
,      OBJECT_ROW_COUNT
,      OBJECT_SPACE_USAGE
,      TABLESPACE_NAME
,      FREE_TABLESPACE_SIZE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
FROM BIS.BIS_OBJ_REFRESH_HISTORY;

Dependencies

[top of page]

BIS.BIS_OBJ_REFRESH_HISTORY does not reference any database object

BIS.BIS_OBJ_REFRESH_HISTORY is referenced by following:

APPS: BIS_OBJ_REFRESH_HISTORY