VIEW: APPS.JTF_NOTE_CONTEXTS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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