[Home] [Help]
[Dependency Information]
| Object Name: | HXC_RDB_PROCESS_TIMECARDS# |
|---|---|
| Object Type: | VIEW |
| Owner: | HXC |
| Subobject Name: | |
| Status: | VALID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| RESOURCE_ID | NUMBER | (15) | ||
| TIMECARD_ID | NUMBER | (15) | ||
| START_TIME | DATE | |||
| PERSON_NAME | VARCHAR2 | (400) | ||
| PERSON_NUMBER | VARCHAR2 | (50) | ||
| STAGE | VARCHAR2 | (50) | ||
| REQUEST_ID | NUMBER | (15) | ||
| RET_USER_ID | NUMBER | (15) | ||
| PROCESS | VARCHAR2 | (100) | ||
| STOP_TIME | DATE |
Cut, paste (and edit) the following text to query this object:
SELECT RESOURCE_ID
, TIMECARD_ID
, START_TIME
, PERSON_NAME
, PERSON_NUMBER
, STAGE
, REQUEST_ID
, RET_USER_ID
, PROCESS
, STOP_TIME
FROM HXC.HXC_RDB_PROCESS_TIMECARDS#;
HXC
HXC_RDB_PROCESS_TIMECARDS
APPS
HXC_RDB_PROCESS_TIMECARDS
|
|
|
|