[Home] [Help]
SELECT /* $Header: hxtbis.odf 120.1 2005/09/26 12:49:58 jdupont noship $ */ bgrT.name business_group_name ,peo.full_name person_name ,pro.name project_name ,pro.pro_number project_number ,pro.description project_description ,pro.date_from project_start ,pro.date_to project_end ,orgT.name organization_name ,tas.name task_name ,tas.description task_description ,tas.estimated_time task_estimated_time ,hr_general.decode_lookup('HXT_TASK_UNITS',tas.fcl_units) task_units ,tas.task_number task_number ,tas.date_from task_start ,tas.date_to task_end ,dhw.date_worked date_worked ,dhw.hours hours ,dhw.time_in time_in ,dhw.time_out time_out ,dhw.hrw_comment hrw_comment ,dhw.rate_multiple rate_multiple ,dhw.hourly_rate hourly_rate ,dhw.amount amount /*******/ /* Ids */ /*******/ ,dhw.assignment_id assignment_id ,asg.business_group_id business_group_id ,dhw.id det_hours_worked_id ,dhw.earn_pol_id earning_policy_id ,dhw.element_type_id element_type_id ,dhw.job_id job_id ,dhw.location_id location_id ,pro.organization_id organization_id ,asg.person_id person_id ,tas.pro_id project_id ,dhw.sht_id shift_id ,dhw.parent_id sum_hours_worked_id ,dhw.tim_id timecard_id ,dhw.tas_id task_id FROM per_all_people_f peo ,per_assignments_f asg ,hxt_det_hours_worked_f dhw ,hxt_tasks tas ,hxt_projects pro ,hr_all_organization_units_tl orgT ,hr_all_organization_units_tl bgrT WHERE SYSDATE BETWEEN dhw.effective_start_date AND dhw.effective_end_date 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 peo.person_id = asg.person_id AND asg.assignment_id = dhw.assignment_id AND dhw.tas_id = tas.id AND tas.pro_id = pro.id AND asg.business_group_id = bgrT.organization_id AND bgrT.language = userenv('LANG') AND asg.business_group_id+0 = NVL(hr_general.get_business_group_id,asg.business_group_id) AND pro.organization_id = orgT.organization_id AND orgT.language = userenv('LANG') WITH READ ONLY
SELECT /* $HEADER: HXTBIS.ODF 120.1 2005/09/26 12:49:58 JDUPONT NOSHIP $ */ BGRT.NAME BUSINESS_GROUP_NAME
, PEO.FULL_NAME PERSON_NAME
, PRO.NAME PROJECT_NAME
, PRO.PRO_NUMBER PROJECT_NUMBER
, PRO.DESCRIPTION PROJECT_DESCRIPTION
, PRO.DATE_FROM PROJECT_START
, PRO.DATE_TO PROJECT_END
, ORGT.NAME ORGANIZATION_NAME
, TAS.NAME TASK_NAME
, TAS.DESCRIPTION TASK_DESCRIPTION
, TAS.ESTIMATED_TIME TASK_ESTIMATED_TIME
, HR_GENERAL.DECODE_LOOKUP('HXT_TASK_UNITS'
, TAS.FCL_UNITS) TASK_UNITS
, TAS.TASK_NUMBER TASK_NUMBER
, TAS.DATE_FROM TASK_START
, TAS.DATE_TO TASK_END
, DHW.DATE_WORKED DATE_WORKED
, DHW.HOURS HOURS
, DHW.TIME_IN TIME_IN
, DHW.TIME_OUT TIME_OUT
, DHW.HRW_COMMENT HRW_COMMENT
, DHW.RATE_MULTIPLE RATE_MULTIPLE
, DHW.HOURLY_RATE HOURLY_RATE
, DHW.AMOUNT AMOUNT /*******/ /* IDS */ /*******/
, DHW.ASSIGNMENT_ID ASSIGNMENT_ID
, ASG.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, DHW.ID DET_HOURS_WORKED_ID
, DHW.EARN_POL_ID EARNING_POLICY_ID
, DHW.ELEMENT_TYPE_ID ELEMENT_TYPE_ID
, DHW.JOB_ID JOB_ID
, DHW.LOCATION_ID LOCATION_ID
, PRO.ORGANIZATION_ID ORGANIZATION_ID
, ASG.PERSON_ID PERSON_ID
, TAS.PRO_ID PROJECT_ID
, DHW.SHT_ID SHIFT_ID
, DHW.PARENT_ID SUM_HOURS_WORKED_ID
, DHW.TIM_ID TIMECARD_ID
, DHW.TAS_ID TASK_ID
FROM PER_ALL_PEOPLE_F PEO
, PER_ASSIGNMENTS_F ASG
, HXT_DET_HOURS_WORKED_F DHW
, HXT_TASKS TAS
, HXT_PROJECTS PRO
, HR_ALL_ORGANIZATION_UNITS_TL ORGT
, HR_ALL_ORGANIZATION_UNITS_TL BGRT
WHERE SYSDATE BETWEEN DHW.EFFECTIVE_START_DATE
AND DHW.EFFECTIVE_END_DATE
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 PEO.PERSON_ID = ASG.PERSON_ID
AND ASG.ASSIGNMENT_ID = DHW.ASSIGNMENT_ID
AND DHW.TAS_ID = TAS.ID
AND TAS.PRO_ID = PRO.ID
AND ASG.BUSINESS_GROUP_ID = BGRT.ORGANIZATION_ID
AND BGRT.LANGUAGE = USERENV('LANG')
AND ASG.BUSINESS_GROUP_ID+0 = NVL(HR_GENERAL.GET_BUSINESS_GROUP_ID
, ASG.BUSINESS_GROUP_ID)
AND PRO.ORGANIZATION_ID = ORGT.ORGANIZATION_ID
AND ORGT.LANGUAGE = USERENV('LANG') WITH READ ONLY
|
|
|
|