Results for “ex_code”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

XTR_FUTURES_V is a reporting view owned by the APPS schema within the Oracle E-Business Suite Treasury (XTR) module. It exposes futures contract definition data maintained in Oracle EBS 12.1.1 and 12.2.2, including pricing conventions, currency details, coupon/financial instrument attributes, and termination rules. Because it is a view rather than a table, XTR_FUTURES_V does not store data of its own; it presents a curated column list projected from the base futures contract entity, allowing reports, concurrent programs, and integrations to read contract setup information without directly querying the underlying table. This abstraction supports consistent, read-only access for downstream reporting and interface development.

Underlying Base Objects

The documented metadata identifies the referenced base object as XTR_FUTURES, accessed through a synonym. The view is defined by a simple SELECT that projects a defined set of columns from XTR_FUTURES, including CONTRACT_CODE, CURRENCY, CALCULATION_TYPE, TICK_VALUE, and related contract attributes. No joins, aggregations, or filter predicates are documented in the view text, so XTR_FUTURES_V returns one row per record in the underlying XTR_FUTURES contract definition table. This direct mapping simplifies lineage and means the view inherits the ownership and access characteristics of the APPS schema objects.

Key Columns

• CONTRACT_CODE – Primary identifier for the futures contract definition.
• CONTRACT_DESCRIPTION – Descriptive text for the contract.
• FINANCIAL_CONTRACT / DELIVERABLE / PRICING_BASIS – Classification and valuation attributes describing the contract type and how it is priced.
• CALCULATION_TYPE – Indicates the calculation method applied to the contract, a key column frequently referenced in pricing and valuation reporting.
• EX_CODE – Exchange code associated with the contract.
• TICK_VALUE, UNIT_SIZE, ROUNDING_FACTOR – Contract size and pricing precision attributes used in value calculations.
• CURRENCY / CONTRA_CURRENCY – Primary and contra currency for the instrument.
• YEAR_BASIS, CONTRACT_DAYS, CONTRACT_YEARS, COUPONS_PER_YEAR, TOTAL_COUPONS, COUPON_RATE – Interest and accrual parameters.
• TERMINATION_DATE, TERMINATION_DAY, TERMINATION_WEEK – Terms governing contract expiry.
• JAN_YN … DEC_YN – Monthly flags indicating active months for the contract.
• AUTHORISED, AUDIT_INDICATOR, CREATED_BY/ON, UPDATED_BY/ON – Status, audit, and ownership tracking columns.

Common Use Cases and Queries

Typical usage involves reporting on futures contract setup, validating calculation and pricing conventions, and feeding downstream valuation or interface processes. Because CALCULATION_TYPE is a commonly searched attribute, queries frequently filter or group on it alongside contract and currency details.

Example — list contracts by calculation type:

• SELECT contract_code, contract_description, calculation_type, currency, tick_value FROM xtr_futures_v WHERE calculation_type = :p_calculation_type;

Example — contract and currency overview:

• SELECT contract_code, financial_contract, currency, contra_currency, year_basis, coupon_rate FROM xtr_futures_v ORDER BY contract_code;

Example — active monthly flags and termination terms:

• SELECT contract_code, termination_date, jan_yn, apr_yn, jul_yn, oct_yn FROM xtr_futures_v WHERE authorised = 'Y';

These queries illustrate read-only reporting against the view. Oracle recommends filtering and joining through the documented columns rather than assuming behavior beyond the projected structure.