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

TABLE: XTR.XTR_FUTURES

Object Details
Object Name: XTR_FUTURES
Object Type: TABLE
Owner: XTR
FND Design Data: TableXTR.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: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
XTR_FUTURES_U1 NORMAL UNIQUE TablespaceAPPS_TS_INTERFACE ColumnCONTRACT_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:

SchemaXTR
ViewXTR_FUTURES#