View: JTF_IH_NOTES_VL

Product:	JTF - CRM Foundation
Description:	Allows to view JTF Notes attched to Interactions
Implementation/DBA Data:	APPS.JTF_IH_NOTES_VL

View Text

SELECT N.NOTES
, NC.NOTE_CONTEXT_TYPE_ID
, INZ.INTERACTION_ID
FROM JTF_NOTE_CONTEXTS NC
, JTF_IH_INTERACTIONS INZ
, JTF_NOTES_VL N
WHERE NC.NOTE_CONTEXT_TYPE = 'JTF_INTERACTION'
AND NC.NOTE_CONTEXT_TYPE_ID=INZ.INTERACTION_ID
AND NC.JTF_NOTE_ID= N.JTF_NOTE_ID

Columns