VIEW: APPS.HRI_MB_VACANCY_V

Source

View Text - Preformatted

SELECT TRUNC(NVL(vac.date_to,sysdate) - vac.date_from) total_days_open ,vac.number_of_openings number_of_openings ,DECODE(vac.status, 'CLOSED', DECODE(SIGN(vac.date_to - TRUNC(sysdate)), 1, 0, to_number(null), 0, 1), 0) vacancy_closed_indicator ,vac.date_from date_from ,vac.date_to date_to ,vac.budget_measurement_value budget_measurement_value ,NVL(vac.vacancy_category,'NA_EDW') vacancy_category_code ,NVL(vac.budget_measurement_type,'NA_EDW') budget_measurement_type_code ,NVL(vac.status,'NA_EDW') vacancy_status_code ,NVL(vac.security_method,'NA_EDW') security_method_code ,vac.name vacancy_name ,vac.last_update_date last_updated ,vac.business_group_id business_group_id ,NVL(vac.grade_id,-1) grade_id ,NVL(vac.job_id,-1) job_id ,NVL(vac.location_id,-1) location_id ,NVL(vac.manager_id,-1) manager_id ,vac.manager_id fk_manager_id ,NVL(vac.organization_id,-1) organization_id ,vac.organization_id fk_organization_id ,NVL(vac.people_group_id,-1) people_group_id ,NVL(vac.position_id,-1) position_id ,NVL(vac.recruiter_id,-1) recruiter_id ,vac.requisition_id requisition_id ,vac.vacancy_id vacancy_id FROM per_all_vacancies vac WITH READ ONLY

View Text - HTML Formatted

SELECT TRUNC(NVL(VAC.DATE_TO
, SYSDATE) - VAC.DATE_FROM) TOTAL_DAYS_OPEN
, VAC.NUMBER_OF_OPENINGS NUMBER_OF_OPENINGS
, DECODE(VAC.STATUS
, 'CLOSED'
, DECODE(SIGN(VAC.DATE_TO - TRUNC(SYSDATE))
, 1
, 0
, TO_NUMBER(NULL)
, 0
, 1)
, 0) VACANCY_CLOSED_INDICATOR
, VAC.DATE_FROM DATE_FROM
, VAC.DATE_TO DATE_TO
, VAC.BUDGET_MEASUREMENT_VALUE BUDGET_MEASUREMENT_VALUE
, NVL(VAC.VACANCY_CATEGORY
, 'NA_EDW') VACANCY_CATEGORY_CODE
, NVL(VAC.BUDGET_MEASUREMENT_TYPE
, 'NA_EDW') BUDGET_MEASUREMENT_TYPE_CODE
, NVL(VAC.STATUS
, 'NA_EDW') VACANCY_STATUS_CODE
, NVL(VAC.SECURITY_METHOD
, 'NA_EDW') SECURITY_METHOD_CODE
, VAC.NAME VACANCY_NAME
, VAC.LAST_UPDATE_DATE LAST_UPDATED
, VAC.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, NVL(VAC.GRADE_ID
, -1) GRADE_ID
, NVL(VAC.JOB_ID
, -1) JOB_ID
, NVL(VAC.LOCATION_ID
, -1) LOCATION_ID
, NVL(VAC.MANAGER_ID
, -1) MANAGER_ID
, VAC.MANAGER_ID FK_MANAGER_ID
, NVL(VAC.ORGANIZATION_ID
, -1) ORGANIZATION_ID
, VAC.ORGANIZATION_ID FK_ORGANIZATION_ID
, NVL(VAC.PEOPLE_GROUP_ID
, -1) PEOPLE_GROUP_ID
, NVL(VAC.POSITION_ID
, -1) POSITION_ID
, NVL(VAC.RECRUITER_ID
, -1) RECRUITER_ID
, VAC.REQUISITION_ID REQUISITION_ID
, VAC.VACANCY_ID VACANCY_ID
FROM PER_ALL_VACANCIES VAC WITH READ ONLY