VIEW: APPS.CSC_SR_KB_NOTE_LINKS_V

Source

View Text - Preformatted

SELECT note.jtf_note_id id, note.source_object_id app_obj_id, note.source_object_code app_obj_code, note.note_type note_type_code, note.note_type_meaning note_type_meaning, note.notes note, 'T' true_stmt, note.entered_by_name note_entered_by_name, note.entered_date note_entered_date, note.creation_date creation_date, note.created_by created_by, note.last_update_date last_update_date, note.last_updated_by last_updated_by, note.last_update_login last_update_login, 'JTF_NOTE' record_source_type, note.note_status note_status, note.note_status_meaning note_status_meaning, decode(dbms_lob.getlength(note.notes_detail), 0, 'N', 'Y') detail_exist, note.Notes_Detail, note.SOURCE_OBJECT_MEANING note_source, cntx.note_context_type_id note_context_type_id, cntx.note_context_type note_context_type FROM jtf_notes_vl note, jtf_note_contexts cntx WHERE note.jtf_note_id = cntx.jtf_note_id

View Text - HTML Formatted

SELECT NOTE.JTF_NOTE_ID ID
, NOTE.SOURCE_OBJECT_ID APP_OBJ_ID
, NOTE.SOURCE_OBJECT_CODE APP_OBJ_CODE
, NOTE.NOTE_TYPE NOTE_TYPE_CODE
, NOTE.NOTE_TYPE_MEANING NOTE_TYPE_MEANING
, NOTE.NOTES NOTE
, 'T' TRUE_STMT
, NOTE.ENTERED_BY_NAME NOTE_ENTERED_BY_NAME
, NOTE.ENTERED_DATE NOTE_ENTERED_DATE
, NOTE.CREATION_DATE CREATION_DATE
, NOTE.CREATED_BY CREATED_BY
, NOTE.LAST_UPDATE_DATE LAST_UPDATE_DATE
, NOTE.LAST_UPDATED_BY LAST_UPDATED_BY
, NOTE.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, 'JTF_NOTE' RECORD_SOURCE_TYPE
, NOTE.NOTE_STATUS NOTE_STATUS
, NOTE.NOTE_STATUS_MEANING NOTE_STATUS_MEANING
, DECODE(DBMS_LOB.GETLENGTH(NOTE.NOTES_DETAIL)
, 0
, 'N'
, 'Y') DETAIL_EXIST
, NOTE.NOTES_DETAIL
, NOTE.SOURCE_OBJECT_MEANING NOTE_SOURCE
, CNTX.NOTE_CONTEXT_TYPE_ID NOTE_CONTEXT_TYPE_ID
, CNTX.NOTE_CONTEXT_TYPE NOTE_CONTEXT_TYPE
FROM JTF_NOTES_VL NOTE
, JTF_NOTE_CONTEXTS CNTX
WHERE NOTE.JTF_NOTE_ID = CNTX.JTF_NOTE_ID