[Home] [Help]
View: HXT_ERRORS_X
Product: | HXT - Time and Labor |
Description: | |
Implementation/DBA Data: |
APPS.HXT_ERRORS_X
|
View Text
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 <= TRUNC(SYSDATE)
AND EFFECTIVE_END_DATE >= TRUNC(SYSDATE)
Columns
Name |
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 |