VIEW: APPS.HXTFV_DET_HOURS_WORKED

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 ,dhw.date_worked date_worked ,dhw.line_status line_status ,dhw.hours hours ,dhw.time_in time_in ,dhw.time_out time_out ,dhw.amount amount ,dhw.hourly_rate hourly_rate ,dhw.hrw_comment hrw_comment ,dhw.rate_multiple rate_multiple ,hr_general.decode_lookup('PAY_PDT_VDPO',dhw.fcl_tax_rule_code) tax_rule ,hr_general.decode_lookup('ELE_ENTRY_REASON',dhw.fcl_earn_reason_code) earn_reason ,dhw.separate_check_flag separate_check ,dhw.seqno sequence_number ,dhw.actual_time_in actual_time_in ,dhw.actual_time_out actual_time_out ,dhw.prev_wage_code prev_wage_code ,asg.assignment_number assignment_number ,erp.name earning_policy ,eltT.element_name element_name ,sht.name shift_name ,NVL(dhw_locT.location_code,asg_locT.location_code) location_code ,ttask.task_number task_number ,ttask.name task_name ,tproj.pro_number project_number ,tproj.name project_name ,dhw.pa_status pa_status ,hr_general.decode_lookup('PAY_STATUS',dhw.pay_status) pay_status /********/ /* Ids */ /********/ ,dhw.id det_hours_worked_id ,dhw.parent_id sum_hours_worked_id ,dhw.tim_id timecard_id ,dhw.assignment_id assignment_id ,asg.business_group_id business_group_id ,asg.organization_id organization_id ,dhw.job_id job_id ,dhw.element_type_id element_type_id ,dhw.earn_pol_id earning_policy_id ,dhw.ffv_cost_center_id cost_center_id ,dhw.ffv_labor_account_id labor_account_id ,dhw.ffv_rate_code_id rate_code_id ,dhw.project_id project_id ,dhw.tas_id task_id ,NVL(dhw.location_id,asg.location_id) location_id ,dhw.sht_id shift_id ,dhw.retro_pbl_line_id retro_line_id ,dhw.retro_batch_id retro_batch_id ,dhw.pbl_line_id pbl_line_id FROM hxt_det_hours_worked_f dhw ,per_assignments_f asg ,per_all_people_f peo ,hr_all_organization_units_tl bgrT ,pay_element_types_f_tl eltT ,hxt_earning_policies erp ,hr_locations_all_tl asg_locT ,hr_locations_all_tl dhw_locT ,hxt_projects tproj ,hxt_tasks ttask ,hxt_shifts sht WHERE dhw.assignment_id = asg.assignment_id AND asg.person_id = peo.person_id AND dhw.project_id = tproj.id(+) AND dhw.tas_id = ttask.id(+) AND dhw.sht_id = sht.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 dhw.element_type_id = eltT.element_type_id(+) AND dhw.earn_pol_id = erp.id (+) AND dhw.location_id = dhw_locT.location_id(+) AND asg.location_id = asg_locT.location_id(+) AND dhw_locT.language(+) = userenv('LANG') AND asg_locT.language(+) = userenv('LANG') AND eltT.language(+) = userenv('LANG') AND dhw.date_worked BETWEEN peo.effective_start_date AND peo.effective_end_date AND dhw.date_worked BETWEEN asg.effective_start_date AND asg.effective_end_date AND SYSDATE BETWEEN dhw.effective_start_date and dhw.effective_end_date AND SYSDATE BETWEEN erp.effective_start_date (+) and erp.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
, DHW.DATE_WORKED DATE_WORKED
, DHW.LINE_STATUS LINE_STATUS
, DHW.HOURS HOURS
, DHW.TIME_IN TIME_IN
, DHW.TIME_OUT TIME_OUT
, DHW.AMOUNT AMOUNT
, DHW.HOURLY_RATE HOURLY_RATE
, DHW.HRW_COMMENT HRW_COMMENT
, DHW.RATE_MULTIPLE RATE_MULTIPLE
, HR_GENERAL.DECODE_LOOKUP('PAY_PDT_VDPO'
, DHW.FCL_TAX_RULE_CODE) TAX_RULE
, HR_GENERAL.DECODE_LOOKUP('ELE_ENTRY_REASON'
, DHW.FCL_EARN_REASON_CODE) EARN_REASON
, DHW.SEPARATE_CHECK_FLAG SEPARATE_CHECK
, DHW.SEQNO SEQUENCE_NUMBER
, DHW.ACTUAL_TIME_IN ACTUAL_TIME_IN
, DHW.ACTUAL_TIME_OUT ACTUAL_TIME_OUT
, DHW.PREV_WAGE_CODE PREV_WAGE_CODE
, ASG.ASSIGNMENT_NUMBER ASSIGNMENT_NUMBER
, ERP.NAME EARNING_POLICY
, ELTT.ELEMENT_NAME ELEMENT_NAME
, SHT.NAME SHIFT_NAME
, NVL(DHW_LOCT.LOCATION_CODE
, ASG_LOCT.LOCATION_CODE) LOCATION_CODE
, TTASK.TASK_NUMBER TASK_NUMBER
, TTASK.NAME TASK_NAME
, TPROJ.PRO_NUMBER PROJECT_NUMBER
, TPROJ.NAME PROJECT_NAME
, DHW.PA_STATUS PA_STATUS
, HR_GENERAL.DECODE_LOOKUP('PAY_STATUS'
, DHW.PAY_STATUS) PAY_STATUS /********/ /* IDS */ /********/
, DHW.ID DET_HOURS_WORKED_ID
, DHW.PARENT_ID SUM_HOURS_WORKED_ID
, DHW.TIM_ID TIMECARD_ID
, DHW.ASSIGNMENT_ID ASSIGNMENT_ID
, ASG.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, ASG.ORGANIZATION_ID ORGANIZATION_ID
, DHW.JOB_ID JOB_ID
, DHW.ELEMENT_TYPE_ID ELEMENT_TYPE_ID
, DHW.EARN_POL_ID EARNING_POLICY_ID
, DHW.FFV_COST_CENTER_ID COST_CENTER_ID
, DHW.FFV_LABOR_ACCOUNT_ID LABOR_ACCOUNT_ID
, DHW.FFV_RATE_CODE_ID RATE_CODE_ID
, DHW.PROJECT_ID PROJECT_ID
, DHW.TAS_ID TASK_ID
, NVL(DHW.LOCATION_ID
, ASG.LOCATION_ID) LOCATION_ID
, DHW.SHT_ID SHIFT_ID
, DHW.RETRO_PBL_LINE_ID RETRO_LINE_ID
, DHW.RETRO_BATCH_ID RETRO_BATCH_ID
, DHW.PBL_LINE_ID PBL_LINE_ID
FROM HXT_DET_HOURS_WORKED_F DHW
, PER_ASSIGNMENTS_F ASG
, PER_ALL_PEOPLE_F PEO
, HR_ALL_ORGANIZATION_UNITS_TL BGRT
, PAY_ELEMENT_TYPES_F_TL ELTT
, HXT_EARNING_POLICIES ERP
, HR_LOCATIONS_ALL_TL ASG_LOCT
, HR_LOCATIONS_ALL_TL DHW_LOCT
, HXT_PROJECTS TPROJ
, HXT_TASKS TTASK
, HXT_SHIFTS SHT
WHERE DHW.ASSIGNMENT_ID = ASG.ASSIGNMENT_ID
AND ASG.PERSON_ID = PEO.PERSON_ID
AND DHW.PROJECT_ID = TPROJ.ID(+)
AND DHW.TAS_ID = TTASK.ID(+)
AND DHW.SHT_ID = SHT.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 DHW.ELEMENT_TYPE_ID = ELTT.ELEMENT_TYPE_ID(+)
AND DHW.EARN_POL_ID = ERP.ID (+)
AND DHW.LOCATION_ID = DHW_LOCT.LOCATION_ID(+)
AND ASG.LOCATION_ID = ASG_LOCT.LOCATION_ID(+)
AND DHW_LOCT.LANGUAGE(+) = USERENV('LANG')
AND ASG_LOCT.LANGUAGE(+) = USERENV('LANG')
AND ELTT.LANGUAGE(+) = USERENV('LANG')
AND DHW.DATE_WORKED BETWEEN PEO.EFFECTIVE_START_DATE
AND PEO.EFFECTIVE_END_DATE
AND DHW.DATE_WORKED BETWEEN ASG.EFFECTIVE_START_DATE
AND ASG.EFFECTIVE_END_DATE
AND SYSDATE BETWEEN DHW.EFFECTIVE_START_DATE
AND DHW.EFFECTIVE_END_DATE
AND SYSDATE BETWEEN ERP.EFFECTIVE_START_DATE (+)
AND ERP.EFFECTIVE_END_DATE (+) WITH READ ONLY