[Home] [Help] [Dependency Information]
Object Name: | CSF_M_NOTES_INQ# |
---|---|
Object Type: | VIEW |
Owner: | CSM |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CLID$$CS | VARCHAR2 | (30) | ||
JTF_NOTE_ID | NUMBER | |||
SOURCE_OBJECT_ID | NUMBER | |||
SOURCE_OBJECT_CODE | VARCHAR2 | (4000) | ||
NOTES | VARCHAR2 | (4000) | ||
NOTE_STATUS | VARCHAR2 | (1) | ||
ENTERED_BY | NUMBER | |||
ENTERED_DATE | DATE | |||
NOTE_TYPE | VARCHAR2 | (30) | ||
LAST_UPDATE_DATE | DATE | |||
DMLTYPE$$ | VARCHAR2 | (1) | ||
SEQNO$$ | NUMBER | |||
TRANID$$ | NUMBER | (10) | ||
VERSION$$ | NUMBER | (10) | ||
PARENT_NOTE_ID | NUMBER | |||
CREATED_BY | NUMBER | |||
LAST_UPDATED_BY | NUMBER | |||
SERVER_LAST_UPDATE_DATE | DATE | |||
SOURCE_NAME | VARCHAR2 | (360) | ||
NOTES_DETAIL | CLOB | (4000) |
Cut, paste (and edit) the following text to query this object:
SELECT CLID$$CS
, JTF_NOTE_ID
, SOURCE_OBJECT_ID
, SOURCE_OBJECT_CODE
, NOTES
, NOTE_STATUS
, ENTERED_BY
, ENTERED_DATE
, NOTE_TYPE
, LAST_UPDATE_DATE
, DMLTYPE$$
, SEQNO$$
, TRANID$$
, VERSION$$
, PARENT_NOTE_ID
, CREATED_BY
, LAST_UPDATED_BY
, SERVER_LAST_UPDATE_DATE
, SOURCE_NAME
, NOTES_DETAIL
FROM CSM.CSF_M_NOTES_INQ#;
|
|
|