[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | HXT_TIMECLOCK_ERRORS# |
|---|---|
| Object Type: | VIEW |
| Owner: | HXT |
| Subobject Name: | |
| Status: | VALID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID | NUMBER | (15) | Yes | |
| OTM_ERROR | VARCHAR2 | (240) | Yes | |
| CREATION_DATE | DATE | Yes | ||
| CREATED_BY | NUMBER | (15) | Yes | |
| ORA_ERROR | VARCHAR2 | (512) | ||
| TIMECARD_SOURCE | VARCHAR2 | (10) | ||
| APPROVER_NUMBER | VARCHAR2 | (30) | ||
| EMPLOYEE_NUMBER | VARCHAR2 | (30) | ||
| DATE_WORKED | VARCHAR2 | (30) | ||
| START_TIME | DATE | |||
| END_TIME | DATE | |||
| HOURS | NUMBER | (7) | ||
| EARNING_POLICY | VARCHAR2 | (30) | ||
| HOURS_TYPE | VARCHAR2 | (30) | ||
| EARN_REASON_CODE | VARCHAR2 | (30) | ||
| PROJECT | VARCHAR2 | (25) | ||
| TASK_NUMBER | VARCHAR2 | (30) | ||
| LOCATION_CODE | VARCHAR2 | (20) | ||
| HRW_COMMENT | VARCHAR2 | (255) | ||
| RATE_MULTIPLE | NUMBER | (15) | ||
| HOURLY_RATE | NUMBER | (15) | ||
| AMOUNT | NUMBER | (15) | ||
| SEPARATE_CHECK_FLAG | VARCHAR2 | (30) | ||
| BUSINESS_GROUP_ID | NUMBER | (15) | ||
| CONCAT_COST_SEGMENTS | VARCHAR2 | (240) | ||
| COST_SEGMENT1 | VARCHAR2 | (60) | ||
| COST_SEGMENT2 | VARCHAR2 | (60) | ||
| COST_SEGMENT3 | VARCHAR2 | (60) | ||
| COST_SEGMENT4 | VARCHAR2 | (60) | ||
| COST_SEGMENT5 | VARCHAR2 | (60) | ||
| COST_SEGMENT6 | VARCHAR2 | (60) | ||
| COST_SEGMENT7 | VARCHAR2 | (60) | ||
| COST_SEGMENT8 | VARCHAR2 | (60) | ||
| COST_SEGMENT9 | VARCHAR2 | (60) | ||
| COST_SEGMENT10 | VARCHAR2 | (60) | ||
| COST_SEGMENT11 | VARCHAR2 | (60) | ||
| COST_SEGMENT12 | VARCHAR2 | (60) | ||
| COST_SEGMENT13 | VARCHAR2 | (60) | ||
| COST_SEGMENT14 | VARCHAR2 | (60) | ||
| COST_SEGMENT15 | VARCHAR2 | (60) | ||
| COST_SEGMENT16 | VARCHAR2 | (60) | ||
| COST_SEGMENT17 | VARCHAR2 | (60) | ||
| COST_SEGMENT18 | VARCHAR2 | (60) | ||
| COST_SEGMENT19 | VARCHAR2 | (60) | ||
| COST_SEGMENT20 | VARCHAR2 | (60) | ||
| COST_SEGMENT21 | VARCHAR2 | (60) | ||
| COST_SEGMENT22 | VARCHAR2 | (60) | ||
| COST_SEGMENT23 | VARCHAR2 | (60) | ||
| COST_SEGMENT24 | VARCHAR2 | (60) | ||
| COST_SEGMENT25 | VARCHAR2 | (60) | ||
| COST_SEGMENT26 | VARCHAR2 | (60) | ||
| COST_SEGMENT27 | VARCHAR2 | (60) | ||
| COST_SEGMENT28 | VARCHAR2 | (60) | ||
| COST_SEGMENT29 | VARCHAR2 | (60) | ||
| COST_SEGMENT30 | VARCHAR2 | (60) | ||
| TIME_SUMMARY_ID | NUMBER | (15) | ||
| TIM_SUM_EFF_END_DATE | DATE | |||
| TIM_SUM_EFF_START_DATE | DATE | |||
| LAST_UPDATED_BY | NUMBER | (15) | ||
| LAST_UPDATE_DATE | DATE | |||
| LAST_UPDATE_LOGIN | NUMBER | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT ID
, OTM_ERROR
, CREATION_DATE
, CREATED_BY
, ORA_ERROR
, TIMECARD_SOURCE
, APPROVER_NUMBER
, EMPLOYEE_NUMBER
, DATE_WORKED
, START_TIME
, END_TIME
, HOURS
, EARNING_POLICY
, HOURS_TYPE
, EARN_REASON_CODE
, PROJECT
, TASK_NUMBER
, LOCATION_CODE
, HRW_COMMENT
, RATE_MULTIPLE
, HOURLY_RATE
, AMOUNT
, SEPARATE_CHECK_FLAG
, BUSINESS_GROUP_ID
, CONCAT_COST_SEGMENTS
, COST_SEGMENT1
, COST_SEGMENT2
, COST_SEGMENT3
, COST_SEGMENT4
, COST_SEGMENT5
, COST_SEGMENT6
, COST_SEGMENT7
, COST_SEGMENT8
, COST_SEGMENT9
, COST_SEGMENT10
, COST_SEGMENT11
, COST_SEGMENT12
, COST_SEGMENT13
, COST_SEGMENT14
, COST_SEGMENT15
, COST_SEGMENT16
, COST_SEGMENT17
, COST_SEGMENT18
, COST_SEGMENT19
, COST_SEGMENT20
, COST_SEGMENT21
, COST_SEGMENT22
, COST_SEGMENT23
, COST_SEGMENT24
, COST_SEGMENT25
, COST_SEGMENT26
, COST_SEGMENT27
, COST_SEGMENT28
, COST_SEGMENT29
, COST_SEGMENT30
, TIME_SUMMARY_ID
, TIM_SUM_EFF_END_DATE
, TIM_SUM_EFF_START_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM HXT.HXT_TIMECLOCK_ERRORS#;
HXT
HXT_TIMECLOCK_ERRORS
APPS
HXT_TIMECLOCK_ERRORS
HXT_TIMECLOCK_ERRORS_WHO
|
|
|
|