eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: HXC.HXC_BEE_PREF_ADJ_LINES

Object Details

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.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	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	(15)	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

Query Text

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;

Dependencies

[top of page]

HXC.HXC_BEE_PREF_ADJ_LINES does not reference any database object

HXC.HXC_BEE_PREF_ADJ_LINES is referenced by following:

HXC: HXC_BEE_PREF_ADJ_LINES#