Product: | PER - Human Resources |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PER_JOB_API_V |
SELECT JOB.JOB_ID
, JOB.BUSINESS_GROUP_ID
, JOB.JOB_DEFINITION_ID
, JOB.DATE_FROM
, JOB.COMMENTS
, JOB.DATE_TO
, JOB.NAME
, JOB.REQUEST_ID
, JOB.PROGRAM_APPLICATION_ID
, JOB.PROGRAM_ID
, JOB.PROGRAM_UPDATE_DATE
, 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.CREATED_BY
, JOB.CREATION_DATE
, 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.OBJECT_VERSION_NUMBER
, JOB.JOB_INFORMATION16
, JOB.JOB_INFORMATION17
, JOB.JOB_INFORMATION18
, JOB.JOB_INFORMATION19
, JOB.JOB_INFORMATION20
, JOB.BENCHMARK_JOB_FLAG
, JOB.BENCHMARK_JOB_ID
, JOB.EMP_RIGHTS_FLAG
, JOB.JOB_GROUP_ID
, JOB.APPROVAL_AUTHORITY
, JDF.ID_FLEX_NUM
, JDF.SUMMARY_FLAG
, JDF.ENABLED_FLAG
, JDF.START_DATE_ACTIVE
, JDF.END_DATE_ACTIVE
, JDF.SEGMENT1
, JDF.SEGMENT2
, JDF.SEGMENT3
, JDF.SEGMENT4
, JDF.SEGMENT5
, JDF.SEGMENT6
, JDF.SEGMENT7
, JDF.SEGMENT8
, JDF.SEGMENT9
, JDF.SEGMENT10
, JDF.SEGMENT11
, JDF.SEGMENT12
, JDF.SEGMENT13
, JDF.SEGMENT14
, JDF.SEGMENT15
, JDF.SEGMENT16
, JDF.SEGMENT17
, JDF.SEGMENT18
, JDF.SEGMENT19
, JDF.SEGMENT20
, JDF.SEGMENT21
, JDF.SEGMENT22
, JDF.SEGMENT23
, JDF.SEGMENT24
, JDF.SEGMENT25
, JDF.SEGMENT26
, JDF.SEGMENT27
, JDF.SEGMENT28
, JDF.SEGMENT29
, JDF.SEGMENT30
FROM PER_JOBS JOB
, PER_JOB_DEFINITIONS JDF
WHERE JOB.JOB_DEFINITION_ID = JDF.JOB_DEFINITION_ID