View: JTF_NOTES_VL

Product:	JTF - CRM Foundation
Description:	MLS view over JTF_NOTES_B and JTF_NOTES_TL. Main view to query up all Notes related to any object.
Implementation/DBA Data:	APPS.JTF_NOTES_VL

View Text

SELECT JNB.ROWID ROW_ID
, JNB.JTF_NOTE_ID JTF_NOTE_ID
, JNB.PARENT_NOTE_ID PARENT_NOTE_ID
, JNB.SOURCE_OBJECT_ID SOURCE_OBJECT_ID
, JNB.SOURCE_OBJECT_CODE SOURCE_OBJECT_CODE
, JTF_NOTES_PKG.GET_NOTE_CONTEXT_VALUE(JNB.SOURCE_OBJECT_CODE
, JNB.SOURCE_OBJECT_ID) SOURCE_NUMBER
, JNB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, JNB.LAST_UPDATED_BY LAST_UPDATED_BY
, JNB.CREATION_DATE CREATION_DATE
, JNB.CREATED_BY CREATED_BY
, JNB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, JNT.NOTES NOTES
, JNT.NOTES_DETAIL NOTES_DETAIL
, JNB.NOTE_STATUS NOTE_STATUS
, JNB.ENTERED_BY ENTERED_BY
, JTF_COMMON_PVT.GETUSERINFO(JNB.ENTERED_BY) ENTERED_BY_NAME
, JNB.ENTERED_DATE ENTERED_DATE
, JOL.NAME SOURCE_OBJECT_MEANING
, JNB.NOTE_TYPE NOTE_TYPE
, FLS.MEANING NOTE_TYPE_MEANING
, JNB.ATTRIBUTE1 ATTRIBUTE1
, JNB.ATTRIBUTE2 ATTRIBUTE2
, JNB.ATTRIBUTE3 ATTRIBUTE3
, JNB.ATTRIBUTE4 ATTRIBUTE4
, JNB.ATTRIBUTE5 ATTRIBUTE5
, JNB.ATTRIBUTE6 ATTRIBUTE6
, JNB.ATTRIBUTE7 ATTRIBUTE7
, JNB.ATTRIBUTE8 ATTRIBUTE8
, JNB.ATTRIBUTE9 ATTRIBUTE9
, JNB.ATTRIBUTE10 ATTRIBUTE10
, JNB.ATTRIBUTE11 ATTRIBUTE11
, JNB.ATTRIBUTE12 ATTRIBUTE12
, JNB.ATTRIBUTE13 ATTRIBUTE13
, JNB.ATTRIBUTE14 ATTRIBUTE14
, JNB.ATTRIBUTE15 ATTRIBUTE15
, JNB.CONTEXT CONTEXT
, FLP.MEANING NOTE_STATUS_MEANING
, DECODE(JNB.SOURCE_OBJECT_CODE
, 'PARTY_ORGANIZATION'
, 'PARTY'
, 'PARTY_RELATIONSHIP'
, 'PARTY'
, 'PARTY_PERSON'
, 'PARTY'
, JNB.SOURCE_OBJECT_CODE) DECODED_SOURCE_CODE
, DECODE(JNB.SOURCE_OBJECT_CODE
, 'PARTY_ORGANIZATION'
, JOTL.NAME
, 'PARTY_RELATIONSHIP'
, JOTL.NAME
, 'PARTY_PERSON'
, JOTL.NAME
, JOL.NAME) DECODED_SOURCE_MEANING
FROM JTF_NOTES_B JNB
, JTF_NOTES_TL JNT
, JTF_OBJECTS_B JOB
, JTF_OBJECTS_TL JOL
, JTF_OBJECTS_TL JOTL
, FND_LOOKUPS FLS
, FND_LOOKUPS FLP
WHERE JNB.JTF_NOTE_ID = JNT.JTF_NOTE_ID
AND JNT.LANGUAGE = USERENV('LANG')
AND JOB.OBJECT_CODE = JNB.SOURCE_OBJECT_CODE
AND JOL.OBJECT_CODE = JOB.OBJECT_CODE
AND JOL.LANGUAGE = USERENV('LANG')
AND JOTL.OBJECT_CODE = 'PARTY'
AND JOTL.LANGUAGE = USERENV('LANG')
AND FLS.LOOKUP_TYPE(+) = 'JTF_NOTE_TYPE'
AND FLS.LOOKUP_CODE(+) = JNB.NOTE_TYPE
AND FLP.LOOKUP_TYPE = 'JTF_NOTE_STATUS'
AND FLP.LOOKUP_CODE = JNB.NOTE_STATUS

Columns