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


VIEW: APPS.CS_SR_KB_NOTE_LINKS_V

Object Details
Object Name: CS_SR_KB_NOTE_LINKS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCS.CS_SR_KB_NOTE_LINKS_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
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.
Query Text

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;

Dependencies

[top of page]

APPS.CS_SR_KB_NOTE_LINKS_V references the following:

SchemaAPPS
SynonymCS_KB_ELEMENTS_B
SynonymCS_KB_ELEMENTS_TL
SynonymCS_KB_ELEMENT_LINKS
SynonymCS_KB_ELE_TYPE_LINKS
SynonymCS_KB_SETS_B
ViewCS_KB_SETS_VL
SynonymCS_KB_SET_LINKS
ViewCS_KB_SET_TYPES_VL
ViewCS_LOOKUPS
PL/SQL PackageFND_GLOBAL - show dependent code
ViewFND_LOOKUPS
SynonymJTF_NOTES_B
SynonymJTF_NOTES_TL

APPS.CS_SR_KB_NOTE_LINKS_V is not referenced by any database object