[Home] [Help] [Dependency Information]
Object Name: | CSL_JTF_NOTES_VL_INQ |
---|---|
Object Type: | TABLE |
Owner: | CSL |
Subobject Name: | |
Status: | VALID |
Inqueue table forJTF_NOTES containing data uploaded by mobile clients
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CSLJTF_NOTES_VL_INQ_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
TRANID$$
CLID$$CS SEQNO$$ |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CLID$$CS | VARCHAR2 | (240) | Mobile username refers to FND_USER | |
JTF_NOTE_ID | NUMBER | Unique Note identifier | ||
PARENT_NOTE_ID | NUMBER | Note id of the parent of the current note | ||
SOURCE_OBJECT_ID | NUMBER | Primary Key of the source form. | ||
SOURCE_OBJECT_CODE | VARCHAR2 | (240) | Identifies the source. Linked to the lookup code in the fnd lookups table where lookup_type is 'JTF_OBJECT_SOURCE_TYPE' | |
NOTE_STATUS | VARCHAR2 | (1) | This flag determines whether the note is allowed to be published in the web or not. | |
ENTERED_BY | NUMBER | (15) | 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 fnd_lookups for the lookup type of JTF_NOTE_TYPE | |
NOTES | VARCHAR2 | (2000) | Stores actual note text. Typically will hold the entire note, or up to 2000 characters if the note is very long. | |
LANGUAGE | VARCHAR2 | (4) | Language. | |
DMLTYPE$$ | VARCHAR2 | (1) | DML code | |
SEQNO$$ | NUMBER | (10) | Oracle Lite sequence number | |
TRANID$$ | NUMBER | (10) | Transaction id | |
VERSION$$ | NUMBER | (10) | Record version | |
SOURCE_OBJECT_ID_CHAR | VARCHAR2 | (40) | Source_object_id column in char for contract_service_id |
Cut, paste (and edit) the following text to query this object:
SELECT CLID$$CS
, JTF_NOTE_ID
, PARENT_NOTE_ID
, SOURCE_OBJECT_ID
, SOURCE_OBJECT_CODE
, NOTE_STATUS
, ENTERED_BY
, ENTERED_DATE
, NOTE_TYPE
, NOTES
, LANGUAGE
, DMLTYPE$$
, SEQNO$$
, TRANID$$
, VERSION$$
, SOURCE_OBJECT_ID_CHAR
FROM CSL.CSL_JTF_NOTES_VL_INQ;
CSL.CSL_JTF_NOTES_VL_INQ does not reference any database object
CSL.CSL_JTF_NOTES_VL_INQ is referenced by following:
|
|
|