[Home] [Help] [Dependency Information]
Object Name: | JTF_NOTE_CONTEXTS |
---|---|
Object Type: | TABLE |
Owner: | JTF |
FND Design Data: | JTF.JTF_NOTE_CONTEXTS |
Subobject Name: | |
Status: | VALID |
Base table for Contexts to Notes, which are references to other objects. Where the Note's source object indicate what object created the note, Note contexts allow users to indicate what other objects are related to the note. This relationship is established with NOTE_CONTEXT_TYPE and NOTE_CONTEXT_TYPE_ID, which correspond to JTF_OBJECT code and its select id.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
JTF_NOTE_CONTEXTS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | NOTE_CONTEXT_ID |
JTF_NOTE_CONTEXTS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
NOTE_CONTEXT_TYPE_ID
NOTE_CONTEXT_TYPE |
JTF_NOTE_CONTEXTS_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | JTF_NOTE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
NOTE_CONTEXT_ID | NUMBER | Yes | Unique Identifier | |
JTF_NOTE_ID | NUMBER | Foriegn key with the JTF_NOTES | ||
NOTE_CONTEXT_TYPE | VARCHAR2 | (240) | Yes | The type of the context. Examples are LOC, CONT, EMP |
NOTE_CONTEXT_TYPE_ID | NUMBER | Yes | The corresponding ID. Can be party id, site_use_id and employee id and so on | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
SECURITY_GROUP_ID | NUMBER | Used in hosted environments |
Cut, paste (and edit) the following text to query this object:
SELECT NOTE_CONTEXT_ID
, JTF_NOTE_ID
, NOTE_CONTEXT_TYPE
, NOTE_CONTEXT_TYPE_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, SECURITY_GROUP_ID
FROM JTF.JTF_NOTE_CONTEXTS;
JTF.JTF_NOTE_CONTEXTS does not reference any database object
JTF.JTF_NOTE_CONTEXTS is referenced by following:
|
|
|