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.CS_KB_INTEGRATION_V

Object Details

Object Name:	CS_KB_INTEGRATION_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	CS.CS_KB_INTEGRATION_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	Comments
ROW_ID	ROWID	(10)	Unique row identifier.
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	(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	(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.
KB_TYPE_ID	NUMBER	(15)	Code for the type of Note, Knowledge Base Statement, or Knowledge Base Solution, depending on record source type. When the link is to a note, this is the knowledbe base statement type (as viewed from the knowledge base perspective) that the note type is mapped to, NOT the note type itself.
KB_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 note, this is the meaning of the knowledge statement type (as viewed from the knowledge base perspective) that the note type is mapped to, and NOT the note type's meaning itself.
STATUS	VARCHAR2	(1)	Status of Note.
NOTE	VARCHAR2	(2000)	Short text/summary of the note, knowledge base statement, or knowledge base solution.
TRUE_STMT	VARCHAR2	(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.
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'.

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ROW_ID
,      ID
,      APP_OBJ_ID
,      APP_OBJ_CODE
,      NOTE_TYPE_CODE
,      NOTE_TYPE_MEANING
,      KB_TYPE_ID
,      KB_TYPE_MEANING
,      STATUS
,      NOTE
,      TRUE_STMT
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      RECORD_SOURCE_TYPE
FROM APPS.CS_KB_INTEGRATION_V;

Dependencies

[top of page]

APPS.CS_KB_INTEGRATION_V references the following:

APPS: CS_KB_ELEMENTS_B; CS_KB_ELEMENTS_TL; CS_KB_ELEMENT_LINKS; CS_KB_ELEMENT_TYPES_B; CS_KB_ELEMENT_TYPES_TL; CS_KB_ELE_TYPE_LINKS; CS_KB_SETS_B; CS_KB_SETS_TL; CS_KB_SET_LINKS; CS_KB_SET_TYPES_B; CS_KB_SET_TYPES_TL; FND_GLOBAL - show dependent code; FND_LOOKUPS; FND_LOOKUP_VALUES; JTF_NOTES_B; JTF_NOTES_TL; JTF_OBJECTS_B

APPS.CS_KB_INTEGRATION_V is not referenced by any database object