VIEW: APPS.HRI_TO_REC_VAC_CLSD_STJC_V

Source

View Text - Preformatted

SELECT vac.row_indicator row_indicator , vac.openings openings , vac.openings_wmv openings_wmv , vac.openings_filled openings_filled , vac.openings_filled_emp openings_filled_emp , vac.openings_filled_cwk openings_filled_cwk , vac.openings_filled_wmv openings_filled_wmv , vac.openings_filled_wmv_emp openings_filled_wmv_emp , vac.openings_filled_wmv_cwk openings_filled_wmv_cwk /* dates */ , vac.vacancy_open_date vacancy_open_date , vac.vacancy_close_date vacancy_close_date /* ids */ , TO_NUMBER( TO_CHAR( NVL( vac.vacancy_close_date , hr_general.end_of_time ) , 'YYYY' ) ) vac_close_fii_time_year_id , TO_CHAR( NVL( vac.vacancy_close_date , hr_general.end_of_time ) , 'YYYY' ) || TRUNC( ( TO_NUMBER( TO_CHAR( NVL( vac.vacancy_close_date , hr_general.end_of_time ) , 'MM' ) ) + 5 ) / 6 ) vac_close_fii_time_semiyear_id , TO_NUMBER( TO_CHAR( NVL( vac.vacancy_close_date , hr_general.end_of_time ) , 'YYYYQ' ) ) vac_close_fii_time_qtr_id , TO_CHAR( NVL( vac.vacancy_close_date , hr_general.end_of_time ) , 'YYYY' ) || TRUNC( ( TO_NUMBER( TO_CHAR( NVL( vac.vacancy_close_date , hr_general.end_of_time ) , 'MM' ) ) + 1 ) / 2 ) vac_close_fii_time_bimonth_id , TO_NUMBER( TO_CHAR( NVL( vac.vacancy_close_date , hr_general.end_of_time ) , 'YYYYQMM' ) ) vac_close_fii_time_month_id , NVL( vac.vacancy_close_date , hr_general.end_of_time ) vac_close_fii_time_day_id /* vacancy ids */ , vac.vacancy_business_group_id vacancy_business_group_id , vac.vacancy_organization_id vacancy_organization_id , geo.geo_area_id vacancy_geo_area_code , geo.geo_country_id vacancy_geo_country_code , geo.geo_region_id vacancy_geo_region_code , vac.vacancy_location_id vacancy_location_id , jct.job_cat_code vacancy_job_cat_code , vac.vacancy_job_id vacancy_job_id , vac.vacancy_grade_id vacancy_grade_id , vac.vacancy_position_id vacancy_position_id , vac.vacancy_id vacancy_id , vac.vacancy_category_code vacancy_category_code , vac.vacancy_status_code vacancy_status_code , vac.vacancy_wmt_code vacancy_wmt_code , vac.last_change_date last_change_date , vac.hr_security_flag_code bg_security_flag_code , vac.bg_security_flag_code bg_security_flag_code FROM /*------------------------------------*/ hri_md_rec_vac_clsd_stts_v vac , hri_cs_geo_lochr_ct geo , hri_cs_jobcat_v jct WHERE vac.vacancy_job_id = jct.job_id AND vac.vacancy_location_id = geo.location_id AND vac.hr_security_flag_code = 'Y' WITH READ ONLY

View Text - HTML Formatted

SELECT VAC.ROW_INDICATOR ROW_INDICATOR
, VAC.OPENINGS OPENINGS
, VAC.OPENINGS_WMV OPENINGS_WMV
, VAC.OPENINGS_FILLED OPENINGS_FILLED
, VAC.OPENINGS_FILLED_EMP OPENINGS_FILLED_EMP
, VAC.OPENINGS_FILLED_CWK OPENINGS_FILLED_CWK
, VAC.OPENINGS_FILLED_WMV OPENINGS_FILLED_WMV
, VAC.OPENINGS_FILLED_WMV_EMP OPENINGS_FILLED_WMV_EMP
, VAC.OPENINGS_FILLED_WMV_CWK OPENINGS_FILLED_WMV_CWK /* DATES */
, VAC.VACANCY_OPEN_DATE VACANCY_OPEN_DATE
, VAC.VACANCY_CLOSE_DATE VACANCY_CLOSE_DATE /* IDS */
, TO_NUMBER( TO_CHAR( NVL( VAC.VACANCY_CLOSE_DATE
, HR_GENERAL.END_OF_TIME )
, 'YYYY' ) ) VAC_CLOSE_FII_TIME_YEAR_ID
, TO_CHAR( NVL( VAC.VACANCY_CLOSE_DATE
, HR_GENERAL.END_OF_TIME )
, 'YYYY' ) || TRUNC( ( TO_NUMBER( TO_CHAR( NVL( VAC.VACANCY_CLOSE_DATE
, HR_GENERAL.END_OF_TIME )
, 'MM' ) ) + 5 ) / 6 ) VAC_CLOSE_FII_TIME_SEMIYEAR_ID
, TO_NUMBER( TO_CHAR( NVL( VAC.VACANCY_CLOSE_DATE
, HR_GENERAL.END_OF_TIME )
, 'YYYYQ' ) ) VAC_CLOSE_FII_TIME_QTR_ID
, TO_CHAR( NVL( VAC.VACANCY_CLOSE_DATE
, HR_GENERAL.END_OF_TIME )
, 'YYYY' ) || TRUNC( ( TO_NUMBER( TO_CHAR( NVL( VAC.VACANCY_CLOSE_DATE
, HR_GENERAL.END_OF_TIME )
, 'MM' ) ) + 1 ) / 2 ) VAC_CLOSE_FII_TIME_BIMONTH_ID
, TO_NUMBER( TO_CHAR( NVL( VAC.VACANCY_CLOSE_DATE
, HR_GENERAL.END_OF_TIME )
, 'YYYYQMM' ) ) VAC_CLOSE_FII_TIME_MONTH_ID
, NVL( VAC.VACANCY_CLOSE_DATE
, HR_GENERAL.END_OF_TIME ) VAC_CLOSE_FII_TIME_DAY_ID /* VACANCY IDS */
, VAC.VACANCY_BUSINESS_GROUP_ID VACANCY_BUSINESS_GROUP_ID
, VAC.VACANCY_ORGANIZATION_ID VACANCY_ORGANIZATION_ID
, GEO.GEO_AREA_ID VACANCY_GEO_AREA_CODE
, GEO.GEO_COUNTRY_ID VACANCY_GEO_COUNTRY_CODE
, GEO.GEO_REGION_ID VACANCY_GEO_REGION_CODE
, VAC.VACANCY_LOCATION_ID VACANCY_LOCATION_ID
, JCT.JOB_CAT_CODE VACANCY_JOB_CAT_CODE
, VAC.VACANCY_JOB_ID VACANCY_JOB_ID
, VAC.VACANCY_GRADE_ID VACANCY_GRADE_ID
, VAC.VACANCY_POSITION_ID VACANCY_POSITION_ID
, VAC.VACANCY_ID VACANCY_ID
, VAC.VACANCY_CATEGORY_CODE VACANCY_CATEGORY_CODE
, VAC.VACANCY_STATUS_CODE VACANCY_STATUS_CODE
, VAC.VACANCY_WMT_CODE VACANCY_WMT_CODE
, VAC.LAST_CHANGE_DATE LAST_CHANGE_DATE
, VAC.HR_SECURITY_FLAG_CODE BG_SECURITY_FLAG_CODE
, VAC.BG_SECURITY_FLAG_CODE BG_SECURITY_FLAG_CODE
FROM /*------------------------------------*/ HRI_MD_REC_VAC_CLSD_STTS_V VAC
, HRI_CS_GEO_LOCHR_CT GEO
, HRI_CS_JOBCAT_V JCT
WHERE VAC.VACANCY_JOB_ID = JCT.JOB_ID
AND VAC.VACANCY_LOCATION_ID = GEO.LOCATION_ID
AND VAC.HR_SECURITY_FLAG_CODE = 'Y' WITH READ ONLY