View: PER_VACANCIES_V

Product:	PER - Human Resources
Description:	Used to support user interface
Implementation/DBA Data:	APPS.PER_VACANCIES_V

View Text

SELECT VAC.ROWID ROW_ID
, VAC.VACANCY_ID
, VAC.BUSINESS_GROUP_ID
, VAC.POSITION_ID
, HR_GENERAL.DECODE_POSITION_LATEST_NAME(VAC.POSITION_ID) POSITION_NAME
, VAC.JOB_ID
, JBT.NAME JOB_NAME
, VAC.GRADE_ID
, GDT.NAME GRADE_NAME
, VAC.ORGANIZATION_ID
, HOUTL.NAME ORGANIZATION_NAME
, VAC.REQUISITION_ID
, VAC.PEOPLE_GROUP_ID
, VAC.LOCATION_ID
, LOC.LOCATION_CODE LOCATION
, VAC.RECRUITER_ID
, PP1.FULL_NAME RECRUITER_NAME
, NVL(PP1.EMPLOYEE_NUMBER
, PP1.NPW_NUMBER) RECRUITER_NUMBER
, VAC.DATE_FROM
, VAC.NAME
, VAC.COMMENTS
, VAC.DATE_TO
, VAC.DESCRIPTION
, VAC.VACANCY_CATEGORY
, VAC.NUMBER_OF_OPENINGS
, VAC.STATUS
, LU.MEANING STATUS_MEANING
, VAC.BUDGET_MEASUREMENT_TYPE
, LU3.MEANING BUDGET_MEASUREMENT_MEANING
, VAC.BUDGET_MEASUREMENT_VALUE
, VAC.REQUEST_ID
, VAC.PROGRAM_APPLICATION_ID
, VAC.PROGRAM_ID
, VAC.PROGRAM_UPDATE_DATE
, VAC.ATTRIBUTE_CATEGORY
, VAC.ATTRIBUTE1
, VAC.ATTRIBUTE2
, VAC.ATTRIBUTE3
, VAC.ATTRIBUTE4
, VAC.ATTRIBUTE5
, VAC.ATTRIBUTE6
, VAC.ATTRIBUTE7
, VAC.ATTRIBUTE8
, VAC.ATTRIBUTE9
, VAC.ATTRIBUTE10
, VAC.ATTRIBUTE11
, VAC.ATTRIBUTE12
, VAC.ATTRIBUTE13
, VAC.ATTRIBUTE14
, VAC.ATTRIBUTE15
, VAC.ATTRIBUTE16
, VAC.ATTRIBUTE17
, VAC.ATTRIBUTE18
, VAC.ATTRIBUTE19
, VAC.ATTRIBUTE20
, VAC.LAST_UPDATE_DATE
, VAC.LAST_UPDATED_BY
, VAC.LAST_UPDATE_LOGIN
, VAC.CREATED_BY
, VAC.CREATION_DATE
, LU2.MEANING D_VACANCY_CATEGORY
FROM HR_ALL_ORGANIZATION_UNITS HOU
, HR_ALL_ORGANIZATION_UNITS_TL HOUTL
, PER_JOBS JOB
, PER_JOBS_TL JBT
, PER_GRADES GRA
, PER_GRADES_TL GDT
, HR_LOCATIONS LOC
, HR_LOOKUPS LU
, PER_PEOPLE_F PP1
, PER_VACANCIES VAC
, HR_LOOKUPS LU2
, HR_LOOKUPS LU3
WHERE VAC.JOB_ID = JOB.JOB_ID(+)
AND VAC.JOB_ID =JBT.JOB_ID(+)
AND JBT.LANGUAGE(+) = USERENV('LANG')
AND VAC.GRADE_ID = GRA.GRADE_ID(+)
AND VAC.GRADE_ID = GDT.GRADE_ID(+)
AND GDT.LANGUAGE(+) = USERENV('LANG')
AND VAC.ORGANIZATION_ID = HOU.ORGANIZATION_ID(+)
AND VAC.LOCATION_ID = LOC.LOCATION_ID(+)
AND LU.LOOKUP_TYPE(+) = 'VACANCY_STATUS'
AND VAC.STATUS = LU.LOOKUP_CODE(+)
AND LU2.LOOKUP_TYPE(+) = 'VACANCY_CATEGORY'
AND VAC.VACANCY_CATEGORY = LU2.LOOKUP_CODE(+)
AND LU3.LOOKUP_TYPE(+) = 'BUDGET_MEASUREMENT_TYPE'
AND VAC.BUDGET_MEASUREMENT_TYPE = LU3.LOOKUP_CODE(+)
AND VAC.RECRUITER_ID = PP1.PERSON_ID(+)
AND VAC.BUSINESS_GROUP_ID = JOB.BUSINESS_GROUP_ID(+)
AND VAC.BUSINESS_GROUP_ID = GRA.BUSINESS_GROUP_ID(+)
AND HOU.ORGANIZATION_ID = HOUTL.ORGANIZATION_ID (+)
AND DECODE (HOUTL.ORGANIZATION_ID
, NULL
, '1'
, HOUTL.LANGUAGE) = DECODE (HOUTL.ORGANIZATION_ID
, NULL
, '1'
, USERENV('LANG'))
AND (PP1.PERSON_ID IS NULL OR (PP1.EFFECTIVE_START_DATE <= ( SELECT FS.EFFECTIVE_DATE
FROM FND_SESSIONS FS
WHERE FS.SESSION_ID = USERENV('SESSIONID') )
AND PP1.EFFECTIVE_END_DATE >= ( SELECT FS.EFFECTIVE_DATE
FROM FND_SESSIONS FS
WHERE FS.SESSION_ID = USERENV('SESSIONID') ) ))

Columns