APPS.IEU_UWQ_TASK_INFO_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 49

select notes, source_name USER_NAME, creation_date, note_type_meaning
from (
SELECT b.rowid ,b.jtf_note_id ,b.creation_date ,
b.created_by ,b.last_update_date ,b.last_updated_by ,
b.last_update_login ,tl.notes ,
b.entered_by ,b.entered_date ,b.source_object_id ,b.source_object_code ,
c.note_context_type_id ,c.note_context_type ,b.note_status ,fnd_status.meaning ,
res.source_name ,b.note_type ,fnd_type.meaning note_type_meaning
FROM jtf_notes_b b, jtf_notes_tl tl, jtf_note_contexts c, fnd_lookups fnd_status,
fnd_lookups fnd_type, jtf_rs_resource_extns res
WHERE b.jtf_note_id = tl.jtf_note_id and tl.language = userenv('LANG')
and b.jtf_note_id = c.jtf_note_id and b.note_type = fnd_type.lookup_code(+)
and fnd_type.lookup_type(+) = 'JTF_NOTE_TYPE'
and b.note_status = fnd_status.lookup_code(+)
and fnd_status.lookup_type(+) = 'JTF_NOTE_STATUS'
and res.user_id(+) = b.created_by
)
where NOTE_CONTEXT_TYPE  = p_object_code
and NOTE_CONTEXT_TYPE_ID = p_object_id
and creation_date > p_from_date
order by creation_date desc;

Line: 75

select notes, source_name USER_NAME, creation_date, note_type_meaning
from (
SELECT b.rowid ,b.jtf_note_id ,b.creation_date ,
b.created_by ,b.last_update_date ,b.last_updated_by ,
b.last_update_login ,tl.notes ,
b.entered_by ,b.entered_date ,b.source_object_id ,b.source_object_code ,
c.note_context_type_id ,c.note_context_type ,b.note_status ,fnd_status.meaning ,
res.source_name ,b.note_type ,fnd_type.meaning note_type_meaning
FROM jtf_notes_b b, jtf_notes_tl tl, jtf_note_contexts c, fnd_lookups fnd_status,
fnd_lookups fnd_type, jtf_rs_resource_extns res
WHERE b.jtf_note_id = tl.jtf_note_id and tl.language = userenv('LANG')
and b.jtf_note_id = c.jtf_note_id and b.note_type = fnd_type.lookup_code(+)
and fnd_type.lookup_type(+) = 'JTF_NOTE_TYPE'
and b.note_status = fnd_status.lookup_code(+)
and fnd_status.lookup_type(+) = 'JTF_NOTE_STATUS'
and res.user_id(+) = b.created_by
)
where NOTE_CONTEXT_TYPE   LIKE p_object_code
and NOTE_CONTEXT_TYPE_ID in (select customer_id
                                 from jtf_tasks_b
                                 where task_id= p_object_id
                                )
and creation_date > p_from_date
order by creation_date desc;

Line: 105

select notes, source_name USER_NAME, creation_date, note_type_meaning
from (
SELECT b.rowid ,b.jtf_note_id ,b.creation_date ,
b.created_by ,b.last_update_date ,b.last_updated_by ,
b.last_update_login ,tl.notes ,
b.entered_by ,b.entered_date ,b.source_object_id ,b.source_object_code ,
c.note_context_type_id ,c.note_context_type ,b.note_status ,fnd_status.meaning ,
res.source_name ,b.note_type ,fnd_type.meaning note_type_meaning
FROM jtf_notes_b b, jtf_notes_tl tl, jtf_note_contexts c, fnd_lookups fnd_status,
fnd_lookups fnd_type, jtf_rs_resource_extns res
WHERE b.jtf_note_id = tl.jtf_note_id and tl.language = userenv('LANG')
and b.jtf_note_id = c.jtf_note_id and b.note_type = fnd_type.lookup_code(+)
and fnd_type.lookup_type(+) = 'JTF_NOTE_TYPE'
and b.note_status = fnd_status.lookup_code(+)
and fnd_status.lookup_type(+) = 'JTF_NOTE_STATUS'
and res.user_id(+) = b.created_by
)
where NOTE_CONTEXT_TYPE  like p_object_code
and NOTE_CONTEXT_TYPE_ID = p_context_type_id
and creation_date > p_from_date
order by creation_date desc;

Line: 128

select contact_id
from jtf_task_contacts
where task_id =  p_object_id
and (primary_flag is null or primary_flag = 'Y')
order by primary_flag;