DBA Data[Home] [Help] [Dependency Information]

TABLE: OKS.OKS_NOTES_INTERFACE

Object Details
Object Name: OKS_NOTES_INTERFACE
Object Type: TABLE
Owner: OKS
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OKS_NOTES_INTERFACE_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnNOTES_INTERFACE_ID
SYS_IL0000457523C00005$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
OKS_NOTES_INTERFACE_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnHEADER_INTERFACE_ID
OKS_NOTES_INTERFACE_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLINE_INTERFACE_ID
Columns
Name Datatype Length Mandatory Comments
NOTES_INTERFACE_ID NUMBER
Yes Primary key
HEADER_INTERFACE_ID NUMBER

Foreign Key reference to OKS_HEADERS_INTERFACE. HEADER_INTERFACE_ID
LINE_INTERFACE_ID NUMBER

Foreign Key reference to OKS_LINES_INTERFACE. LINE_INTERFACE_ID
NOTES VARCHAR2 (2000) Yes Notes
NOTES_DETAIL CLOB (4000)
Additional details for notes.
NOTE_STATUS VARCHAR2 (1)
Indicates whether the note is Public, Private or Publish. Foreign Key reference to �JTF_NOTE_STATUS�
NOTE_TYPE VARCHAR2 (30)
Type of Note. Foreign Key reference to �JTF_NOTE_TYPE�
ENTERED_BY NUMBER (15) Yes FND User who created the note
ENTERED_DATE DATE
Yes Date on which the FND User created the note
Query Text

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;

Dependencies

[top of page]

OKS.OKS_NOTES_INTERFACE does not reference any database object

OKS.OKS_NOTES_INTERFACE is referenced by following:

SchemaAPPS
SynonymOKS_NOTES_INTERFACE