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]

VIEW: XTR.XTR_MARKET_PRICES#

Object Details

Object Name:	XTR_MARKET_PRICES#
Object Type:	VIEW
Owner:	XTR
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
ARCHIVE_FREQ_TYPE	VARCHAR2	(1)
ASK_PRICE	NUMBER
BID_PRICE	NUMBER
CURRENCY_A	VARCHAR2	(15)
CURRENCY_B	VARCHAR2	(15)
DDE_CONVERSATION_CODE	VARCHAR2	(15)
DOWNLOAD_FREQ_TYPE	VARCHAR2	(1)
FREQ_ARCHIVE	NUMBER
FREQ_DOWNLOAD	NUMBER
LAST_ARCHIVE_TIME	DATE
LAST_DOWNLOAD_TIME	DATE
MOVEMENT_INDICATOR	VARCHAR2	(5)
NOS_OF_DAYS	NUMBER
ORAFIN_ARCHIVE_FREQ_TYPE	VARCHAR2	(1)
ORAFIN_LAST_ARCHIVE_TIME	DATE
PARTY_CODE	VARCHAR2	(7)
PRICE_DESCRIPTION	VARCHAR2	(50)	Yes
REF_NUMBER	NUMBER		Yes
RIC_CODE	VARCHAR2	(20)	Yes
SOURCE	VARCHAR2	(20)	Yes
SPREAD_BASIS	VARCHAR2	(3)
TERM_LENGTH	NUMBER
TERM_TYPE	VARCHAR2	(1)
TERM_YEAR	NUMBER
UPDATE_RATE_YN	VARCHAR2	(1)
DAY_COUNT_BASIS	VARCHAR2	(15)

Query Text

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


SELECT ARCHIVE_FREQ_TYPE
,      ASK_PRICE
,      BID_PRICE
,      CURRENCY_A
,      CURRENCY_B
,      DDE_CONVERSATION_CODE
,      DOWNLOAD_FREQ_TYPE
,      FREQ_ARCHIVE
,      FREQ_DOWNLOAD
,      LAST_ARCHIVE_TIME
,      LAST_DOWNLOAD_TIME
,      MOVEMENT_INDICATOR
,      NOS_OF_DAYS
,      ORAFIN_ARCHIVE_FREQ_TYPE
,      ORAFIN_LAST_ARCHIVE_TIME
,      PARTY_CODE
,      PRICE_DESCRIPTION
,      REF_NUMBER
,      RIC_CODE
,      SOURCE
,      SPREAD_BASIS
,      TERM_LENGTH
,      TERM_TYPE
,      TERM_YEAR
,      UPDATE_RATE_YN
,      DAY_COUNT_BASIS
FROM XTR.XTR_MARKET_PRICES#;

Dependencies

[top of page]

XTR.XTR_MARKET_PRICES# references the following:

XTR: XTR_MARKET_PRICES

XTR.XTR_MARKET_PRICES# is referenced by following:

APPS: XTR_BIU_MARKET_PRICES_T; XTR_MARKET_PRICES