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_HDP_SUM_HOURS_WORKED_V

Source

View Text - Preformatted


SELECT SHW.TIM_ID SUM_TIM_ID, SHW.DATE_WORKED SUM_DATE, nvl(SUM(SHW.HOURS),0) SUM_HOURS from HXT_SUM_HOURS_WORKED SHW WHERE exists (select 1 from HXT_PAY_ELEMENT_TYPES_F_DDF_V ELTV, PAY_ELEMENT_TYPES_F ELT, HXT_DET_HOURS_WORKED DHW where DHW.PARENT_ID = SHW.ID and ELT.ELEMENT_TYPE_ID = DHW.ELEMENT_TYPE_ID and DHW.DATE_WORKED between ELT.EFFECTIVE_START_DATE and ELT.EFFECTIVE_END_DATE and ELTV.ELEMENT_TYPE_ID = ELT.ELEMENT_TYPE_ID and DHW.DATE_WORKED between ELTV.EFFECTIVE_START_DATE and ELTV.EFFECTIVE_END_DATE and ELTV.HXT_EARNING_CATEGORY IN ('REG','OVT')) group by SHW.TIM_ID, SHW.DATE_WORKED

View Text - HTML Formatted

SELECT SHW.TIM_ID SUM_TIM_ID
, SHW.DATE_WORKED SUM_DATE
, NVL(SUM(SHW.HOURS)
, 0) SUM_HOURS
FROM HXT_SUM_HOURS_WORKED SHW
WHERE EXISTS (SELECT 1
FROM HXT_PAY_ELEMENT_TYPES_F_DDF_V ELTV
, PAY_ELEMENT_TYPES_F ELT
, HXT_DET_HOURS_WORKED DHW
WHERE DHW.PARENT_ID = SHW.ID
AND ELT.ELEMENT_TYPE_ID = DHW.ELEMENT_TYPE_ID
AND DHW.DATE_WORKED BETWEEN ELT.EFFECTIVE_START_DATE
AND ELT.EFFECTIVE_END_DATE
AND ELTV.ELEMENT_TYPE_ID = ELT.ELEMENT_TYPE_ID
AND DHW.DATE_WORKED BETWEEN ELTV.EFFECTIVE_START_DATE
AND ELTV.EFFECTIVE_END_DATE
AND ELTV.HXT_EARNING_CATEGORY IN ('REG'
, 'OVT')) GROUP BY SHW.TIM_ID
, SHW.DATE_WORKED