Product: | PER - Human Resources |
---|---|
Description: | Used to support user interface |
Implementation/DBA Data: | APPS.PER_VACANCIES_V2 |
SELECT VAC.ROWID ROW_ID
, VAC.VACANCY_ID
, VAC.BUSINESS_GROUP_ID
, VAC.NAME
, VAC.POSITION_ID
, VAC.JOB_ID
, VAC.GRADE_ID
, VAC.ORGANIZATION_ID
, VAC.REQUISITION_ID
, VAC.PEOPLE_GROUP_ID
, VAC.LOCATION_ID
, VAC.RECRUITER_ID
, VAC.DATE_FROM
, VAC.DATE_TO
, VAC.VACANCY_CATEGORY
, VAC.NUMBER_OF_OPENINGS
, VAC.STATUS
, VAC.BUDGET_MEASUREMENT_TYPE
, LU1.MEANING BUDGET_MEASUREMENT_MEANING
, VAC.BUDGET_MEASUREMENT_VALUE
, VAC.LAST_UPDATE_DATE
, VAC.LAST_UPDATED_BY
, VAC.LAST_UPDATE_LOGIN
, VAC.CREATED_BY
, VAC.CREATION_DATE
, PPG.SEGMENT1
, PPG.SEGMENT2
, PPG.SEGMENT3
, PPG.SEGMENT4
, PPG.SEGMENT5
, PPG.SEGMENT6
, PPG.SEGMENT7
, PPG.SEGMENT8
, PPG.SEGMENT9
, PPG.SEGMENT10
, PPG.SEGMENT11
, PPG.SEGMENT12
, PPG.SEGMENT13
, PPG.SEGMENT14
, PPG.SEGMENT15
, PPG.SEGMENT16
, PPG.SEGMENT17
, PPG.SEGMENT18
, PPG.SEGMENT19
, PPG.SEGMENT20
, PPG.SEGMENT21
, PPG.SEGMENT22
, PPG.SEGMENT23
, PPG.SEGMENT24
, PPG.SEGMENT25
, PPG.SEGMENT26
, PPG.SEGMENT27
, PPG.SEGMENT28
, PPG.SEGMENT29
, PPG.SEGMENT30
FROM PER_VACANCIES VAC
, PAY_PEOPLE_GROUPS PPG
, HR_LOOKUPS LU1
WHERE PPG.PEOPLE_GROUP_ID(+) = VAC.PEOPLE_GROUP_ID
AND LU1.LOOKUP_TYPE (+) = 'BUDGET_MEASUREMENT_TYPE'
AND VAC.BUDGET_MEASUREMENT_TYPE = LU1.LOOKUP_CODE(+)