View: CS_SR_TASK_NOTES_V

Product:	CS - Service
Description:	This is the base view in the notes section of the workbench tab for SR task Debrief Notes.
Implementation/DBA Data:	APPS.CS_SR_TASK_NOTES_V

View Text

SELECT INC.INCIDENT_ID
, 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
, LKCMTTYPE.MEANING NOTE_TYPE_MEANING
, NOTE_TL.NOTES NOTE
, 'T' TRUE_STMT
, NOTE.CREATION_DATE
, NOTE.CREATED_BY
, NOTE.LAST_UPDATE_DATE
, NOTE.LAST_UPDATED_BY
, NOTE.LAST_UPDATE_LOGIN
, 'JTF_TASK_NOTE' RECORD_SOURCE_TYPE
, NOTE.NOTE_STATUS
, LKUP.MEANING NOTE_STATUS_MEANING
, TASK.TASK_ID OBJ_ID
, TASK.TASK_NUMBER OBJ_NUMBER
, FND.USER_NAME
, CSL.MEANING || ' ' ||TASK.TASK_NUMBER SOURCE
, DECODE (DBMS_LOB.GETLENGTH(NOTE_TL.NOTES_DETAIL)
, 0
, 'N'
, 'Y') IS_DETAIL
FROM JTF_NOTES_B NOTE
, JTF_NOTES_TL NOTE_TL
, FND_LOOKUPS LKCMTTYPE
, FND_LOOKUPS LKUP
, JTF_TASKS_B TASK
, CS_INCIDENTS_ALL_B INC
, FND_USER FND
, CS_LOOKUPS CSL
WHERE NOTE.JTF_NOTE_ID = NOTE_TL.JTF_NOTE_ID AND NOTE_TL.LANGUAGE = USERENV ('LANG') AND LKCMTTYPE.LOOKUP_TYPE (+) = 'JTF_NOTE_TYPE' AND NOTE.NOTE_TYPE = LKCMTTYPE.LOOKUP_CODE(+) AND LKUP.LOOKUP_TYPE (+) = 'JTF_NOTE_STATUS' AND LKUP.LOOKUP_CODE(+) = NOTE.NOTE_STATUS
AND NOTE.SOURCE_OBJECT_ID =TASK.TASK_ID AND NOTE.SOURCE_OBJECT_CODE = 'TASK' AND TASK.SOURCE_OBJECT_TYPE_CODE = 'SR' AND TASK.SOURCE_OBJECT_ID=INC.INCIDENT_ID AND FND.USER_ID= NOTE.CREATED_BY AND CSL.LOOKUP_TYPE = 'CS_SR_SOURCE_TYPE' AND CSL.LOOKUP_CODE = 'TASK'

Columns