VIEW: APPS.HXTFV_SUM_HOURS_WORKED

Source

View Text - Preformatted

SELECT /* $Header: hxtbis.odf 115.8 2002/06/10 00:38:17 pkm ship      $ */ bgrT.name business_group_name ,peo.full_name person_name ,hrw.date_worked date_worked ,hrw.line_status line_status ,hrw.hours hours ,hrw.time_in time_in ,hrw.time_out time_out ,hrw.amount amount ,hrw.hourly_rate hourly_rate ,hrw.hrw_comment hrw_comment ,hrw.rate_multiple rate_multiple ,hr_general.decode_lookup('PAY_PDT_VDPO',hrw.fcl_tax_rule_code) tax_rule ,hr_general.decode_lookup('ELE_ENTRY_REASON',hrw.fcl_earn_reason_code) earn_reason ,hrw.separate_check_flag separate_check ,hrw.seqno sequence_number ,hrw.actual_time_in actual_time_in ,hrw.actual_time_out actual_time_out ,hrw.prev_wage_code prev_wage_code ,hrw.attribute_category attribute_category ,asg.assignment_number assignment_number ,erp.name earning_policy ,eltT.element_name element_name ,sht.name shift_name ,NVL(hrw_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 ,'_KF:PAY:COST:ckey' /********/ /* Ids */ /********/ ,hrw.assignment_id assignment_id ,asg.business_group_id business_group_id ,hrw.ffv_cost_center_id cost_center_id ,hrw.element_type_id element_type_id ,hrw.earn_pol_id earning_policy_id ,asg.grade_id grade_id ,hrw.job_id job_id ,hrw.ffv_labor_account_id labor_account_id ,NVL(hrw.location_id,asg.location_id) location_id ,asg.organization_id organization_id ,asg.person_id person_id ,asg.position_id position_id ,hrw.project_id project_id ,hrw.sht_id shift_id ,hrw.id sum_hours_worked_id ,hrw.tas_id task_id ,hrw.tim_id timecard_id FROM pay_cost_allocation_keyflex ckey ,hxt_sum_hours_worked_f hrw ,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 hrw_locT ,hr_locations_all_tl asg_locT ,hxt_projects tproj ,hxt_tasks ttask ,hxt_shifts sht WHERE hrw.assignment_id = asg.assignment_id AND ckey.cost_allocation_keyflex_id (+) = hrw.ffv_cost_center_id AND asg.person_id = peo.person_id AND hrw.project_id = tproj.id(+) AND hrw.tas_id = ttask.id(+) AND hrw.sht_id = sht.id(+) AND bgrT.organization_id = asg.business_group_id AND bgrT.language = userenv('LANG') AND hrw.element_type_id = eltT.element_type_id(+) AND hrw.earn_pol_id = erp.id AND hrw.location_id = hrw_locT.location_id(+) AND asg.location_id = asg_locT.location_id(+) AND asg_locT.language(+) = userenv('LANG') AND hrw_locT.language(+) = userenv('LANG') AND eltT.language(+) = userenv('LANG') AND hrw.date_worked BETWEEN asg.effective_start_date AND asg.effective_end_date AND hrw.date_worked BETWEEN peo.effective_start_date AND peo.effective_end_date AND SYSDATE BETWEEN hrw.effective_start_date AND hrw.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 115.8 2002/06/10 00:38:17 PKM SHIP $ */ BGRT.NAME BUSINESS_GROUP_NAME
, PEO.FULL_NAME PERSON_NAME
, HRW.DATE_WORKED DATE_WORKED
, HRW.LINE_STATUS LINE_STATUS
, HRW.HOURS HOURS
, HRW.TIME_IN TIME_IN
, HRW.TIME_OUT TIME_OUT
, HRW.AMOUNT AMOUNT
, HRW.HOURLY_RATE HOURLY_RATE
, HRW.HRW_COMMENT HRW_COMMENT
, HRW.RATE_MULTIPLE RATE_MULTIPLE
, HR_GENERAL.DECODE_LOOKUP('PAY_PDT_VDPO'
, HRW.FCL_TAX_RULE_CODE) TAX_RULE
, HR_GENERAL.DECODE_LOOKUP('ELE_ENTRY_REASON'
, HRW.FCL_EARN_REASON_CODE) EARN_REASON
, HRW.SEPARATE_CHECK_FLAG SEPARATE_CHECK
, HRW.SEQNO SEQUENCE_NUMBER
, HRW.ACTUAL_TIME_IN ACTUAL_TIME_IN
, HRW.ACTUAL_TIME_OUT ACTUAL_TIME_OUT
, HRW.PREV_WAGE_CODE PREV_WAGE_CODE
, HRW.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ASG.ASSIGNMENT_NUMBER ASSIGNMENT_NUMBER
, ERP.NAME EARNING_POLICY
, ELTT.ELEMENT_NAME ELEMENT_NAME
, SHT.NAME SHIFT_NAME
, NVL(HRW_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
, '_KF:PAY:COST:CKEY' /********/ /* IDS */ /********/
, HRW.ASSIGNMENT_ID ASSIGNMENT_ID
, ASG.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, HRW.FFV_COST_CENTER_ID COST_CENTER_ID
, HRW.ELEMENT_TYPE_ID ELEMENT_TYPE_ID
, HRW.EARN_POL_ID EARNING_POLICY_ID
, ASG.GRADE_ID GRADE_ID
, HRW.JOB_ID JOB_ID
, HRW.FFV_LABOR_ACCOUNT_ID LABOR_ACCOUNT_ID
, NVL(HRW.LOCATION_ID
, ASG.LOCATION_ID) LOCATION_ID
, ASG.ORGANIZATION_ID ORGANIZATION_ID
, ASG.PERSON_ID PERSON_ID
, ASG.POSITION_ID POSITION_ID
, HRW.PROJECT_ID PROJECT_ID
, HRW.SHT_ID SHIFT_ID
, HRW.ID SUM_HOURS_WORKED_ID
, HRW.TAS_ID TASK_ID
, HRW.TIM_ID TIMECARD_ID
FROM PAY_COST_ALLOCATION_KEYFLEX CKEY
, HXT_SUM_HOURS_WORKED_F HRW
, 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 HRW_LOCT
, HR_LOCATIONS_ALL_TL ASG_LOCT
, HXT_PROJECTS TPROJ
, HXT_TASKS TTASK
, HXT_SHIFTS SHT
WHERE HRW.ASSIGNMENT_ID = ASG.ASSIGNMENT_ID
AND CKEY.COST_ALLOCATION_KEYFLEX_ID (+) = HRW.FFV_COST_CENTER_ID
AND ASG.PERSON_ID = PEO.PERSON_ID
AND HRW.PROJECT_ID = TPROJ.ID(+)
AND HRW.TAS_ID = TTASK.ID(+)
AND HRW.SHT_ID = SHT.ID(+)
AND BGRT.ORGANIZATION_ID = ASG.BUSINESS_GROUP_ID
AND BGRT.LANGUAGE = USERENV('LANG')
AND HRW.ELEMENT_TYPE_ID = ELTT.ELEMENT_TYPE_ID(+)
AND HRW.EARN_POL_ID = ERP.ID
AND HRW.LOCATION_ID = HRW_LOCT.LOCATION_ID(+)
AND ASG.LOCATION_ID = ASG_LOCT.LOCATION_ID(+)
AND ASG_LOCT.LANGUAGE(+) = USERENV('LANG')
AND HRW_LOCT.LANGUAGE(+) = USERENV('LANG')
AND ELTT.LANGUAGE(+) = USERENV('LANG')
AND HRW.DATE_WORKED BETWEEN ASG.EFFECTIVE_START_DATE
AND ASG.EFFECTIVE_END_DATE
AND HRW.DATE_WORKED BETWEEN PEO.EFFECTIVE_START_DATE
AND PEO.EFFECTIVE_END_DATE
AND SYSDATE BETWEEN HRW.EFFECTIVE_START_DATE
AND HRW.EFFECTIVE_END_DATE
AND SYSDATE BETWEEN ERP.EFFECTIVE_START_DATE
AND ERP.EFFECTIVE_END_DATE WITH READ ONLY