VIEW: APPS.CN_JOB_TITLES

Source

View Text - Preformatted

SELECT DISTINCT per.job_id JOB_TITLE_ID, per.NAME, upper(per.name) JOB_CODE FROM jtf_rs_job_roles jtf, per_jobs per WHERE jtf.job_id = per.job_id

View Text - HTML Formatted

SELECT DISTINCT PER.JOB_ID JOB_TITLE_ID
, PER.NAME
, UPPER(PER.NAME) JOB_CODE
FROM JTF_RS_JOB_ROLES JTF
, PER_JOBS PER
WHERE JTF.JOB_ID = PER.JOB_ID