FND Design Data [Home] [Help]

View: PA_XLA_PER_JOBS_REF_V

Product: PA - Projects
Description:
Implementation/DBA Data: ViewAPPS.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