Do you know how can I get the email of Reporting Manager from the Resource User Information section?
Summary:
Do you have an idea on how can I get the email of reporting manager in the resource user information section under Manage Users?
I am using the table jtf_rs_rep_managers_v in my Data Model however I am not getting the correct result.
Content (required):
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):
SELECT DISTINCT
HzParties.PARTY_NUMBER,
HzParties.PARTY_NAME PERSON_NAME,
ResProfiles.EMAIL_ADDRESS,
HcmUsers.USERNAME,
rsrep.parent_org_name RESOURCE_ORGANIZATION,
rsrep.PARENT_RESOURCE_ID,
rsrep.manager_email_address,
pea.email_address hr_manager_email
Tagged:
0