[Home] [Help]
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
Name |
NOTE_CONTEXT_ID |
JTF_NOTE_ID |
NOTE_CONTEXT_TYPE |
NOTE_CONTEXT_TYPE_MEANING |
NOTE_CONTEXT_TYPE_ID |
NOTE_CONTEXT_VALUE |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_LOGIN |