VIEW: APPS.HXT_TIMECARDS_D

Source

View Text - Preformatted

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(+)

View Text - HTML Formatted

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(+)