Tuesday, 10 February 2015

Responsibility Based Transaction in EBS master data

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