View: HRFV_VACANCIES

Product:	PER - Human Resources
Description:	Business view template from which the flexfield view is generated.
Implementation/DBA Data:	APPS.HRFV_VACANCIES

View Text

SELECT BGRT.NAME BUSINESS_GROUP_NAME
, VAC.NAME VACANCY_NAME
, VAC.DESCRIPTION DESCRIPTION
, HR_BIS.BIS_DECODE_LOOKUP('VACANCY_STATUS'
, VAC.STATUS) VACANCY_STATUS
, VAC.NUMBER_OF_OPENINGS NUMBER_OF_OPENINGS
, VAC.BUDGET_MEASUREMENT_TYPE BUDGET_MEASUREMENT_TYPE
, VAC.BUDGET_MEASUREMENT_VALUE BUDGET_MEASUREMENT_VALUE
, VAC.DATE_FROM VACANCY_START_DATE
, VAC.DATE_TO VACANCY_END_DATE
, ORGT.NAME ORGANIZATION_NAME
, JOB.NAME JOB_NAME
, POS.NAME POSITION_NAME
, GRD.NAME GRADE_NAME
, GRP.GROUP_NAME PEOPLE_GROUP
, LOCT.LOCATION_CODE LOCATION_NAME
, REQ.NAME REQUISITION_NAME
, REQ.DATE_FROM REQUISITION_START_DATE
, REQ.DATE_TO REQUISITION_END_DATE
, PEO1.FULL_NAME RAISED_BY
, PEO2.FULL_NAME RECRUITER_NAME
, '_DF:PER:PER_VACANCIES:VAC'
, REQ.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, VAC.GRADE_ID GRADE_ID
, VAC.JOB_ID JOB_ID
, VAC.LOCATION_ID LOCATION_ID
, NVL(VAC.ORGANIZATION_ID
, -1) ORGANIZATION_ID
, VAC.PEOPLE_GROUP_ID PEOPLE_GROUP_ID
, VAC.POSITION_ID POSITION_ID
, REQ.PERSON_ID RAISER_ID
, VAC.RECRUITER_ID RECRUITER_ID
, REQ.REQUISITION_ID REQUISITION_ID
, VAC.VACANCY_ID VACANCY_ID
FROM HR_ALL_ORGANIZATION_UNITS_TL ORGT
, HR_ALL_ORGANIZATION_UNITS_TL BGRT
, PAY_PEOPLE_GROUPS GRP
, PER_JOBS JOB
, PER_ALL_POSITIONS POS
, PER_GRADES GRD
, HR_LOCATIONS_ALL_TL LOCT
, PER_ALL_PEOPLE_F PEO1
, PER_ALL_PEOPLE_F PEO2
, PER_REQUISITIONS REQ
, PER_VACANCIES VAC
WHERE VAC.ORGANIZATION_ID = ORGT.ORGANIZATION_ID(+)
AND ORGT.LANGUAGE (+) = USERENV('LANG')
AND VAC.PEOPLE_GROUP_ID = GRP.PEOPLE_GROUP_ID(+)
AND VAC.JOB_ID = JOB.JOB_ID(+)
AND VAC.POSITION_ID = POS.POSITION_ID(+)
AND VAC.GRADE_ID = GRD.GRADE_ID(+)
AND VAC.LOCATION_ID = LOCT.LOCATION_ID(+)
AND LOCT.LANGUAGE (+) = USERENV('LANG')
AND VAC.REQUISITION_ID = REQ.REQUISITION_ID
AND VAC.RECRUITER_ID = PEO2.PERSON_ID(+)
AND VAC.DATE_FROM BETWEEN PEO2.EFFECTIVE_START_DATE(+)
AND PEO2.EFFECTIVE_END_DATE(+)
AND REQ.PERSON_ID = PEO1.PERSON_ID(+)
AND REQ.DATE_FROM BETWEEN PEO1.EFFECTIVE_START_DATE(+)
AND PEO1.EFFECTIVE_END_DATE(+)
AND REQ.BUSINESS_GROUP_ID = BGRT.ORGANIZATION_ID
AND BGRT.LANGUAGE = USERENV('LANG')
AND REQ.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, REQ.BUSINESS_GROUP_ID) WITH READ ONLY

Columns