View: HXT_DAILY_HOURS_WORKED_V

Product:	HXT - Time and Labor
Description:
Implementation/DBA Data:	APPS.HXT_DAILY_HOURS_WORKED_V

View Text

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

Columns