Results for “cst_gl_trans_rate_type”
10 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
CST_GL_TRANSLATION_VIEW is an Oracle E-Business Suite view owned by the APPS schema that consolidates general ledger translation rate information for use by Oracle Cost Management and related reporting components. Its principal function is to expose, in a single denormalized structure, the currency translation rates and rate-type indicators applicable to each inventory organization defined in the enterprise. The view reconciles the set of books assigned to an organization with the translation rates maintained in the General Ledger, converting rate identifiers into descriptive lookup codes and applying rate inversion logic where required.
Because the view joins organization definitions, period calendars, set of books definitions, and lookup tables, it serves as a bridge between the financial and manufacturing domains of EBS. Reporting and integration components that need to know the rate at which a given organization's functional currency translates into a target currency — for a specific accounting period, for the current date, or for the default functional-currency case — can depend on this view rather than reconstituting the joins themselves. In 12.1.1 and 12.2.2 the object retains this role, with no structural divergence documented between the two releases.
Underlying Base Objects
The view is defined over the following documented base objects: FND_CURRENCIES (synonym), FND_GLOBAL (package), FND_LOOKUPS (view), GL_CURRENCY_API (package), GL_PERIODS (synonym), GL_SETS_OF_BOOKS (view), GL_TRANSLATION_RATES (view), HR_GENERAL (package), HR_SECURITY (package), MFG_LOOKUPS (view), and ORG_ORGANIZATION_DEFINITIONS (view).
The core driver is GL_TRANSLATION_RATES, joined to GL_PERIODS on period name and to GL_SETS_OF_BOOKS on the set of books identifier. ORG_ORGANIZATION_DEFINITIONS supplies the organization-to-set-of-books relationship, which is how each inventory organization acquires its functional currency context. MFG_LOOKUPS, filtered on lookup type CST_GL_TRANS_RATE_TYPE, identifies whether the rate is an average or end-of-period rate; FND_LOOKUPS, filtered on lookup type YES_NO, indicates whether the rate must be inverted. The view is a UNION of three branches: period-based historical rates, a default functional-currency row per organization, and a current-date rate obtained through GL_CURRENCY_API. The packages FND_GLOBAL, HR_GENERAL, and HR_SECURITY are referenced in support of organization security and session context.
Key Columns
- ORGANIZATION_ID — Inventory organization identifier; the primary grouping key for consumers.
- PERIOD_NAME — Accounting period for which the rate applies; NULL in the default and current-rate branches.
- PERIOD_YEAR / PERIOD_NUM — Numeric period offsets, set to 0 or 9999 in the non-period branches to mark default and current rows.
- TO_CURRENCY_CODE — Target currency into which amounts are translated.
- ML.LOOKUP_CODE — Rate type from CST_GL_TRANS_RATE_TYPE, distinguishing average from end-of-period treatment.
- FL.LOOKUP_CODE — YES/NO indicator controlling inversion of the stored rate.
- Translated rate columns — A character-formatted rate (trailing zeros trimmed, rounded to 15 places) and a numeric rate rounded to 20 places, the latter being suitable for arithmetic.
Common Use Cases and Queries
Typical consumers retrieve the period-specific rate for an organization and currency, resolve the default functional-currency row where no translation is needed, or obtain the current-date rate for ad hoc conversion. A representative query follows:
SELECT organization_id, period_name, to_currency_code, rate FROM cst_gl_translation_view WHERE organization_id = :org AND period_name = :period;SELECT organization_id, to_currency_code, rate FROM cst_gl_translation_view WHERE period_name IS NULL;SELECT organization_id, to_currency_code, rate FROM cst_gl_translation_view WHERE period_year = 9999;
The first form supports period-end costing and revaluation reporting; the second identifies organizations whose functional currency requires no translation; the third supports current-date conversion in interactive inquiries. Organization security inherited through HR_SECURITY constrains results to the organizations accessible to the executing user.
-
Currency exchange rate for reports : SINGLE-ORG view
APPS.CST_GL_TRANSLATION_VIEW·↳ FND_CURRENCIES·↳ FND_GLOBAL·↳ FND_LOOKUPS·Explore BOM module →
-
APPS.CST_PAC_GL_TRANSLATION_VIEW·↳ FND_CURRENCIES·↳ FND_GLOBAL·↳ FND_LOOKUPS·Explore BOM module →
-
Currency exchange rate for reports : SINGLE-ORG view
APPS.CST_GL_TRANSLATION_VIEW·↳ FND_CURRENCIES·↳ FND_GLOBAL·↳ FND_LOOKUPS·Explore BOM module →
-
12.1.1 FND Design Data 12.1.1
-
12.2.2 FND Design Data 12.2.2