VIEW: APPS.HRI_TO_WMV_EMP_TIME_JC_V

Source

View Text - Preformatted

SELECT tomd.primary_asg_indicator primary_asg_indicator , tomd.asg_indicator asg_indicator , tomd.wmt_code wmt_code , DECODE(tomd.wmt_code, 'FTE', tomd.fte , 'HEAD', tomd.head , 'HOURS', tomd.hours , 'MONEY', tomd.money , 'PFT', tomd.pft) wmt_metric , tomd.fte fte , tomd.head head , tomd.hours hours , tomd.money money , tomd.pft pft , tomd.user1 user1 , tomd.user2 user2 , tomd.user3 user3 , tomd.user4 user4 , tomd.user5 user5 , tomd.event_date event_date , tomd.effective_start_date effective_start_date , tomd.effective_end_date effective_end_date , tomd.assignment_id assignment_id , tomd.person_id person_id , tomd.business_group_id business_group_id , tomd.organization_id organization_id , tomd.location_id location_id , tomd.job_id job_id , tomd.grade_id grade_id , tomd.position_id position_id , tomd.supervisor_person_id supervisor_person_id , tomd.payroll_id payroll_id , tomd.pay_basis_id pay_basis_id , tomd.pay_basis_id people_group_id , tomd.assignment_status_type_id assignment_status_type_id , tomd.assignment_type_code assignment_type_code , tomd.per_system_status_code per_system_status_code , tomd.pay_system_status_code pay_system_status_code , tomd.recruiter_id recruiter_id , tomd.set_of_books_id set_of_books_id , tomd.period_of_service_id period_of_service_id , tomd.employment_category_code employment_category_code , tomd.asg_primary_flag_code asg_primary_flag_code , jct.job_cat_code job_cat_code , tomd.last_change_date last_change_date , tomd.end_fii_time_year_id end_fii_time_year_id , tomd.end_fii_time_qtr_id end_fii_time_qtr_id , tomd.end_fii_time_month_id end_fii_time_month_id , tomd.end_fii_time_day_id end_fii_time_day_id , tomd.geo_area_code geo_area_code , tomd.geo_country_code geo_country_code , tomd.geo_region_code geo_region_code FROM HRI_TO_WMV_EMP_TIME_V tomd ,HRI_CS_JOBCAT_V jct WHERE tomd.job_id = jct.job_id WITH READ ONLY

View Text - HTML Formatted

SELECT TOMD.PRIMARY_ASG_INDICATOR PRIMARY_ASG_INDICATOR
, TOMD.ASG_INDICATOR ASG_INDICATOR
, TOMD.WMT_CODE WMT_CODE
, DECODE(TOMD.WMT_CODE
, 'FTE'
, TOMD.FTE
, 'HEAD'
, TOMD.HEAD
, 'HOURS'
, TOMD.HOURS
, 'MONEY'
, TOMD.MONEY
, 'PFT'
, TOMD.PFT) WMT_METRIC
, TOMD.FTE FTE
, TOMD.HEAD HEAD
, TOMD.HOURS HOURS
, TOMD.MONEY MONEY
, TOMD.PFT PFT
, TOMD.USER1 USER1
, TOMD.USER2 USER2
, TOMD.USER3 USER3
, TOMD.USER4 USER4
, TOMD.USER5 USER5
, TOMD.EVENT_DATE EVENT_DATE
, TOMD.EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, TOMD.EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, TOMD.ASSIGNMENT_ID ASSIGNMENT_ID
, TOMD.PERSON_ID PERSON_ID
, TOMD.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, TOMD.ORGANIZATION_ID ORGANIZATION_ID
, TOMD.LOCATION_ID LOCATION_ID
, TOMD.JOB_ID JOB_ID
, TOMD.GRADE_ID GRADE_ID
, TOMD.POSITION_ID POSITION_ID
, TOMD.SUPERVISOR_PERSON_ID SUPERVISOR_PERSON_ID
, TOMD.PAYROLL_ID PAYROLL_ID
, TOMD.PAY_BASIS_ID PAY_BASIS_ID
, TOMD.PAY_BASIS_ID PEOPLE_GROUP_ID
, TOMD.ASSIGNMENT_STATUS_TYPE_ID ASSIGNMENT_STATUS_TYPE_ID
, TOMD.ASSIGNMENT_TYPE_CODE ASSIGNMENT_TYPE_CODE
, TOMD.PER_SYSTEM_STATUS_CODE PER_SYSTEM_STATUS_CODE
, TOMD.PAY_SYSTEM_STATUS_CODE PAY_SYSTEM_STATUS_CODE
, TOMD.RECRUITER_ID RECRUITER_ID
, TOMD.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, TOMD.PERIOD_OF_SERVICE_ID PERIOD_OF_SERVICE_ID
, TOMD.EMPLOYMENT_CATEGORY_CODE EMPLOYMENT_CATEGORY_CODE
, TOMD.ASG_PRIMARY_FLAG_CODE ASG_PRIMARY_FLAG_CODE
, JCT.JOB_CAT_CODE JOB_CAT_CODE
, TOMD.LAST_CHANGE_DATE LAST_CHANGE_DATE
, TOMD.END_FII_TIME_YEAR_ID END_FII_TIME_YEAR_ID
, TOMD.END_FII_TIME_QTR_ID END_FII_TIME_QTR_ID
, TOMD.END_FII_TIME_MONTH_ID END_FII_TIME_MONTH_ID
, TOMD.END_FII_TIME_DAY_ID END_FII_TIME_DAY_ID
, TOMD.GEO_AREA_CODE GEO_AREA_CODE
, TOMD.GEO_COUNTRY_CODE GEO_COUNTRY_CODE
, TOMD.GEO_REGION_CODE GEO_REGION_CODE
FROM HRI_TO_WMV_EMP_TIME_V TOMD
, HRI_CS_JOBCAT_V JCT
WHERE TOMD.JOB_ID = JCT.JOB_ID WITH READ ONLY