[Home] [Help] [Dependency Information]
Object Name: | HXC_BEE_PREF_ADJ_LINES |
---|---|
Object Type: | TABLE |
Owner: | HXC |
FND Design Data: | HXC.HXC_BEE_PREF_ADJ_LINES |
Subobject Name: | |
Status: | VALID |
Stores the details which were once transferred to BEE/OTLR and now picked up for transfer again to OTLR/BEE because of a preference change.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TIMECARD_ID | NUMBER | (15) | Time_building_block_id of timecard scope. | |
TIMECARD_OVN | NUMBER | (15) | OVN of the timecard | |
RESOURCE_ID | NUMBER | (15) | Resource id | |
DETAIL_BB_ID | NUMBER | (15) | time_building_block_id, of detail scope | |
DETAIL_BB_OVN | NUMBER | (15) | ovn of detail time_building_block_id | |
DATE_EARNED | DATE | effective date for the earning | ||
BATCH_SOURCE | VARCHAR2 | (15) | OTM or Time Store | |
TYPE | VARCHAR2 | (30) | type | |
SCOPE | VARCHAR2 | (30) | scope | |
HOURS | NUMBER | hours measure | ||
START_TIME | DATE | detail start_time | ||
STOP_TIME | DATE | detail stop_time | ||
RESOURCE_TYPE | VARCHAR2 | (30) | from hxc_time_building_blocks, for this detail building block, OVN | |
UOM | VARCHAR2 | (30) | from hxc_time_building_blocks, for this detail building block, OVN | |
CHANGED | VARCHAR2 | (1) | from hxc_time_building_blocks, for this detail building block, OVN | |
DELETED | VARCHAR2 | (1) | from hxc_time_building_blocks, for this detail building block, OVN | |
COMMENT_TEXT | VARCHAR2 | (2000) | from hxc_time_building_blocks, for this detail building block, OVN | |
PARENT_BB_ID | NUMBER | (15) | from hxc_time_building_blocks, for this detail building block, OVN |
Cut, paste (and edit) the following text to query this object:
SELECT TIMECARD_ID
, TIMECARD_OVN
, RESOURCE_ID
, DETAIL_BB_ID
, DETAIL_BB_OVN
, DATE_EARNED
, BATCH_SOURCE
, TYPE
, SCOPE
, HOURS
, START_TIME
, STOP_TIME
, RESOURCE_TYPE
, UOM
, CHANGED
, DELETED
, COMMENT_TEXT
, PARENT_BB_ID
FROM HXC.HXC_BEE_PREF_ADJ_LINES;
HXC.HXC_BEE_PREF_ADJ_LINES does not reference any database object
HXC.HXC_BEE_PREF_ADJ_LINES is referenced by following:
|
|
|