[Home] [Help] [Dependency Information]
Object Name: | CSF_M_NOTES_INQ |
---|---|
Object Type: | TABLE |
Owner: | CSM |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CLID$$CS | VARCHAR2 | (30) | Name of the Client | |
JTF_NOTE_ID | NUMBER | Unique Note Identifier | ||
SOURCE_OBJECT_ID | NUMBER | Primary Key of the Source form | ||
SOURCE_OBJECT_CODE | VARCHAR2 | (4000) | Identifies the source.Linked to the lookup code in the fnd table where lookup_type is 'JTF_OBJECT_SOURCE_TYPE' | |
NOTES | VARCHAR2 | (4000) | Note data | |
NOTE_STATUS | VARCHAR2 | (1) | THis flag determined whether the note is allowed to be published on net or not | |
ENTERED_BY | NUMBER | The person who entered the note | ||
ENTERED_DATE | DATE | The date on which the note was entered | ||
NOTE_TYPE | VARCHAR2 | (30) | The type of the note. Normally user defined from the setup screen. Stored in the fnd_lookups for the lookup type of JTF_NOTE_TYPE | |
LAST_UPDATE_DATE | DATE | Standard who column | ||
DMLTYPE$$ | VARCHAR2 | (1) | Type of the DML operation performed at the client | |
SEQNO$$ | NUMBER | (10) | Sequence Nmber to uniquely identify this record, among the records, which were performed | |
TRANID$$ | NUMBER | (10) | Id of the synch session in which this record was populated | |
VERSION$$ | NUMBER | (10) | The identifier of the Version Number | |
PARENT_NOTE_ID | NUMBER | |||
CREATED_BY | NUMBER | |||
LAST_UPDATED_BY | NUMBER | |||
SERVER_LAST_UPDATE_DATE | DATE |
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
FROM CSM.CSF_M_NOTES_INQ;
CSM.CSF_M_NOTES_INQ does not reference any database object
CSM.CSF_M_NOTES_INQ is referenced by following:
|
|
|