View: CS_SR_TASK_DEBRIEF_NOTES_V

Product:	CS - Service
Description:	This is the base view in the notes section of the workbench tab for Task debrief notes.
Implementation/DBA Data:	APPS.CS_SR_TASK_DEBRIEF_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_CSF_NOTE' RECORD_SOURCE_TYPE
, NOTE.NOTE_STATUS
, LKUP.MEANING NOTE_STATUS_MEANING
, CSF.DEBRIEF_HEADER_ID OBJ_ID
, CSF.DEBRIEF_NUMBER OBJ_NUMBER
, FND.USER_NAME
, CSL.MEANING || ' ' || CSF.DEBRIEF_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
, JTF_TASK_ASSIGNMENTS ASSIGN
, CS_INCIDENTS_ALL_B INC
, CSF_DEBRIEF_HEADERS CSF
, 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 TASK.SOURCE_OBJECT_TYPE_CODE = 'SR' AND TASK.SOURCE_OBJECT_ID = INC.INCIDENT_ID AND ASSIGN.TASK_ID = TASK.TASK_ID AND CSF.TASK_ASSIGNMENT_ID = ASSIGN.TASK_ASSIGNMENT_ID
AND NOTE.SOURCE_OBJECT_ID =CSF.DEBRIEF_HEADER_ID AND NOTE.SOURCE_OBJECT_CODE = 'SD' AND FND.USER_ID= NOTE.CREATED_BY AND CSL.LOOKUP_TYPE = 'CS_SR_SOURCE_TYPE' AND CSL.LOOKUP_CODE = 'DEBRIEF'

Columns