PER ADS Current Vacancy Details

Description
Categories: BI Publisher
Columns: Vacancy Id, Vacancy Name, Location, Job Title, Org Name, Date From, Date To, Org Description, Brief Description, Detailed Description ...
Application: Human Resources
Source: ADS Current Vacancy Details
Short Name: ADSCURVACDET
DB package:
 SELECT pav.vacancy_id 		VACANCY_ID,
  pav.name 				VACANCY_NAME,
  loc.location_code 		LOCATION,
  ipc.job_title 			JOB_TITLE,
  ipc.org_name 			ORG_NAME,
  to_char(pav.date_from,'DD-MON-YYYY')              DATE_FROM,
  to_char(pav.date_to,'DD-MON-YYYY')                DATE_TO,
  ADS_STRIPALLHTMLTAGS(ipc.org_description) 		                   ORG_DESCRIPTION,
  ADS_STRIPALLHTMLTAGS(ipc.brief_description) 	BRIEF_DESCRIPTION,
  ADS_STRIPALLHTMLTAGS(IPc.DETAILED_DESCRIPTION) 	DETAILED_DESCRIPTION,
 ADS_STRIPALLHTMLTAGS(IPc.JOB_REQUIREMENTS) 		JOB_REQUIREMENTS,
  AD