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 FROM jtf_notes_vl note

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
FROM JTF_NOTES_VL NOTE