[Home] [Help] [Dependency Information]
Object Name: | CSC_SR_KB_NOTE_LINKS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | CSC.CSC_SR_KB_NOTE_LINKS_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This view combines JTF notes with knowledge management element links and set links. Columns APP_OBJ_ID and APP_OBJ_CODE refer to JTF_OBJECTS. Column RECORD_SOURCE_TYPE is used to distinguish what kind of link is established, which may be one of the following values: JTF_NOTE, KB_ELEM, KB_SOLN. Used by Oracle Support for integration from Service Requests to Knowledge Management.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID | NUMBER | Yes | ID of the note, knowledge base statement, or knowledge base solution, depending on the record source type. | |
APP_OBJ_ID | NUMBER | Yes | APP_OBJ_ID, when matched with APP_OBJ_CODE, identifies the exact record that the note, knowledge base statment, or knowledge base solution is linked to. It corresponds to the JTF_OBJECT id column, where the APP_OBJ_CODE matches the JTF_OBJECT object code. | |
APP_OBJ_CODE | VARCHAR2 | (240) | Yes | APP_OBJ_CODE, when matched with APP_OBJ_ID, identifies the exact record that the note, knowledge base statment, or knowledge base solution is linked to. It corresponds to the JTF_OBJECT object code. |
NOTE_TYPE_CODE | VARCHAR2 | (30) | Code for the type of Note, Knowledge Base Statement, or Knowledge Base Solution, depending on record source type. When the link is to a knowledge base statement, this is the note type (as viewed from the Notes perspective) that the statement type is mapped to, NOT the knowledge base statement type itself. | |
NOTE_TYPE_MEANING | VARCHAR2 | (80) | Displayed meaning of the type for the note, knowledge base statement, or knowledge base solution, depending on the record source type. When the link is to a knowledge base statement, this is the meaning of the note type (as viewed from the Notes perspective) that the statement type is mapped to, and NOT the statement type's meaning itself. | |
NOTE | VARCHAR2 | (2000) | Yes | Short text/summary of the note, knowledge base statement, or knowledge base solution. |
TRUE_STMT | CHAR | (1) | Indicates whether what's been written in the note, knowledge base statement, or solution is valid for the object that it's been linked to. | |
NOTE_ENTERED_BY_NAME | VARCHAR2 | (4000) | Name of the user who created the Note | |
NOTE_ENTERED_DATE | DATE | Yes | Date the note was created | |
CREATION_DATE | DATE | Yes | Date the note, knowledge base statement, or knowledge base solution was created. | |
CREATED_BY | NUMBER | (15) | Yes | Id of the user who created the note, knowledge base statement, or knowledge base solution. |
LAST_UPDATE_DATE | DATE | Yes | Date the note, knowledge base statement, or knowledge base solution was last updated. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Id of the user that last updated the note, knowledge base statement, or knowledge base solution. |
LAST_UPDATE_LOGIN | NUMBER | (15) | Login of the user that last updated the note, knowledge base statement, or knowledge base solution. | |
RECORD_SOURCE_TYPE | CHAR | (8) | Distinguishes whether the object is linked to a note, or a knowledge base statement, or knowledge base solution. For Notes, the value is 'JTF_NOTE'. For knowledge base statements, the value is 'KB_ELEM'. For knowledge base solutions, the value is 'KB_SOLN'. | |
NOTE_STATUS | VARCHAR2 | (1) | Status of note. | |
NOTE_STATUS_MEANING | VARCHAR2 | (80) | Yes | Meaning of note status. |
DETAIL_EXIST | VARCHAR2 | (1) | Flag to indicate whether detail exists for the note | |
NOTES_DETAIL | CLOB | (4000) | Notes Detail | |
NOTE_SOURCE | VARCHAR2 | (30) | Yes | Meaning of source object code |
NOTE_CONTEXT_TYPE_ID | NUMBER | Yes | Note Context Type Id. Can be party id, site_use_id and employee id and so on | |
NOTE_CONTEXT_TYPE | VARCHAR2 | (240) | Yes | The type of the context. Examples are LOC, CONT, EMP |
Cut, paste (and edit) the following text to query this object:
SELECT ID
, APP_OBJ_ID
, APP_OBJ_CODE
, NOTE_TYPE_CODE
, NOTE_TYPE_MEANING
, NOTE
, TRUE_STMT
, NOTE_ENTERED_BY_NAME
, NOTE_ENTERED_DATE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, RECORD_SOURCE_TYPE
, NOTE_STATUS
, NOTE_STATUS_MEANING
, DETAIL_EXIST
, NOTES_DETAIL
, NOTE_SOURCE
, NOTE_CONTEXT_TYPE_ID
, NOTE_CONTEXT_TYPE
FROM APPS.CSC_SR_KB_NOTE_LINKS_V;
APPS.CSC_SR_KB_NOTE_LINKS_V is not referenced by any database object
|
|
|