eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.CSC_SR_KB_NOTE_LINKS_V

Object Details

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

View Type

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.

[View Source]

Columns

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

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
,      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
FROM APPS.CSC_SR_KB_NOTE_LINKS_V;

Dependencies

[top of page]

APPS.CSC_SR_KB_NOTE_LINKS_V references the following:

APPS: FND_GLOBAL - show dependent code; JTF_COMMON_PVT - show dependent code; JTF_NOTES_PKG - show dependent code; JTF_NOTES_VL
PUBLIC: DBMS_LOB

APPS.CSC_SR_KB_NOTE_LINKS_V is not referenced by any database object