[Home] [Help] [Dependency Information]
Object Name: | CS_SR_KB_NOTE_LINKS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | CS.CS_SR_KB_NOTE_LINKS_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID | NUMBER | ID of the note, knowledge base statement, or knowledge base solution, depending on the record source type. | ||
APP_OBJ_ID | NUMBER | 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) | 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 | (40) | 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 | (100) | 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) | Short text/summary of the note, knowledge base statement, or knowledge base solution. | |
TRUE_STMT | VARCHAR2 | (30) | 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. | |
CREATION_DATE | DATE | Date the note, knowledge base statement, or knowledge base solution was created. | ||
CREATED_BY | NUMBER | (15) | Id of the user who created the note, knowledge base statement, or knowledge base solution. | |
LAST_UPDATE_DATE | DATE | Date the note, knowledge base statement, or knowledge base solution was last updated. | ||
LAST_UPDATED_BY | NUMBER | (15) | 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 | VARCHAR2 | (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) | Meaning of note status. | |
SOLUTION_ID | NUMBER | The Solution (set) identifier. Used to identify the Solution set in Knowledge base. | ||
OUTCOME | VARCHAR2 | (80) | The outcome of the solution associated to the service request. This value comes from CS_LOOKUPS. | |
SOLUTION_NUMBER | VARCHAR2 | (30) | The solution number. |
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
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, RECORD_SOURCE_TYPE
, NOTE_STATUS
, NOTE_STATUS_MEANING
, SOLUTION_ID
, OUTCOME
, SOLUTION_NUMBER
FROM APPS.CS_SR_KB_NOTE_LINKS_V;
APPS.CS_SR_KB_NOTE_LINKS_V is not referenced by any database object
|
|
|