VIEW: APPS.HXT_SUM_HOURS_WORKED_D

Source

View Text - Preformatted

SELECT hrw.id ,hrw.effective_start_date ,hrw.effective_end_date ,hrw.date_worked ,asg.assignment_number assignment ,hrw.hours ,to_char(hrw.time_in,'HH24MI') time_in ,to_char(hrw.time_out,'HH24MI') time_out ,eltt.element_name ,erp.name earning_policy ,hrw.amount ,hrw.hourly_rate ,hrl.meaning reason ,pcak.concatenated_segments cost_center ,tproj.project_number ,ttask.task_number ,loct.location_code location_code ,hrw.hrw_comment ,hrw.rate_multiple ,fcl.meaning tax_rule ,hrw.separate_check_flag ,hrw.last_update_date ,fuser.user_name last_updated_by ,hrw.prev_wage_code ,sht.name shift_name FROM hxt_sum_hours_worked_f hrw, per_assignments_f asg, pay_element_types_f elt, pay_element_types_f_tl eltt, hxt_earning_policies erp, hr_lookups hrl, pay_cost_allocation_keyflex pcak, hxt_projects_v tproj, hxt_tasks_v ttask, hr_locations_all_tl loct, hr_locations_no_join loc, hr_lookups fcl, hxt_shifts sht, fnd_user_view fuser WHERE hrw.assignment_id = asg.assignment_id AND hrw.date_worked between asg.effective_start_date and asg.effective_end_date AND hrw.element_type_id = elt.element_type_id(+) AND hrw.date_worked between nvl(elt.effective_start_date,hrw.date_worked) and nvl(elt.effective_end_date,hrw.date_worked) AND eltt.element_type_id(+) = elt.element_type_id AND decode(eltt.element_type_id,NULL,'1',eltt.language) = decode(eltt.element_type_id,NULL,'1',userenv('LANG')) AND hrw.earn_pol_id = erp.id AND hrw.date_worked between nvl(hrl.start_date_active, hrw.date_worked) and nvl(hrl.end_date_active, hrw.date_worked) AND hrl.lookup_type(+) = 'ELE_ENTRY_REASON' AND hrl.lookup_code(+) = hrw.fcl_earn_reason_code AND pcak.cost_allocation_keyflex_id(+) = hrw.ffv_cost_center_id AND hrw.project_id = tproj.project_id(+) AND hrw.tas_id = ttask.task_id(+) AND hrw.location_id = loc.location_id(+) AND loc.location_id = loct.location_id(+) AND decode(loct.location_id,NULL,'1',loct.language) = decode(loct.location_id,NULL,'1',userenv('LANG')) AND hrw.fcl_tax_rule_code = fcl.lookup_code(+) AND fcl.application_id(+)=800 AND fcl.lookup_type(+)='PAY_PDT_VDPO' AND fcl.enabled_flag(+) = 'Y' AND hrw.date_worked between nvl(fcl.start_date_active, hrw.date_worked) and nvl(fcl.end_date_active, hrw.date_worked) AND hrw.sht_id = sht.id(+) AND hrw.last_updated_by = fuser.user_id(+)

View Text - HTML Formatted

SELECT HRW.ID
, HRW.EFFECTIVE_START_DATE
, HRW.EFFECTIVE_END_DATE
, HRW.DATE_WORKED
, ASG.ASSIGNMENT_NUMBER ASSIGNMENT
, HRW.HOURS
, TO_CHAR(HRW.TIME_IN
, 'HH24MI') TIME_IN
, TO_CHAR(HRW.TIME_OUT
, 'HH24MI') TIME_OUT
, ELTT.ELEMENT_NAME
, ERP.NAME EARNING_POLICY
, HRW.AMOUNT
, HRW.HOURLY_RATE
, HRL.MEANING REASON
, PCAK.CONCATENATED_SEGMENTS COST_CENTER
, TPROJ.PROJECT_NUMBER
, TTASK.TASK_NUMBER
, LOCT.LOCATION_CODE LOCATION_CODE
, HRW.HRW_COMMENT
, HRW.RATE_MULTIPLE
, FCL.MEANING TAX_RULE
, HRW.SEPARATE_CHECK_FLAG
, HRW.LAST_UPDATE_DATE
, FUSER.USER_NAME LAST_UPDATED_BY
, HRW.PREV_WAGE_CODE
, SHT.NAME SHIFT_NAME
FROM HXT_SUM_HOURS_WORKED_F HRW
, PER_ASSIGNMENTS_F ASG
, PAY_ELEMENT_TYPES_F ELT
, PAY_ELEMENT_TYPES_F_TL ELTT
, HXT_EARNING_POLICIES ERP
, HR_LOOKUPS HRL
, PAY_COST_ALLOCATION_KEYFLEX PCAK
, HXT_PROJECTS_V TPROJ
, HXT_TASKS_V TTASK
, HR_LOCATIONS_ALL_TL LOCT
, HR_LOCATIONS_NO_JOIN LOC
, HR_LOOKUPS FCL
, HXT_SHIFTS SHT
, FND_USER_VIEW FUSER
WHERE HRW.ASSIGNMENT_ID = ASG.ASSIGNMENT_ID
AND HRW.DATE_WORKED BETWEEN ASG.EFFECTIVE_START_DATE
AND ASG.EFFECTIVE_END_DATE
AND HRW.ELEMENT_TYPE_ID = ELT.ELEMENT_TYPE_ID(+)
AND HRW.DATE_WORKED BETWEEN NVL(ELT.EFFECTIVE_START_DATE
, HRW.DATE_WORKED)
AND NVL(ELT.EFFECTIVE_END_DATE
, HRW.DATE_WORKED)
AND ELTT.ELEMENT_TYPE_ID(+) = ELT.ELEMENT_TYPE_ID
AND DECODE(ELTT.ELEMENT_TYPE_ID
, NULL
, '1'
, ELTT.LANGUAGE) = DECODE(ELTT.ELEMENT_TYPE_ID
, NULL
, '1'
, USERENV('LANG'))
AND HRW.EARN_POL_ID = ERP.ID
AND HRW.DATE_WORKED BETWEEN NVL(HRL.START_DATE_ACTIVE
, HRW.DATE_WORKED)
AND NVL(HRL.END_DATE_ACTIVE
, HRW.DATE_WORKED)
AND HRL.LOOKUP_TYPE(+) = 'ELE_ENTRY_REASON'
AND HRL.LOOKUP_CODE(+) = HRW.FCL_EARN_REASON_CODE
AND PCAK.COST_ALLOCATION_KEYFLEX_ID(+) = HRW.FFV_COST_CENTER_ID
AND HRW.PROJECT_ID = TPROJ.PROJECT_ID(+)
AND HRW.TAS_ID = TTASK.TASK_ID(+)
AND HRW.LOCATION_ID = LOC.LOCATION_ID(+)
AND LOC.LOCATION_ID = LOCT.LOCATION_ID(+)
AND DECODE(LOCT.LOCATION_ID
, NULL
, '1'
, LOCT.LANGUAGE) = DECODE(LOCT.LOCATION_ID
, NULL
, '1'
, USERENV('LANG'))
AND HRW.FCL_TAX_RULE_CODE = FCL.LOOKUP_CODE(+)
AND FCL.APPLICATION_ID(+)=800
AND FCL.LOOKUP_TYPE(+)='PAY_PDT_VDPO'
AND FCL.ENABLED_FLAG(+) = 'Y'
AND HRW.DATE_WORKED BETWEEN NVL(FCL.START_DATE_ACTIVE
, HRW.DATE_WORKED)
AND NVL(FCL.END_DATE_ACTIVE
, HRW.DATE_WORKED)
AND HRW.SHT_ID = SHT.ID(+)
AND HRW.LAST_UPDATED_BY = FUSER.USER_ID(+)