eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.HXT_SUM_HOURS_WORKED_FMV

Source

View Text - Preformatted


SELECT hrw.rowid row_id ,hrw.id ,hrw.effective_start_date ,hrw.effective_end_date ,hrw.tim_id ,hrw.date_worked ,hrw.assignment_id ,asg.assignment_number assignment_number ,asg.business_group_id asg_bus_grp_id ,hrw.hours ,hrw.time_in ,hrw.time_out ,hrw.element_type_id ,eltt.element_name ,hrw.earn_pol_id ,erp.name earning_policy ,hrw.amount ,hrw.hourly_rate ,hrw.fcl_earn_reason_code ,hrl.meaning reason ,hrw.ffv_cost_center_id ,pcak.concatenated_segments cost_center ,hrw.project_id ,tproj.segment1 project_number ,hrw.tas_id ,ttask.task_number ,hrw.location_id ,loct.location_code location_code ,hrw.hrw_comment ,hrw.ffv_rate_code_id ,hrw.rate_multiple ,hrw.fcl_tax_rule_code ,fcl.meaning tax_rule ,hrw.separate_check_flag ,hrw.seqno ,hrw.created_by ,hrw.creation_date ,hrw.last_update_date ,hrw.last_update_login ,hrw.last_updated_by ,hrw.actual_time_in ,hrw.actual_time_out ,hrw.prev_wage_code ,hrw.sht_id ,sht.name shift_name ,hrw.attribute1 ,hrw.attribute2 ,hrw.attribute3 ,hrw.attribute4 ,hrw.attribute5 ,hrw.attribute6 ,hrw.attribute7 ,hrw.attribute8 ,hrw.attribute9 ,hrw.attribute10 ,hrw.attribute11 ,hrw.attribute12 ,hrw.attribute13 ,hrw.attribute14 ,hrw.attribute15 ,hrw.attribute16 ,hrw.attribute17 ,hrw.attribute18 ,hrw.attribute19 ,hrw.attribute20 ,hrw.attribute21 ,hrw.attribute22 ,hrw.attribute23 ,hrw.attribute24 ,hrw.attribute25 ,hrw.attribute26 ,hrw.attribute27 ,hrw.attribute28 ,hrw.attribute29 ,hrw.attribute30 ,hrw.attribute_category ,hrw.state_name ,hrw.county_name ,hrw.city_name ,hrw.zip_code 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, pa_projects_all tproj, pa_tasks_expend_v ttask, hr_locations_all_tl loct, hr_locations_no_join loc, hr_lookups fcl, hxt_shifts sht, fnd_user_view fuser WHERE hrw.effective_start_date <= (select effective_date from fnd_sessions fnds where fnds.session_id = USERENV('SESSIONID')) AND hrw.effective_end_date >= (select effective_date from fnd_sessions fnds where fnds.session_id = USERENV('SESSIONID')) AND 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.ROWID ROW_ID
, HRW.ID
, HRW.EFFECTIVE_START_DATE
, HRW.EFFECTIVE_END_DATE
, HRW.TIM_ID
, HRW.DATE_WORKED
, HRW.ASSIGNMENT_ID
, ASG.ASSIGNMENT_NUMBER ASSIGNMENT_NUMBER
, ASG.BUSINESS_GROUP_ID ASG_BUS_GRP_ID
, HRW.HOURS
, HRW.TIME_IN
, HRW.TIME_OUT
, HRW.ELEMENT_TYPE_ID
, ELTT.ELEMENT_NAME
, HRW.EARN_POL_ID
, ERP.NAME EARNING_POLICY
, HRW.AMOUNT
, HRW.HOURLY_RATE
, HRW.FCL_EARN_REASON_CODE
, HRL.MEANING REASON
, HRW.FFV_COST_CENTER_ID
, PCAK.CONCATENATED_SEGMENTS COST_CENTER
, HRW.PROJECT_ID
, TPROJ.SEGMENT1 PROJECT_NUMBER
, HRW.TAS_ID
, TTASK.TASK_NUMBER
, HRW.LOCATION_ID
, LOCT.LOCATION_CODE LOCATION_CODE
, HRW.HRW_COMMENT
, HRW.FFV_RATE_CODE_ID
, HRW.RATE_MULTIPLE
, HRW.FCL_TAX_RULE_CODE
, FCL.MEANING TAX_RULE
, HRW.SEPARATE_CHECK_FLAG
, HRW.SEQNO
, HRW.CREATED_BY
, HRW.CREATION_DATE
, HRW.LAST_UPDATE_DATE
, HRW.LAST_UPDATE_LOGIN
, HRW.LAST_UPDATED_BY
, HRW.ACTUAL_TIME_IN
, HRW.ACTUAL_TIME_OUT
, HRW.PREV_WAGE_CODE
, HRW.SHT_ID
, SHT.NAME SHIFT_NAME
, HRW.ATTRIBUTE1
, HRW.ATTRIBUTE2
, HRW.ATTRIBUTE3
, HRW.ATTRIBUTE4
, HRW.ATTRIBUTE5
, HRW.ATTRIBUTE6
, HRW.ATTRIBUTE7
, HRW.ATTRIBUTE8
, HRW.ATTRIBUTE9
, HRW.ATTRIBUTE10
, HRW.ATTRIBUTE11
, HRW.ATTRIBUTE12
, HRW.ATTRIBUTE13
, HRW.ATTRIBUTE14
, HRW.ATTRIBUTE15
, HRW.ATTRIBUTE16
, HRW.ATTRIBUTE17
, HRW.ATTRIBUTE18
, HRW.ATTRIBUTE19
, HRW.ATTRIBUTE20
, HRW.ATTRIBUTE21
, HRW.ATTRIBUTE22
, HRW.ATTRIBUTE23
, HRW.ATTRIBUTE24
, HRW.ATTRIBUTE25
, HRW.ATTRIBUTE26
, HRW.ATTRIBUTE27
, HRW.ATTRIBUTE28
, HRW.ATTRIBUTE29
, HRW.ATTRIBUTE30
, HRW.ATTRIBUTE_CATEGORY
, HRW.STATE_NAME
, HRW.COUNTY_NAME
, HRW.CITY_NAME
, HRW.ZIP_CODE
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
, PA_PROJECTS_ALL TPROJ
, PA_TASKS_EXPEND_V TTASK
, HR_LOCATIONS_ALL_TL LOCT
, HR_LOCATIONS_NO_JOIN LOC
, HR_LOOKUPS FCL
, HXT_SHIFTS SHT
, FND_USER_VIEW FUSER
WHERE HRW.EFFECTIVE_START_DATE <= (SELECT EFFECTIVE_DATE
FROM FND_SESSIONS FNDS
WHERE FNDS.SESSION_ID = USERENV('SESSIONID'))
AND HRW.EFFECTIVE_END_DATE >= (SELECT EFFECTIVE_DATE
FROM FND_SESSIONS FNDS
WHERE FNDS.SESSION_ID = USERENV('SESSIONID'))
AND 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(+)