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_FUTURES

Object Details

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

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
XTR_FUTURES_U1	NORMAL	UNIQUE	APPS_TS_INTERFACE	CONTRACT_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
APR_YN	VARCHAR2	(1)
AUDIT_INDICATOR	VARCHAR2	(1)
AUG_YN	VARCHAR2	(1)
AUTHORISED	VARCHAR2	(1)	Yes	Indicates if this record is authorised to be used. Valid values are: Y (authorised) or N (not authorised).
CALCULATION_TYPE	VARCHAR2	(7)
CONTRACT_CODE	VARCHAR2	(7)	Yes
CONTRACT_CONFO	VARCHAR2	(1)
CONTRACT_DAYS	NUMBER
CONTRACT_DESCRIPTION	VARCHAR2	(50)	Yes
CONTRACT_YEARS	NUMBER
CONTRA_CURRENCY	VARCHAR2	(15)
COUPONS_PER_YEAR	NUMBER
COUPON_RATE	NUMBER
CREATED_BY	VARCHAR2	(30)	Yes	User who created this record.
CREATED_ON	DATE		Yes	Date on which this record is created.
CURRENCY	VARCHAR2	(15)
DEC_YN	VARCHAR2	(1)
DELIVERABLE	VARCHAR2	(1)	Yes
EX_CODE	VARCHAR2	(7)	Yes
FEB_YN	VARCHAR2	(1)
FINANCIAL_CONTRACT	VARCHAR2	(1)	Yes
JAN_YN	VARCHAR2	(1)
JUL_YN	VARCHAR2	(1)
JUN_YN	VARCHAR2	(1)
MAR_YN	VARCHAR2	(1)
MAY_YN	VARCHAR2	(1)
NOV_YN	VARCHAR2	(1)
OCT_YN	VARCHAR2	(1)
PRICING_BASIS	VARCHAR2	(7)	Yes
ROUNDING_FACTOR	NUMBER		Yes
SEP_YN	VARCHAR2	(1)
SETTLEMENT_ADJUSTMENT	NUMBER		Yes
TERMINATION_DATE	NUMBER
TERMINATION_DAY	VARCHAR2	(3)
TERMINATION_WEEK	NUMBER
TICK_VALUE	NUMBER
TOTAL_COUPONS	NUMBER
UNIT_SIZE	NUMBER		Yes
UPDATED_BY	VARCHAR2	(30)		Last updated user.
UPDATED_ON	DATE			Last updated date.
YEAR_BASIS	NUMBER

Query Text

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


SELECT APR_YN
,      AUDIT_INDICATOR
,      AUG_YN
,      AUTHORISED
,      CALCULATION_TYPE
,      CONTRACT_CODE
,      CONTRACT_CONFO
,      CONTRACT_DAYS
,      CONTRACT_DESCRIPTION
,      CONTRACT_YEARS
,      CONTRA_CURRENCY
,      COUPONS_PER_YEAR
,      COUPON_RATE
,      CREATED_BY
,      CREATED_ON
,      CURRENCY
,      DEC_YN
,      DELIVERABLE
,      EX_CODE
,      FEB_YN
,      FINANCIAL_CONTRACT
,      JAN_YN
,      JUL_YN
,      JUN_YN
,      MAR_YN
,      MAY_YN
,      NOV_YN
,      OCT_YN
,      PRICING_BASIS
,      ROUNDING_FACTOR
,      SEP_YN
,      SETTLEMENT_ADJUSTMENT
,      TERMINATION_DATE
,      TERMINATION_DAY
,      TERMINATION_WEEK
,      TICK_VALUE
,      TOTAL_COUPONS
,      UNIT_SIZE
,      UPDATED_BY
,      UPDATED_ON
,      YEAR_BASIS
FROM XTR.XTR_FUTURES;

Dependencies

[top of page]

XTR.XTR_FUTURES does not reference any database object

XTR.XTR_FUTURES is referenced by following:

APPS: XTR_FUTURES