[Home] [Help] [Dependency Information]
Object Name: | ENG_SUBJECTS_B |
---|---|
Object Type: | TABLE |
Owner: | ENG |
FND Design Data: | ENG.ENG_SUBJECTS_B |
Subobject Name: | |
Status: | VALID |
Stores subject information
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
ENG_SUBJECTS_B_U1 | NORMAL | UNIQUE | APPS_TS_SEED | SUBJECT_ID |
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. |
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;
ENG.ENG_SUBJECTS_B does not reference any database object
ENG.ENG_SUBJECTS_B is referenced by following:
|
|
|