[Home] [Help] [Dependency Information]

TABLE: APPLSYS.BISM_OBJECTS

Object Details

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

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: BISM_OBJECTS_PK

1. OBJECT_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
BISM_OBJECTS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	OBJECT_ID
BISM_OBJECTS_UK1	NORMAL	UNIQUE	APPS_TS_TX_IDX	FOLDER_ID OBJECT_NAME USER_VISIBLE
BISM_OBJECTS_UK2	NORMAL	UNIQUE	APPS_TS_TX_IDX	OBJECT_ID FOLDER_ID
BISM_OBJECTS_UK3	NORMAL	UNIQUE	APPS_TS_TX_IDX	FOLDER_ID OBJECT_ID
SYS_IL0000359098C00017$$	LOB	UNIQUE	APPS_TS_TX_DATA
SYS_IL0000359098C00023$$	LOB	UNIQUE	APPS_TS_TX_DATA
BISM_OBJECTS_CID	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CONTAINER_ID
BISM_OBJECTS_FID	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	FOLDER_ID
BISM_OBJECTS_K4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	FOLDER_ID OBJECT_TYPE_ID USER_VISIBLE

Foreign Keys

Table		Foreign Table	Foreign Key Column
BISM_OBJECTS		BISM_OBJECTS	BISM_OBJECTS FOLDER_ID
BISM_OBJECTS		BISM_OBJECTS	BISM_OBJECTS CONTAINER_ID
BISM_OBJECTS		BISM_OBJECT_TYPES	BISM_OBJECTS OBJECT_TYPE_ID
BISM_OBJECTS		BISM_SUBJECTS	BISM_OBJECTS LAST_MODIFIED_BY
BISM_OBJECTS		BISM_SUBJECTS	BISM_OBJECTS CREATED_BY
BISM_AGGREGATES		BISM_OBJECTS	BISM_AGGREGATES CONTAINEE_ID
BISM_AGGREGATES		BISM_OBJECTS	BISM_AGGREGATES CONTAINER_ID
BISM_ASSOCIATES		BISM_OBJECTS	BISM_ASSOCIATES SOURCE_ID
BISM_ASSOCIATES		BISM_OBJECTS	BISM_ASSOCIATES TARGET_ID
BISM_OBJECTS		BISM_OBJECTS	BISM_OBJECTS CONTAINER_ID
BISM_OBJECTS		BISM_OBJECTS	BISM_OBJECTS FOLDER_ID
BISM_PERMISSIONS		BISM_OBJECTS	BISM_PERMISSIONS OBJECT_ID

Columns

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]

SYS

STANDARD - show dependent code

XMLTYPE

APPS

BISM_ASSIGN_PRIVS

BISM_OBJECTS