VIEW: APPS.HXT_ERRORS_V

Source

View Text - Preformatted

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 )

View Text - HTML Formatted

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 )