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


VIEW: APPS.XTR_FUTURES_V

Object Details
Object Name: XTR_FUTURES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewXTR.XTR_FUTURES_V
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.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
CONTRACT_CODE VARCHAR2 (7) Yes
CONTRACT_DESCRIPTION VARCHAR2 (50) Yes
FINANCIAL_CONTRACT VARCHAR2 (1) Yes
DELIVERABLE VARCHAR2 (1) Yes
PRICING_BASIS VARCHAR2 (7) Yes
AUTHORISED VARCHAR2 (1) Yes
CREATED_BY VARCHAR2 (30) Yes
CREATED_ON DATE
Yes
SETTLEMENT_ADJUSTMENT NUMBER
Yes
UNIT_SIZE NUMBER
Yes
ROUNDING_FACTOR NUMBER
Yes
EX_CODE VARCHAR2 (7) Yes
CALCULATION_TYPE VARCHAR2 (7)
TICK_VALUE NUMBER

CURRENCY VARCHAR2 (15)
CONTRA_CURRENCY VARCHAR2 (15)
YEAR_BASIS NUMBER

CONTRACT_DAYS NUMBER

CONTRACT_YEARS NUMBER

COUPONS_PER_YEAR NUMBER

TOTAL_COUPONS NUMBER

COUPON_RATE NUMBER

TERMINATION_DATE NUMBER

TERMINATION_DAY VARCHAR2 (3)
TERMINATION_WEEK NUMBER

CONTRACT_CONFO VARCHAR2 (1)
JAN_YN VARCHAR2 (1)
FEB_YN VARCHAR2 (1)
MAR_YN VARCHAR2 (1)
APR_YN VARCHAR2 (1)
MAY_YN VARCHAR2 (1)
JUN_YN VARCHAR2 (1)
JUL_YN VARCHAR2 (1)
AUG_YN VARCHAR2 (1)
SEP_YN VARCHAR2 (1)
OCT_YN VARCHAR2 (1)
NOV_YN VARCHAR2 (1)
DEC_YN VARCHAR2 (1)
UPDATED_BY VARCHAR2 (30)
UPDATED_ON DATE

AUDIT_INDICATOR VARCHAR2 (1)
Query Text

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


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

Dependencies

[top of page]

APPS.XTR_FUTURES_V references the following:

SchemaAPPS
SynonymXTR_FUTURES

APPS.XTR_FUTURES_V is not referenced by any database object