VIEW: APPS.HRI_TO_WMV_EMP_TIME_V

Source

View Text - Preformatted

SELECT wmv.primary_asg_indicator primary_asg_indicator , wmv.asg_indicator asg_indicator , WMT.ID wmt_code , DECODE(WMT.ID, 'FTE', wmv.fte , 'HEAD', wmv.head , 'HOURS', wmv.hours , 'MONEY', wmv.money , 'PFT', wmv.pft) wmt_metric , wmv.fte fte , wmv.head head , wmv.hours hours , wmv.money money , wmv.pft pft , wmv.user1 user1 , wmv.user2 user2 , wmv.user3 user3 , wmv.user4 user4 , wmv.user5 user5 , wmv.effective_start_date event_date , wmv.effective_start_date effective_start_date , wmv.effective_end_date effective_end_date , wmv.assignment_id assignment_id , wmv.person_id person_id , wmv.business_group_id business_group_id , wmv.organization_id organization_id , wmv.location_id location_id , wmv.job_id job_id , wmv.grade_id grade_id , wmv.position_id position_id , wmv.supervisor_person_id supervisor_person_id , wmv.payroll_id payroll_id , wmv.pay_basis_id pay_basis_id , wmv.pay_basis_id people_group_id , wmv.assignment_status_type_id assignment_status_type_id , wmv.assignment_type_code assignment_type_code , wmv.per_system_status_code per_system_status_code , wmv.pay_system_status_code pay_system_status_code , wmv.recruiter_id recruiter_id , wmv.set_of_books_id set_of_books_id , wmv.period_of_service_id period_of_service_id , wmv.employment_category_code employment_category_code , wmv.asg_primary_flag_code asg_primary_flag_code , wmv.last_change_date last_change_date , tdim.year_end_id end_fii_time_year_id , tdim.quarter_end_id end_fii_time_qtr_id , tdim.month_end_id end_fii_time_month_id , tdim.day_end_id end_fii_time_day_id , geo.area_code geo_area_code , geo.area_code||'+'||geo.country_code geo_country_code , geo.area_code||'+'||geo.country_code ||'+'||geo.region_code geo_region_code FROM HRI_MB_WMV_V wmv ,HRI_CS_TIME_GRGRN_CLNDR_V tdim ,HRI_CL_WMT_X_V wmt ,HRI_CS_GEO_LOCHR_CT geo WHERE tdim.day_end_id BETWEEN wmv.wmv_effective_start_date AND wmv.wmv_effective_end_date AND wmv.location_id = geo.location_id AND wmv.assignment_type_code = 'E' WITH READ ONLY

View Text - HTML Formatted

SELECT WMV.PRIMARY_ASG_INDICATOR PRIMARY_ASG_INDICATOR
, WMV.ASG_INDICATOR ASG_INDICATOR
, WMT.ID WMT_CODE
, DECODE(WMT.ID
, 'FTE'
, WMV.FTE
, 'HEAD'
, WMV.HEAD
, 'HOURS'
, WMV.HOURS
, 'MONEY'
, WMV.MONEY
, 'PFT'
, WMV.PFT) WMT_METRIC
, WMV.FTE FTE
, WMV.HEAD HEAD
, WMV.HOURS HOURS
, WMV.MONEY MONEY
, WMV.PFT PFT
, WMV.USER1 USER1
, WMV.USER2 USER2
, WMV.USER3 USER3
, WMV.USER4 USER4
, WMV.USER5 USER5
, WMV.EFFECTIVE_START_DATE EVENT_DATE
, WMV.EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, WMV.EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, WMV.ASSIGNMENT_ID ASSIGNMENT_ID
, WMV.PERSON_ID PERSON_ID
, WMV.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, WMV.ORGANIZATION_ID ORGANIZATION_ID
, WMV.LOCATION_ID LOCATION_ID
, WMV.JOB_ID JOB_ID
, WMV.GRADE_ID GRADE_ID
, WMV.POSITION_ID POSITION_ID
, WMV.SUPERVISOR_PERSON_ID SUPERVISOR_PERSON_ID
, WMV.PAYROLL_ID PAYROLL_ID
, WMV.PAY_BASIS_ID PAY_BASIS_ID
, WMV.PAY_BASIS_ID PEOPLE_GROUP_ID
, WMV.ASSIGNMENT_STATUS_TYPE_ID ASSIGNMENT_STATUS_TYPE_ID
, WMV.ASSIGNMENT_TYPE_CODE ASSIGNMENT_TYPE_CODE
, WMV.PER_SYSTEM_STATUS_CODE PER_SYSTEM_STATUS_CODE
, WMV.PAY_SYSTEM_STATUS_CODE PAY_SYSTEM_STATUS_CODE
, WMV.RECRUITER_ID RECRUITER_ID
, WMV.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, WMV.PERIOD_OF_SERVICE_ID PERIOD_OF_SERVICE_ID
, WMV.EMPLOYMENT_CATEGORY_CODE EMPLOYMENT_CATEGORY_CODE
, WMV.ASG_PRIMARY_FLAG_CODE ASG_PRIMARY_FLAG_CODE
, WMV.LAST_CHANGE_DATE LAST_CHANGE_DATE
, TDIM.YEAR_END_ID END_FII_TIME_YEAR_ID
, TDIM.QUARTER_END_ID END_FII_TIME_QTR_ID
, TDIM.MONTH_END_ID END_FII_TIME_MONTH_ID
, TDIM.DAY_END_ID END_FII_TIME_DAY_ID
, GEO.AREA_CODE GEO_AREA_CODE
, GEO.AREA_CODE||'+'||GEO.COUNTRY_CODE GEO_COUNTRY_CODE
, GEO.AREA_CODE||'+'||GEO.COUNTRY_CODE ||'+'||GEO.REGION_CODE GEO_REGION_CODE
FROM HRI_MB_WMV_V WMV
, HRI_CS_TIME_GRGRN_CLNDR_V TDIM
, HRI_CL_WMT_X_V WMT
, HRI_CS_GEO_LOCHR_CT GEO
WHERE TDIM.DAY_END_ID BETWEEN WMV.WMV_EFFECTIVE_START_DATE
AND WMV.WMV_EFFECTIVE_END_DATE
AND WMV.LOCATION_ID = GEO.LOCATION_ID
AND WMV.ASSIGNMENT_TYPE_CODE = 'E' WITH READ ONLY