You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

IRC_REQUISITIONS_B AND PER_ALLOCATED_TASKS RELATION in oracle table and views

Accepted answer
280
Views
1
Comments

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 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!