[Home] [Help] [Dependency Information]
Object Name: | OKS_NOTES_INTERFACE# |
---|---|
Object Type: | VIEW |
Owner: | OKS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
NOTES_INTERFACE_ID | NUMBER | Yes | ||
HEADER_INTERFACE_ID | NUMBER | |||
LINE_INTERFACE_ID | NUMBER | |||
NOTES | VARCHAR2 | (2000) | Yes | |
NOTES_DETAIL | CLOB | (4000) | ||
NOTE_STATUS | VARCHAR2 | (1) | ||
NOTE_TYPE | VARCHAR2 | (30) | ||
ENTERED_BY | NUMBER | (15) | Yes | |
ENTERED_DATE | DATE | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT NOTES_INTERFACE_ID
, HEADER_INTERFACE_ID
, LINE_INTERFACE_ID
, NOTES
, NOTES_DETAIL
, NOTE_STATUS
, NOTE_TYPE
, ENTERED_BY
, ENTERED_DATE
FROM OKS.OKS_NOTES_INTERFACE#;
|
|
|