DBA Data[Home] [Help]

APPS.JTF_NOTES_UTIL_PVT dependencies on JTF_NOTE_CONTEXTS

Line 40: JTF_NOTE_CONTEXTS JNS

36: JOB.order_by_clause order_by_clause,
37: JOL.NAME note_context_type_name
38: FROM JTF_OBJECTS_TL JOL,
39: JTF_OBJECTS_B JOB,
40: JTF_NOTE_CONTEXTS JNS
41: WHERE JNS.JTF_NOTE_ID = p_note_id
42: AND JOB.OBJECT_CODE = DECODE(JNS.note_context_type,'PARTY_ORGANIZATION','PARTY',
43: 'PARTY_PERSON','PARTY','PARTY_RELATIONSHIP','PARTY',JNS.note_context_type)
44: AND JOL.OBJECT_CODE = JOB.OBJECT_CODE