IRC_REQUISITIONS_B AND PER_ALLOCATED_TASKS RELATION in oracle table and views

Summary: Need to build Onboarding - Overdue Tasks Report

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Oracle BI Publisher

Code Snippet (add any code snippets that support your topic, if applicable):

SELECT DISTINCT

PAPF.person_number Employee_Number,

ppnf.first_name ||' '|| ppnf.last_name Employee_Name,

PAT.PERFORMER_ORIG_SYS_ID,

PAT.ALLOCATED_TASK_ID,

PAT.ACTUAL_START_DATE Candidate_Start_Date,

PAT.ALLOCATED_CHECKLIST_ID JOURNEY_NUMBER,

NVL(PAT.TASK_NAME, PATT.TASK_NAME) TASK_NAME,

PAT.TARGET_END_DATE DUE_DATE,

PAT.ACTUAL_END_DATE ,

CASE