[Home] [Help] [Dependency Information]
Object Name: | HXC_RDB_PRE_HRS_PM |
---|---|
Object Type: | TABLE |
Owner: | HXC |
FND Design Data: | HXC.HXC_RDB_PRE_HRS_PM |
Subobject Name: | |
Status: | VALID |
Used for Retrieval Dashboard Pre Retrieval
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
HXC_RDB_PRE_HRS_PM_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
RET_USER_ID
APPROVAL_STATUS |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
APPROVAL_STATUS | VARCHAR2 | (30) | Approval status of the timecard | |
HRS_PM | NUMBER | Approver person id | ||
TIMECARDS | NUMBER | Number of timecards | ||
HRS_PM_NAME | VARCHAR2 | (400) | Approver name | |
RET_USER_ID | NUMBER | User id is foreign key to FND_USER.USER_ID | ||
RESOURCE_ID | NUMBER | (15) | person_id of the timecard |
Cut, paste (and edit) the following text to query this object:
SELECT APPROVAL_STATUS
, HRS_PM
, TIMECARDS
, HRS_PM_NAME
, RET_USER_ID
, RESOURCE_ID
FROM HXC.HXC_RDB_PRE_HRS_PM;
HXC.HXC_RDB_PRE_HRS_PM does not reference any database object
HXC.HXC_RDB_PRE_HRS_PM is referenced by following:
|
|
|