VIEW: APPS.HRI_MD_WMV_X_V

Source

View Text - Preformatted

SELECT wmv.primary_asg_indicator primary_asg_indicator , wmv.asg_indicator asg_indicator , 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 , CASE WHEN ( HR_SECURITY.VIEW_ALL = 'Y' OR HR_SECURITY.SHOW_RECORD( 'PER_ALL_ASSIGNMENTS_F' , wmv.assignment_id , wmv.person_id , wmv.assignment_type_code ) = 'TRUE' ) THEN 'Y' ELSE 'N' END hr_security_flag_code , CASE WHEN wmv.business_group_id = NVL(hr_bis.get_sec_profile_bg_id,wmv.business_group_id) THEN 'Y' ELSE 'N' END bg_security_flag_code , wmv.last_change_date last_change_date FROM hri_mb_wmv_v wmv WHERE TRUNC(SYSDATE) BETWEEN wmv.effective_start_date AND wmv.effective_end_date WITH READ ONLY

View Text - HTML Formatted

SELECT WMV.PRIMARY_ASG_INDICATOR PRIMARY_ASG_INDICATOR
, WMV.ASG_INDICATOR ASG_INDICATOR
, 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
, CASE WHEN ( HR_SECURITY.VIEW_ALL = 'Y' OR HR_SECURITY.SHOW_RECORD( 'PER_ALL_ASSIGNMENTS_F'
, WMV.ASSIGNMENT_ID
, WMV.PERSON_ID
, WMV.ASSIGNMENT_TYPE_CODE ) = 'TRUE' ) THEN 'Y' ELSE 'N' END HR_SECURITY_FLAG_CODE
, CASE WHEN WMV.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, WMV.BUSINESS_GROUP_ID) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
, WMV.LAST_CHANGE_DATE LAST_CHANGE_DATE
FROM HRI_MB_WMV_V WMV
WHERE TRUNC(SYSDATE) BETWEEN WMV.EFFECTIVE_START_DATE
AND WMV.EFFECTIVE_END_DATE WITH READ ONLY