View: PER_JOBS_V

Product:	PER - Human Resources
Description:	Restricts on PER_JOBS table to only return Job that exist in the Default HR Job Group
Implementation/DBA Data:	APPS.PER_JOBS_V

View Text

SELECT JOB.JOB_ID
, JOB.BUSINESS_GROUP_ID
, JOB.JOB_DEFINITION_ID
, JOB.DATE_FROM
, JOB.COMMENTS
, JOB.DATE_TO
, JOB.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_JOB_GROUPS JGR
WHERE JOB.JOB_GROUP_ID = JGR.JOB_GROUP_ID
AND JGR.INTERNAL_NAME = 'HR_'||JGR.BUSINESS_GROUP_ID
AND (JGR.BUSINESS_GROUP_ID = JOB.BUSINESS_GROUP_ID OR JGR.BUSINESS_GROUP_ID IS NULL)

Columns