APPS.ASO_NOTES_INT dependencies on ASO_QUOTE_HEADERS_ALL

Line 64: (select quote_header_id from aso_quote_headers_all

60: CURSOR l_notes_csr(p_object_id NUMBER, p_object_type_code VARCHAR2) IS
61: select b.jtf_note_id
62: FROM jtf_notes_b b
63: WHERE b.source_object_id IN
64: (select quote_header_id from aso_quote_headers_all
65: where quote_number = (select quote_number from aso_quote_headers_all
66: where quote_header_id = p_object_id))
67: AND b.source_object_code = 'ASO_QUOTE';
68:

Line 65: where quote_number = (select quote_number from aso_quote_headers_all

61: select b.jtf_note_id
62: FROM jtf_notes_b b
63: WHERE b.source_object_id IN
64: (select quote_header_id from aso_quote_headers_all
65: where quote_number = (select quote_number from aso_quote_headers_all
66: where quote_header_id = p_object_id))
67: AND b.source_object_code = 'ASO_QUOTE';
68:
69: BEGIN

Line 428: (select quote_header_id from aso_quote_headers_all

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))
431: AND b.source_object_code = p_object_type_code
432: AND b.jtf_note_id = t.jtf_note_id

Line 429: where quote_number = (select quote_number from aso_quote_headers_all

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))
431: AND b.source_object_code = p_object_type_code
432: AND b.jtf_note_id = t.jtf_note_id
433: AND t.language = USERENV('LANG');