SELECT N.NOTES, NC.NOTE_CONTEXT_TYPE_ID, ACT.ACTIVITY_ID FROM JTF_NOTE_CONTEXTS NC, JTF_IH_ACTIVITIES ACT, JTF_NOTES_VL N WHERE NC.NOTE_CONTEXT_TYPE = 'JTF_ACTIVITY' AND NC.NOTE_CONTEXT_TYPE_ID=ACT.ACTIVITY_ID AND NC.JTF_NOTE_ID = N.JTF_NOTE_ID
SELECT N.NOTES
, NC.NOTE_CONTEXT_TYPE_ID
, ACT.ACTIVITY_ID
FROM JTF_NOTE_CONTEXTS NC
, JTF_IH_ACTIVITIES ACT
, JTF_NOTES_VL N
WHERE NC.NOTE_CONTEXT_TYPE = 'JTF_ACTIVITY'
AND NC.NOTE_CONTEXT_TYPE_ID=ACT.ACTIVITY_ID
AND NC.JTF_NOTE_ID = N.JTF_NOTE_ID
|
|
|