[Home] [Help]
View: PA_XLA_PER_JOBS_REF_V
View Text
SELECT JOB.JOB_ID
, JOB.NAME
, JOB.JOB_GROUP_ID
, JOB_GROUP.DISPLAYED_NAME
FROM PER_JOBS JOB
, PER_JOB_GROUPS JOB_GROUP
WHERE JOB.JOB_GROUP_ID = JOB_GROUP.JOB_GROUP_ID
Columns
Name |
JOB_ID |
JOB_NAME |
JOB_GROUP_ID |
JOB_GROUP_NAME |