[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 |