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_DAILY_HOURS_WORKED_V

Source

View Text - Preformatted


SELECT HRW.TIM_ID TIM_ID, HRW.DATE_WORKED WORK_DATE , SUM(HRW.HOURS) DAILY_HOURS from HXT_EARN_GROUPS ERG, HXT_PAY_ELEMENT_TYPES_F_DDF_V ELTV, PAY_ELEMENT_TYPES_F ELT, HXT_EARNING_POLICIES EGP, HXT_PER_AEI_DDF_V AEIV, PER_ASSIGNMENTS_F ASM, HXT_DET_HOURS_WORKED HRW WHERE ASM.ASSIGNMENT_ID = HRW.ASSIGNMENT_ID and HRW.DATE_WORKED between ASM.EFFECTIVE_START_DATE and ASM.EFFECTIVE_END_DATE and AEIV.ASSIGNMENT_ID = ASM.ASSIGNMENT_ID and HRW.DATE_WORKED between AEIV.EFFECTIVE_START_DATE and AEIV.EFFECTIVE_END_DATE and ELT.ELEMENT_TYPE_ID = HRW.ELEMENT_TYPE_ID and HRW.DATE_WORKED between ELT.EFFECTIVE_START_DATE and ELT.EFFECTIVE_END_DATE and ELTV.ELEMENT_TYPE_ID = ELT.ELEMENT_TYPE_ID and HRW.DATE_WORKED between ELTV.EFFECTIVE_START_DATE and ELTV.EFFECTIVE_END_DATE and EGP.ID = AEIV.HXT_EARNING_POLICY and HRW.DATE_WORKED between EGP.EFFECTIVE_START_DATE and EGP.EFFECTIVE_END_DATE and ERG.EGT_ID = EGP.EGT_ID and ERG.ELEMENT_TYPE_ID = ELT.ELEMENT_TYPE_ID GROUP BY HRW.TIM_ID, HRW.DATE_WORKED

View Text - HTML Formatted

SELECT HRW.TIM_ID TIM_ID
, HRW.DATE_WORKED WORK_DATE
, SUM(HRW.HOURS) DAILY_HOURS
FROM HXT_EARN_GROUPS ERG
, HXT_PAY_ELEMENT_TYPES_F_DDF_V ELTV
, PAY_ELEMENT_TYPES_F ELT
, HXT_EARNING_POLICIES EGP
, HXT_PER_AEI_DDF_V AEIV
, PER_ASSIGNMENTS_F ASM
, HXT_DET_HOURS_WORKED HRW
WHERE ASM.ASSIGNMENT_ID = HRW.ASSIGNMENT_ID
AND HRW.DATE_WORKED BETWEEN ASM.EFFECTIVE_START_DATE
AND ASM.EFFECTIVE_END_DATE
AND AEIV.ASSIGNMENT_ID = ASM.ASSIGNMENT_ID
AND HRW.DATE_WORKED BETWEEN AEIV.EFFECTIVE_START_DATE
AND AEIV.EFFECTIVE_END_DATE
AND ELT.ELEMENT_TYPE_ID = HRW.ELEMENT_TYPE_ID
AND HRW.DATE_WORKED BETWEEN ELT.EFFECTIVE_START_DATE
AND ELT.EFFECTIVE_END_DATE
AND ELTV.ELEMENT_TYPE_ID = ELT.ELEMENT_TYPE_ID
AND HRW.DATE_WORKED BETWEEN ELTV.EFFECTIVE_START_DATE
AND ELTV.EFFECTIVE_END_DATE
AND EGP.ID = AEIV.HXT_EARNING_POLICY
AND HRW.DATE_WORKED BETWEEN EGP.EFFECTIVE_START_DATE
AND EGP.EFFECTIVE_END_DATE
AND ERG.EGT_ID = EGP.EGT_ID
AND ERG.ELEMENT_TYPE_ID = ELT.ELEMENT_TYPE_ID GROUP BY HRW.TIM_ID
, HRW.DATE_WORKED