Preparing a custom report to fetch the requisition number for the user's along with their assignment

Summary

Preparing a custom report to fetch the requisition number for the user's along with their assignment details

Content

Hi All,

We are trying to prepare a report to pull the assignment details and pull the job requisition number for that change (Global Transfer / Transfer). For this we have used the below tables to join 

1. IRC_REQUISITIONS_B - REQUISITION_ID & REQUISITION_NUMBER

2. IRC_SUBMISSIONS  -  REQUISITION_ID & SUBMISSION_ID

3. IRC_OFFERS - SUBMISSION_ID  & ASSIGNMENT_OFFER_ID

4. PER_EMPL_OFFER_HR_TRACK - OFFER_ASG_ID (IRC_OFFERS - ASSIGNMENT_OFFER_ID) & EMP_CWK_ASG_ID

5. PER_ALL_ASSIGNMENTS_M - ASSIGNMENT_ID with EMP_CWK_ASG_ID (PER_EMPL_OFFER_HR_TRACK)