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_PROPERTIES

Object Details

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

This table stores business intelligence objects properties

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
BIS_OBJ_PROPERTIES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	OBJECT_NAME OBJECT_TYPE
SYS_IL0000323826C00014$$	LOB	UNIQUE	APPS_TS_TX_DATA
BIS_OBJ_PROPERTIES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OBJECT_TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
OBJECT_TYPE	VARCHAR2	(30)	Yes	Type of Object
OBJECT_NAME	VARCHAR2	(480)	Yes	Name of the Object
OBJECT_OWNER	VARCHAR2	(50)		Owner of the object
FAST_REFRESH_FLAG	VARCHAR2	(1)		Fast Refresh Flag
CREATED_BY	NUMBER	(15)	Yes	Who Column
CREATION_DATE	DATE		Yes	Creation date
LAST_UPDATED_BY	NUMBER	(15)	Yes	Last Updated By
LAST_UPDATE_LOGIN	NUMBER	(15)		Last Update Login
LAST_UPDATE_DATE	DATE		Yes	Last Update Date
LAST_REFRESH_DATE	DATE			Date when last refreshed
DIMENSION_FLAG	VARCHAR2	(1)		Dimension Flag
IMPLEMENTATION_FLAG	VARCHAR2	(1)		Implementation flag
CUSTOM_API	VARCHAR2	(80)		Custom Api
SNAPSHOT_LOG_SQL	CLOB	(4000)		stores MV Log sql
DROP_CREATE_INDEX_FLAG	VARCHAR2	(1)		Drop Create Index flag
MV_LOG_STATUS	VARCHAR2	(30)		MV Log Status
STATUS_TIME_STAMP	DATE			Status Time Stamp
OBJECT_CREATION_DATE	DATE			Object Creation Date

Query Text

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


SELECT OBJECT_TYPE
,      OBJECT_NAME
,      OBJECT_OWNER
,      FAST_REFRESH_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      LAST_REFRESH_DATE
,      DIMENSION_FLAG
,      IMPLEMENTATION_FLAG
,      CUSTOM_API
,      SNAPSHOT_LOG_SQL
,      DROP_CREATE_INDEX_FLAG
,      MV_LOG_STATUS
,      STATUS_TIME_STAMP
,      OBJECT_CREATION_DATE
FROM BIS.BIS_OBJ_PROPERTIES;

Dependencies

[top of page]

BIS.BIS_OBJ_PROPERTIES does not reference any database object

BIS.BIS_OBJ_PROPERTIES is referenced by following:

APPS: BIS_OBJ_PROPERTIES