[Home] [Help] [Dependency Information]
Object Name: | MSC_USER_NOTES |
---|---|
Object Type: | TABLE |
Owner: | MSC |
Subobject Name: | |
Status: | VALID |
This table is used to hold the user comments.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MSC_USER_NOTES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
PLAN_ID
NOTE_ID |
MSC_USER_NOTES_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
ENTITY_TYPE
INVENTORY_ITEM_ID TRANSACTION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
NOTE_ID | NUMBER | Yes | Note Id | |
ENTITY_TYPE | VARCHAR2 | (30) | Yes | 1.Item 2.Supply |
PLAN_ID | NUMBER | Yes | Plan id | |
SR_INSTANCE_ID | NUMBER | Sr Instance Id | ||
ORGANIZATION_ID | NUMBER | Organization Id | ||
INVENTORY_ITEM_ID | NUMBER | Inventory Item Id | ||
TRANSACTION_ID | NUMBER | transaction id of supply | ||
DEMAND_ID | NUMBER | Demand Id | ||
NOTE_TEXT1 | VARCHAR2 | (4000) | comments desc | |
LAST_UPDATE_DATE | DATE | Yes | Standard WHO Column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard WHO Column | |
CREATION_DATE | DATE | Yes | Standard WHO Column | |
CREATED_BY | NUMBER | Yes | Standard WHO Column | |
LAST_UPDATE_LOGIN | NUMBER | Standard WHO Column | ||
ASSIGNED_TO | NUMBER | User id to whome the comment is assigned to. | ||
DUE_BY | DATE | End date for the comment. | ||
STATUS | NUMBER | Comment status: 1 - Open,2 - Closed,3 - Pending, and 4 - Note |
Cut, paste (and edit) the following text to query this object:
SELECT NOTE_ID
, ENTITY_TYPE
, PLAN_ID
, SR_INSTANCE_ID
, ORGANIZATION_ID
, INVENTORY_ITEM_ID
, TRANSACTION_ID
, DEMAND_ID
, NOTE_TEXT1
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, ASSIGNED_TO
, DUE_BY
, STATUS
FROM MSC.MSC_USER_NOTES;
MSC.MSC_USER_NOTES does not reference any database object
MSC.MSC_USER_NOTES is referenced by following:
|
|
|