View: JTF_NOTE_CONTEXTS_V

Product:	JTF - CRM Foundation
Description:	View over JTF_NOTE_CONTEXTS base table that additionally calculates the note context meaning from the note context type and note context type id.
Implementation/DBA Data:	APPS.JTF_NOTE_CONTEXTS_V

View Text

SELECT A.NOTE_CONTEXT_ID
, A.JTF_NOTE_ID
, A.NOTE_CONTEXT_TYPE
, B.NAME NOTE_CONTEXT_TYPE_MEANING
, A.NOTE_CONTEXT_TYPE_ID
, JTF_NOTES_PKG.GET_NOTE_CONTEXT_VALUE( A.NOTE_CONTEXT_TYPE
, A.NOTE_CONTEXT_TYPE_ID) NOTE_CONTEXT_VALUE
, A.LAST_UPDATE_DATE
, A.LAST_UPDATED_BY
, A.CREATION_DATE
, A.CREATED_BY
, A.LAST_UPDATE_LOGIN
FROM JTF_NOTE_CONTEXTS A
, JTF_OBJECTS_VL B
WHERE A.NOTE_CONTEXT_TYPE = B.OBJECT_CODE

Columns