VIEW: APPS.PER_VACANCIES_V2

Source

View Text - Preformatted

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(+)

View Text - HTML Formatted

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(+)