[Home] [Help] [Dependency Information]

TABLE: APPLSYS.BISM_GROUPS

Object Details

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

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: BISM_GROUPS_PK

1. USER_ID
2. GROUP_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
BISM_GROUPS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	USER_ID GROUP_ID
BISM_GROUPS_UK	NORMAL	UNIQUE	APPS_TS_TX_IDX	GROUP_ID USER_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
BISM_GROUPS		BISM_SUBJECTS	BISM_GROUPS GROUP_ID
BISM_GROUPS		BISM_SUBJECTS	BISM_GROUPS USER_ID

Columns

Query Text

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

SELECT USER_ID
,      GROUP_ID
FROM APPLSYS.BISM_GROUPS;

Dependencies

[top of page]

APPLSYS.BISM_GROUPS does not reference any database object

APPLSYS.BISM_GROUPS is referenced by following:

APPLSYS

BISM_GROUPS#