View: HXT_TIMECARDS_D

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

View Text

SELECT TIM.ID
, TIM.EFFECTIVE_START_DATE
, TIM.EFFECTIVE_END_DATE
, PER.FULL_NAME APPROVER_NAME
, TIM.APPROVED_TIMESTAMP
, TIM.LAST_UPDATE_DATE
, FUSER.USER_NAME LAST_UPDATED_BY
FROM HXT_TIMECARDS_F TIM
, PER_PEOPLE_F PER
, FND_USER_VIEW FUSER
WHERE TIM.APPROV_PERSON_ID = PER.PERSON_ID(+)
AND TIM.APPROVED_TIMESTAMP BETWEEN PER.EFFECTIVE_START_DATE(+)
AND PER.EFFECTIVE_END_DATE(+)
AND TIM.LAST_UPDATED_BY = FUSER.USER_ID(+)

Columns