[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 |