VIEW: APPS.EDWBV_HR_RQVC_VACANCY_LCV

Source

View Text - Preformatted

SELECT /* $Header: hrisvvc.odf 115.5 2001/11/01 01:21:25 pkm ship       $ */ req.requisition_pk || '-' || vcs.vacancy_id || '-' || inst.instance_code vacancy_pk ,req.requisition_pk requisition_fk ,inst.instance_code instance ,vcs.status vacancy_status_code ,hr_general.decode_lookup('VACANCY_STATUS',vcs.status) vacancy_status ,vcs.number_of_openings number_of_openings ,vcs.budget_measurement_type budget_msrmnt_type_code ,hr_general.decode_lookup('BUDGET_MEASUREMENT_TYPE',vcs.budget_measurement_type) budget_msrmnt_type ,vcs.budget_measurement_value budget_msrmnt_value ,vcs.name || '(' || bgr.name || ',' || inst.instance_code || ')' name ,vcs.name || '(' || bgr.name || ',' || inst.instance_code || ')' vacancy_dp ,vcs.business_group_id business_group_id ,vcs.requisition_id requisition_id ,vcs.vacancy_id vacancy_id ,vcs.date_from vacancy_start_date ,vcs.date_to vacancy_end_date ,'_DF:PER:PER_VACANCIES:vcs' ,vcs.creation_date creation_date ,NVL(vcs.last_update_date,to_date('01-01-2000','DD-MM-YYYY')) last_update_date FROM edw_local_instance inst ,per_all_vacancies vcs ,edw_hr_rqvc_requistn_lcv req ,hr_all_organization_units bgr WHERE vcs.requisition_id = req.requisition_id AND vcs.business_group_id = bgr.organization_id

View Text - HTML Formatted

SELECT /* $HEADER: HRISVVC.ODF 115.5 2001/11/01 01:21:25 PKM SHIP $ */ REQ.REQUISITION_PK || '-' || VCS.VACANCY_ID || '-' || INST.INSTANCE_CODE VACANCY_PK
, REQ.REQUISITION_PK REQUISITION_FK
, INST.INSTANCE_CODE INSTANCE
, VCS.STATUS VACANCY_STATUS_CODE
, HR_GENERAL.DECODE_LOOKUP('VACANCY_STATUS'
, VCS.STATUS) VACANCY_STATUS
, VCS.NUMBER_OF_OPENINGS NUMBER_OF_OPENINGS
, VCS.BUDGET_MEASUREMENT_TYPE BUDGET_MSRMNT_TYPE_CODE
, HR_GENERAL.DECODE_LOOKUP('BUDGET_MEASUREMENT_TYPE'
, VCS.BUDGET_MEASUREMENT_TYPE) BUDGET_MSRMNT_TYPE
, VCS.BUDGET_MEASUREMENT_VALUE BUDGET_MSRMNT_VALUE
, VCS.NAME || '(' || BGR.NAME || '
, ' || INST.INSTANCE_CODE || ')' NAME
, VCS.NAME || '(' || BGR.NAME || '
, ' || INST.INSTANCE_CODE || ')' VACANCY_DP
, VCS.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, VCS.REQUISITION_ID REQUISITION_ID
, VCS.VACANCY_ID VACANCY_ID
, VCS.DATE_FROM VACANCY_START_DATE
, VCS.DATE_TO VACANCY_END_DATE
, '_DF:PER:PER_VACANCIES:VCS'
, VCS.CREATION_DATE CREATION_DATE
, NVL(VCS.LAST_UPDATE_DATE
, TO_DATE('01-01-2000'
, 'DD-MM-YYYY')) LAST_UPDATE_DATE
FROM EDW_LOCAL_INSTANCE INST
, PER_ALL_VACANCIES VCS
, EDW_HR_RQVC_REQUISTN_LCV REQ
, HR_ALL_ORGANIZATION_UNITS BGR
WHERE VCS.REQUISITION_ID = REQ.REQUISITION_ID
AND VCS.BUSINESS_GROUP_ID = BGR.ORGANIZATION_ID