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: APPLSYS.BISM_OBJECTS#

Object Details

Object Name:	BISM_OBJECTS#
Object Type:	VIEW
Owner:	APPLSYS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
USER_VISIBLE	VARCHAR2	(1)
OBJECT_TYPE_ID	NUMBER	(5)	Yes
VERSION	NUMBER	(6)
TIME_DATE_CREATED	DATE
TIME_DATE_MODIFIED	DATE
OBJECT_ID	RAW	(16)	Yes
CONTAINER_ID	RAW	(16)
FOLDER_ID	RAW	(16)	Yes
CREATED_BY	RAW	(16)	Yes
LAST_MODIFIED_BY	RAW	(16)	Yes
OBJECT_NAME	VARCHAR2	(256)	Yes
TITLE	VARCHAR2	(128)
APPLICATION	VARCHAR2	(256)
DATABASE	VARCHAR2	(256)
DESCRIPTION	VARCHAR2	(1333)
KEYWORDS	VARCHAR2	(1333)
XML	CLOB	(4000)
APPLICATION_SUBTYPE1	VARCHAR2	(32)
COMP_SUBTYPE1	VARCHAR2	(256)
COMP_SUBTYPE2	VARCHAR2	(512)
COMP_SUBTYPE3	VARCHAR2	(1333)
EXTENSIBLE_ATTRIBUTES	XMLTYPE	(64)
TIME_DATE_LAST_ACCESSED	DATE

Query Text

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


SELECT USER_VISIBLE
,      OBJECT_TYPE_ID
,      VERSION
,      TIME_DATE_CREATED
,      TIME_DATE_MODIFIED
,      OBJECT_ID
,      CONTAINER_ID
,      FOLDER_ID
,      CREATED_BY
,      LAST_MODIFIED_BY
,      OBJECT_NAME
,      TITLE
,      APPLICATION
,      DATABASE
,      DESCRIPTION
,      KEYWORDS
,      XML
,      APPLICATION_SUBTYPE1
,      COMP_SUBTYPE1
,      COMP_SUBTYPE2
,      COMP_SUBTYPE3
,      EXTENSIBLE_ATTRIBUTES
,      TIME_DATE_LAST_ACCESSED
FROM APPLSYS.BISM_OBJECTS#;

Dependencies

[top of page]

APPLSYS.BISM_OBJECTS# references the following:

APPLSYS: BISM_OBJECTS
SYS: STANDARD - show dependent code; XMLTYPE

APPLSYS.BISM_OBJECTS# is referenced by following:

APPS: BISM_ASSIGN_PRIVS; BISM_OBJECTS