VIEW: APPS.HXTFV_ROTATION_SCHEDULES

Source

View Text - Preformatted

SELECT /* $Header: hxtbis.odf 120.1 2005/09/26 12:49:58 jdupont noship $ */ bgrT.name business_group_name ,peo.full_name person_name ,1 person_count ,rop.name rotation_plan ,rop.description plan_description ,rop.date_from plan_start_date ,rop.date_to plan_end_date ,ros.start_date work_plan_start ,wws.name weekly_work_schedule ,wws.start_day schedule_start_day ,wws.description schedule_description ,wws.date_from schedule_start_date ,wws.date_to schedule_end_date /*******/ /* Ids */ /*******/ ,asg.assignment_id assignment_id ,asg.business_group_id business_group_id ,asg.grade_id grade_id ,asg.job_id job_id ,asg.organization_id organization_id ,asg.person_id person_id ,asg.position_id position_id ,ros.rtp_id rotation_plan_id ,ros.tws_id work_schedule_id FROM per_all_people_f peo ,per_assignments_f asg ,hxt_add_assign_info_f aif ,hxt_rotation_schedules ros ,hxt_rotation_plans rop ,hxt_weekly_work_schedules wws ,hr_all_organization_units_tl bgrT WHERE peo.person_id = asg.person_id AND asg.assignment_id = aif.assignment_id AND aif.rotation_plan = rop.id AND ros.rtp_id = rop.id AND ros.tws_id = wws.id AND bgrT.organization_id = asg.business_group_id AND bgrT.language = userenv('LANG') AND asg.business_group_id+0 = NVL(hr_general.get_business_group_id,asg.business_group_id) AND SYSDATE BETWEEN peo.effective_start_date AND peo.effective_end_date AND SYSDATE BETWEEN asg.effective_start_date AND asg.effective_end_date AND SYSDATE BETWEEN aif.effective_start_date AND aif.effective_end_date WITH READ ONLY

View Text - HTML Formatted

SELECT /* $HEADER: HXTBIS.ODF 120.1 2005/09/26 12:49:58 JDUPONT NOSHIP $ */ BGRT.NAME BUSINESS_GROUP_NAME
, PEO.FULL_NAME PERSON_NAME
, 1 PERSON_COUNT
, ROP.NAME ROTATION_PLAN
, ROP.DESCRIPTION PLAN_DESCRIPTION
, ROP.DATE_FROM PLAN_START_DATE
, ROP.DATE_TO PLAN_END_DATE
, ROS.START_DATE WORK_PLAN_START
, WWS.NAME WEEKLY_WORK_SCHEDULE
, WWS.START_DAY SCHEDULE_START_DAY
, WWS.DESCRIPTION SCHEDULE_DESCRIPTION
, WWS.DATE_FROM SCHEDULE_START_DATE
, WWS.DATE_TO SCHEDULE_END_DATE /*******/ /* IDS */ /*******/
, ASG.ASSIGNMENT_ID ASSIGNMENT_ID
, ASG.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, ASG.GRADE_ID GRADE_ID
, ASG.JOB_ID JOB_ID
, ASG.ORGANIZATION_ID ORGANIZATION_ID
, ASG.PERSON_ID PERSON_ID
, ASG.POSITION_ID POSITION_ID
, ROS.RTP_ID ROTATION_PLAN_ID
, ROS.TWS_ID WORK_SCHEDULE_ID
FROM PER_ALL_PEOPLE_F PEO
, PER_ASSIGNMENTS_F ASG
, HXT_ADD_ASSIGN_INFO_F AIF
, HXT_ROTATION_SCHEDULES ROS
, HXT_ROTATION_PLANS ROP
, HXT_WEEKLY_WORK_SCHEDULES WWS
, HR_ALL_ORGANIZATION_UNITS_TL BGRT
WHERE PEO.PERSON_ID = ASG.PERSON_ID
AND ASG.ASSIGNMENT_ID = AIF.ASSIGNMENT_ID
AND AIF.ROTATION_PLAN = ROP.ID
AND ROS.RTP_ID = ROP.ID
AND ROS.TWS_ID = WWS.ID
AND BGRT.ORGANIZATION_ID = ASG.BUSINESS_GROUP_ID
AND BGRT.LANGUAGE = USERENV('LANG')
AND ASG.BUSINESS_GROUP_ID+0 = NVL(HR_GENERAL.GET_BUSINESS_GROUP_ID
, ASG.BUSINESS_GROUP_ID)
AND SYSDATE BETWEEN PEO.EFFECTIVE_START_DATE
AND PEO.EFFECTIVE_END_DATE
AND SYSDATE BETWEEN ASG.EFFECTIVE_START_DATE
AND ASG.EFFECTIVE_END_DATE
AND SYSDATE BETWEEN AIF.EFFECTIVE_START_DATE
AND AIF.EFFECTIVE_END_DATE WITH READ ONLY