[Home] [Help] [Dependency Information]

TABLE: APPLSYS.BISM_SUBJECTS

Object Details

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

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: BISM_SUBJECTS_PK

1. SUBJECT_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
BISM_SUBJECTS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	SUBJECT_ID
BISM_SUBJECTS_UK1	NORMAL	UNIQUE	APPS_TS_TX_IDX	SUBJECT_NAME

Foreign Keys

Table		Foreign Table	Foreign Key Column
BISM_GROUPS		BISM_SUBJECTS	BISM_GROUPS GROUP_ID
BISM_GROUPS		BISM_SUBJECTS	BISM_GROUPS USER_ID
BISM_OBJECTS		BISM_SUBJECTS	BISM_OBJECTS LAST_MODIFIED_BY
BISM_OBJECTS		BISM_SUBJECTS	BISM_OBJECTS CREATED_BY
BISM_PERMISSIONS		BISM_SUBJECTS	BISM_PERMISSIONS SUBJECT_ID

Columns

Query Text

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

SELECT SUBJECT_ID
,      SUBJECT_NAME
,      SUBJECT_TYPE
FROM APPLSYS.BISM_SUBJECTS;

Dependencies

[top of page]

APPLSYS.BISM_SUBJECTS does not reference any database object

APPLSYS.BISM_SUBJECTS is referenced by following:

APPLSYS

BISM_SUBJECTS#