SELECT fu.user_name,
fd.responsibility_id,
ftl.responsibility_name,
fd.start_date,
fd.end_date,
aia.invoice_num,
aia.invoice_date
FROM fnd_user fu, fnd_user_resp_groups_direct fd,fnd_responsibility_tl ftl,ap_invoices_all aia
WHERE fu.user_id = fd.user_id
AND fd.RESPONSIBILITY_ID = ftl.RESPONSIBILITY_ID
AND fd.end_date IS NULL
AND fu.user_id = :p_user_id
AND (fu.user_id = aia.created_by
OR fu.user_id = aia.last_updated_by)
AND ftl.responsibility_name=' Payables Super User (Process Operations)'
No comments:
Post a Comment