eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.PER_VACANCIES_V

Source

View Text - Preformatted


SELECT VAC.ROWID ROW_ID , VAC.VACANCY_ID , VAC.BUSINESS_GROUP_ID , VAC.POSITION_ID , hr_general.decode_position_latest_name(vac.position_id, vac.date_from) 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_ALL_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') ) ))

View Text - HTML Formatted

SELECT VAC.ROWID ROW_ID
, VAC.VACANCY_ID
, VAC.BUSINESS_GROUP_ID
, VAC.POSITION_ID
, HR_GENERAL.DECODE_POSITION_LATEST_NAME(VAC.POSITION_ID
, VAC.DATE_FROM) 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_ALL_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') ) ))