Job family function sql query in Oracle Fusion

Job family function sql query in Oracle Fusion

Hi friends, We are going to discuss about the Job family function sql query in Oracle Fusion. We will be share the detail sql query to extract the Jobs , Job Family and Job function code in Oracle Fusion. This is the complete sql query to extract the complete complete job details with job family and job function. This is one of the important sql query to extract the job with other details in oracle fusion. We will also share the important tables to store the Job family function details. Please find below the detail about Job family function sql query in Oracle Fusion.

Job family function sql query in Oracle Fusion

3 Important Tables in Job family function sql query in Oracle Fusion

1.per_jobs_f

2.per_jobs_f_tl

3.PER_JOB_FAMILY_F

Detail level of Job family function sql query in Oracle Fusion

Here below is the detail sql query to extract the Job family function details in oracle fusion.

SELECT pjf.JOB_CODE,pjft.NAME,

pjf.JOB_FUNCTION_CODE,pjf.JOB_FAMILY_ID,

TO_CHAR(pjf.effective_start_date,'DD-MON-YYYY') START_DATE,

a3.job_family_code

FROM   per_jobs_f pjf,

per_jobs_f_tl pjft,

PER_JOB_FAMILY_F a3

WHERE     TRUNC(SYSDATE) BETWEEN pjf.effective_start_date AND pjf.effective_end_date

AND    pjf.job_id = pjft.job_id

AND    pjft.language = 'US'

AND    TRUNC(SYSDATE) BETWEEN pjft.effective_start_date AND pjft.effective_end_date

and    pjf.job_family_id=a3.job_family_id

Job family function sql query in Oracle Fusion