VIEW: APPS.PER_JOBS_V

Source

View Text - Preformatted

SELECT job.job_id ,job.business_group_id ,job.job_definition_id ,job.date_from ,job.comments ,job.date_to ,jbt.name ,job.attribute_category ,job.attribute1 ,job.attribute2 ,job.attribute3 ,job.attribute4 ,job.attribute5 ,job.attribute6 ,job.attribute7 ,job.attribute8 ,job.attribute9 ,job.attribute10 ,job.attribute11 ,job.attribute12 ,job.attribute13 ,job.attribute14 ,job.attribute15 ,job.attribute16 ,job.attribute17 ,job.attribute18 ,job.attribute19 ,job.attribute20 ,job.last_update_date ,job.last_updated_by ,job.last_update_login ,job.creation_date ,job.created_by ,job.job_information_category ,job.job_information1 ,job.job_information2 ,job.job_information3 ,job.job_information4 ,job.job_information5 ,job.job_information6 ,job.job_information7 ,job.job_information8 ,job.job_information9 ,job.job_information10 ,job.job_information11 ,job.job_information12 ,job.job_information13 ,job.job_information14 ,job.job_information15 ,job.job_information16 ,job.job_information17 ,job.job_information18 ,job.job_information19 ,job.job_information20 ,job.object_version_number ,job.request_id ,job.program_application_id ,job.program_id ,job.program_update_date ,job.benchmark_job_flag ,job.benchmark_job_id ,job.emp_rights_flag ,job.job_group_id ,job.approval_authority from per_jobs job , per_jobs_tl jbt , per_job_groups jgr where job.job_group_id = jgr.job_group_id and jbt.job_id = job.job_id and jbt.language = userenv('LANG') and jgr.internal_name = 'HR_' || job.business_group_id

View Text - HTML Formatted

SELECT JOB.JOB_ID
, JOB.BUSINESS_GROUP_ID
, JOB.JOB_DEFINITION_ID
, JOB.DATE_FROM
, JOB.COMMENTS
, JOB.DATE_TO
, JBT.NAME
, JOB.ATTRIBUTE_CATEGORY
, JOB.ATTRIBUTE1
, JOB.ATTRIBUTE2
, JOB.ATTRIBUTE3
, JOB.ATTRIBUTE4
, JOB.ATTRIBUTE5
, JOB.ATTRIBUTE6
, JOB.ATTRIBUTE7
, JOB.ATTRIBUTE8
, JOB.ATTRIBUTE9
, JOB.ATTRIBUTE10
, JOB.ATTRIBUTE11
, JOB.ATTRIBUTE12
, JOB.ATTRIBUTE13
, JOB.ATTRIBUTE14
, JOB.ATTRIBUTE15
, JOB.ATTRIBUTE16
, JOB.ATTRIBUTE17
, JOB.ATTRIBUTE18
, JOB.ATTRIBUTE19
, JOB.ATTRIBUTE20
, JOB.LAST_UPDATE_DATE
, JOB.LAST_UPDATED_BY
, JOB.LAST_UPDATE_LOGIN
, JOB.CREATION_DATE
, JOB.CREATED_BY
, JOB.JOB_INFORMATION_CATEGORY
, JOB.JOB_INFORMATION1
, JOB.JOB_INFORMATION2
, JOB.JOB_INFORMATION3
, JOB.JOB_INFORMATION4
, JOB.JOB_INFORMATION5
, JOB.JOB_INFORMATION6
, JOB.JOB_INFORMATION7
, JOB.JOB_INFORMATION8
, JOB.JOB_INFORMATION9
, JOB.JOB_INFORMATION10
, JOB.JOB_INFORMATION11
, JOB.JOB_INFORMATION12
, JOB.JOB_INFORMATION13
, JOB.JOB_INFORMATION14
, JOB.JOB_INFORMATION15
, JOB.JOB_INFORMATION16
, JOB.JOB_INFORMATION17
, JOB.JOB_INFORMATION18
, JOB.JOB_INFORMATION19
, JOB.JOB_INFORMATION20
, JOB.OBJECT_VERSION_NUMBER
, JOB.REQUEST_ID
, JOB.PROGRAM_APPLICATION_ID
, JOB.PROGRAM_ID
, JOB.PROGRAM_UPDATE_DATE
, JOB.BENCHMARK_JOB_FLAG
, JOB.BENCHMARK_JOB_ID
, JOB.EMP_RIGHTS_FLAG
, JOB.JOB_GROUP_ID
, JOB.APPROVAL_AUTHORITY
FROM PER_JOBS JOB
, PER_JOBS_TL JBT
, PER_JOB_GROUPS JGR
WHERE JOB.JOB_GROUP_ID = JGR.JOB_GROUP_ID
AND JBT.JOB_ID = JOB.JOB_ID
AND JBT.LANGUAGE = USERENV('LANG')
AND JGR.INTERNAL_NAME = 'HR_' || JOB.BUSINESS_GROUP_ID