DBA Data[Home] [Help] [Dependency Information]


TABLE: ENG.ENG_SUBJECTS_B

Object Details
Object Name: ENG_SUBJECTS_B
Object Type: TABLE
Owner: ENG
FND Design Data: TableENG.ENG_SUBJECTS_B
Subobject Name:
Status: VALID


Stores subject information


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
ENG_SUBJECTS_B_U1 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnSUBJECT_ID
Columns
Name Datatype Length Mandatory Comments
SUBJECT_ID NUMBER
Yes Subject internal identifier
SUBJECT_INTERNAL_NAME VARCHAR2 (30) Yes Subject internal name
CREATION_DATE DATE
Yes Standard WHO column
CREATED_BY NUMBER
Yes Standard WHO column
LAST_UPDATE_DATE DATE
Yes Standard WHO column
LAST_UPDATED_BY NUMBER
Yes Standard WHO column
LAST_UPDATE_LOGIN NUMBER

Standard WHO column
CREATE_REGION_URL VARCHAR2 (240)
URL that points to the create page
EDIT_REGION_URL VARCHAR2 (240)
URL that points to the edit page
VIEW_REGION_URL VARCHAR2 (240)
URL that points to the view page
SUBJECT_ACTION VARCHAR2 (30)
Indicates what action the subject is referring to, eg. attribute changes, attachment changes etc.
Query Text

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


SELECT SUBJECT_ID
,      SUBJECT_INTERNAL_NAME
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATE_REGION_URL
,      EDIT_REGION_URL
,      VIEW_REGION_URL
,      SUBJECT_ACTION
FROM ENG.ENG_SUBJECTS_B;

Dependencies

[top of page]

ENG.ENG_SUBJECTS_B does not reference any database object

ENG.ENG_SUBJECTS_B is referenced by following:

SchemaAPPS
SynonymENG_SUBJECTS_B