VIEW: APPS.HXT_ERRORS

Source

View Text - Preformatted

SELECT "ID","ERROR_MSG","LOCATION","ERR_TYPE","TIM_ID","HRW_ID","PTP_ID","ORA_MESSAGE","PPB_ID","PAYROLL_ID","PERSON_ID","EFFECTIVE_END_DATE","EFFECTIVE_START_DATE","CREATED_BY","LAST_UPDATED_BY","LAST_UPDATE_DATE","LAST_UPDATE_LOGIN","CREATION_DATE" FROM HXT_ERRORS_F WHERE EFFECTIVE_START_DATE <= (SELECT EFFECTIVE_DATE FROM FND_SESSIONS FNDS WHERE FNDS.SESSION_ID = USERENV('SESSIONID')) AND EFFECTIVE_END_DATE >= (SELECT EFFECTIVE_DATE FROM FND_SESSIONS FNDS WHERE FNDS.SESSION_ID = USERENV('SESSIONID'))

View Text - HTML Formatted

SELECT "ID"
, "ERROR_MSG"
, "LOCATION"
, "ERR_TYPE"
, "TIM_ID"
, "HRW_ID"
, "PTP_ID"
, "ORA_MESSAGE"
, "PPB_ID"
, "PAYROLL_ID"
, "PERSON_ID"
, "EFFECTIVE_END_DATE"
, "EFFECTIVE_START_DATE"
, "CREATED_BY"
, "LAST_UPDATED_BY"
, "LAST_UPDATE_DATE"
, "LAST_UPDATE_LOGIN"
, "CREATION_DATE"
FROM HXT_ERRORS_F
WHERE EFFECTIVE_START_DATE <= (SELECT EFFECTIVE_DATE
FROM FND_SESSIONS FNDS
WHERE FNDS.SESSION_ID = USERENV('SESSIONID'))
AND EFFECTIVE_END_DATE >= (SELECT EFFECTIVE_DATE
FROM FND_SESSIONS FNDS
WHERE FNDS.SESSION_ID = USERENV('SESSIONID'))