DBA Data[Home] [Help]

APPS.ASO_NOTES_INT dependencies on JTF_NOTES_TL

Line 230: FROM jtf_notes_b b, jtf_notes_tl t

226: lx_jtf_note_context_id NUMBER;
227:
228: CURSOR l_notes_csr(p_object_id NUMBER, p_object_type_code VARCHAR2) IS
229: select b.jtf_note_id
230: FROM jtf_notes_b b, jtf_notes_tl t
231: WHERE b.source_object_id = p_object_id
232: AND b.source_object_code = p_object_type_code
233: AND b.jtf_note_id = t.jtf_note_id
234: AND t.language = USERENV('LANG')

Line 426: FROM jtf_notes_b b, jtf_notes_tl t

422: b.attribute14 ,
423: b.attribute15 ,
424: b.context ,
425: b.note_type
426: FROM jtf_notes_b b, jtf_notes_tl t
427: WHERE b.source_object_id IN
428: (select quote_header_id from aso_quote_headers_all
429: where quote_number = (select quote_number from aso_quote_headers_all
430: where quote_header_id = p_object_id))