SQL to get email address of Requisition Preparer in Oracle Fusion

 

SELECT pea.email_address
FROM   por_requisition_headers_all prha,
       per_all_people_f papf,
       per_email_addresses pea
WHERE  1 = 1
AND prha.preparer_id = papf.person_id
AND papf.primary_email_id = pea.email_address_id
AND prha.requisition_number = 'REQ_NUMBER';