View: HXT_ERRORS_V

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

View Text

SELECT ERR.ID
, ERR.ERROR_MSG
, ERR.LOCATION
, ERR.ERR_TYPE
, ERR.TIM_ID
, ERR.HRW_ID
, TIM.TIME_PERIOD_ID
, ERR.ORA_MESSAGE
, TIM.BATCH_ID
, TIM.PAYROLL_ID
, PER.PERSON_ID
, ERR.EFFECTIVE_END_DATE
, ERR.EFFECTIVE_START_DATE
, ERR.CREATED_BY
, ERR.LAST_UPDATED_BY
, ERR.LAST_UPDATE_DATE
, ERR.LAST_UPDATE_LOGIN
, ERR.CREATION_DATE
, PTP.END_DATE
, PPF.PAYROLL_NAME
, PER.EMPLOYEE_NUMBER
, PER.FULL_NAME
FROM HXT_ERRORS ERR
, PER_TIME_PERIODS PTP
, PAY_PAYROLLS_F PPF
, HXT_TIMECARDS TIM
, PER_PEOPLE_F PER
WHERE ERR.TIM_ID=TIM.ID
AND TIM.FOR_PERSON_ID=PER.PERSON_ID
AND TIM.TIME_PERIOD_ID=PTP.TIME_PERIOD_ID
AND PTP.PAYROLL_ID = PPF.PAYROLL_ID
AND PTP.END_DATE BETWEEN PPF.EFFECTIVE_START_DATE
AND PPF.EFFECTIVE_END_DATE
AND PER.EFFECTIVE_START_DATE = (SELECT MAX(PER2.EFFECTIVE_START_DATE)
FROM PER_PEOPLE_F PER2
WHERE PER.PERSON_ID = PER2.PERSON_ID
AND PTP.START_DATE <= PER2.EFFECTIVE_END_DATE
AND PTP.END_DATE >= PER2.EFFECTIVE_START_DATE )

Columns