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_RETRIEVAL_RANGES

Object Details

Object Name:	HXC_RETRIEVAL_RANGES
Object Type:	TABLE
Owner:	HXC
FND Design Data:	HXC.HXC_RETRIEVAL_RANGES
Subobject Name:
Status:	VALID

HXC_RETRIEVAL_RANGES table is used to support multiple concurrent Transaction Import Processes

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
HXC_RETRIEVAL_RANGES_PK	NORMAL	UNIQUE	APPS_TS_INTERFACE	RETRIEVAL_RANGE_ID
HXC_RETRIEVAL_RANGES_FK1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	TRANSACTION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
RETRIEVAL_RANGE_ID	NUMBER	(15)	Yes	Primary Key from Sequence
RETRIEVAL_PROCESS_ID	NUMBER	(15)	Yes	Retreival Application Process Id
RANGE_START	NUMBER	(9)	Yes	Starting Resource id for the chunk
RANGE_STOP	NUMBER	(9)	Yes	Ending Resource id for the Chunk
SEQ	NUMBER	(9)	Yes	Sequence
TRANSACTION_ID	NUMBER	(15)		Foreign key to HXC_TRANSACTIONS table
WHERE_CLAUSE	VARCHAR2	(2000)		Additional where clause
CREATED_BY	NUMBER	(15)		Standard WHO column
CREATION_DATE	DATE			Standard WHO column
LAST_UPDATED_BY	NUMBER	(15)		Standard WHO column
LAST_UPDATE_DATE	DATE			Standard WHO column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO column
CONC_REQUEST_ID	NUMBER	(15)		Concurrent Request ID of the retrieval processing this range
UNIQUE_PARAMS	VARCHAR2	(2000)		Unique paramters of the recipient application retrieval

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT RETRIEVAL_RANGE_ID
,      RETRIEVAL_PROCESS_ID
,      RANGE_START
,      RANGE_STOP
,      SEQ
,      TRANSACTION_ID
,      WHERE_CLAUSE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CONC_REQUEST_ID
,      UNIQUE_PARAMS
FROM HXC.HXC_RETRIEVAL_RANGES;

Dependencies

[top of page]

HXC.HXC_RETRIEVAL_RANGES does not reference any database object

HXC.HXC_RETRIEVAL_RANGES is referenced by following:

HXC: HXC_RETRIEVAL_RANGES#