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: XTR.XTR_MARKET_DATA_INTERFACE

Object Details

Object Name:	XTR_MARKET_DATA_INTERFACE
Object Type:	TABLE
Owner:	XTR
FND Design Data:	XTR.XTR_MARKET_DATA_INTERFACE
Subobject Name:
Status:	VALID

XTR_MARKET_DATA_INTERFACE contains market data for transfer into the Treasury system. The market data transfer process stores the status of each row that is transferred in this table.

Scope: public
Product: XTR
Lifecycle: active
Display Name: Treasury Market Data Interface
Category: BUSINESS_ENTITY XTR_MARKET_DATA

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
SOURCE	VARCHAR2	(20)	Yes	Feed source name
EXTERNAL_REF_CODE	VARCHAR2	(20)	Yes	Feed source name
DATETIME	DATE			Date of market data
BID	NUMBER			Bid quote
ASK	NUMBER			Ask quote
MID	NUMBER			Mid quote
SPREAD	NUMBER			Spread quote (the difference between ask and bid quotes)
RETURN_CODE	NUMBER			Return code recorded by the market data transfer process
REF_CODE	VARCHAR2	(20)		User-defined market data code in Treasury (set by the transfer process)
CREATED_BY	NUMBER	(15)		Standard Who Column; ID of user who loaded the data into this table
CREATION_DATE	DATE			Standard Who Column; Date when the data was loaded into this table
LAST_UPDATED_BY	NUMBER	(15)		Standard Who Column; ID of user who ran the transfer process
LAST_UPDATED_DATE	DATE			Standard Who Column; Date when the transfer process was run
LAST_UPDATED_LOGIN	NUMBER	(15)		Standard Who Column

Query Text

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


SELECT SOURCE
,      EXTERNAL_REF_CODE
,      DATETIME
,      BID
,      ASK
,      MID
,      SPREAD
,      RETURN_CODE
,      REF_CODE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATED_DATE
,      LAST_UPDATED_LOGIN
FROM XTR.XTR_MARKET_DATA_INTERFACE;

Dependencies

[top of page]

XTR.XTR_MARKET_DATA_INTERFACE does not reference any database object

XTR.XTR_MARKET_DATA_INTERFACE is referenced by following:

XTR: XTR_MARKET_DATA_INTERFACE#