Results for “currency_type”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
GL_ENTERED_CURRENCIES_V is a dictionary view owned by the APPS schema in Oracle E-Business Suite General Ledger (GL). It is registered as a VALID object in both 12.1.1 and 12.2.2. The view presents a consolidated, filtered list of currency codes drawn from the currencies and lookups that are relevant to entered-currency processing in General Ledger. Rather than returning every code held in FND_CURRENCIES, the view classifies each row with a currency type indicator and restricts the result set to those codes that GL treats as valid for entry.
The central purpose of the view is to expose the CURRENCY_TYPE attribute, which is the column most frequently cited in searches relating to this object. The view is used wherever GL or dependent modules must differentiate between a standard entered currency ('E'), the Statistical currency ('STAT', type 'S'), and the literal placeholder 'N/A' (type 'T') drawn from GL lookups. Because it is a view rather than a base table, it carries no data of its own and requires no maintenance; it is a read-only projection over its source objects.
Underlying Base Objects
The documented ETRM metadata identifies two referenced base objects: FND_CURRENCIES (referenced through a SYNONYM) and GL_LOOKUPS (itself a VIEW). Both are owned or accessed within the APPS schema.
- FND_CURRENCIES — the Oracle Application Object Library currency definition table. It supplies the set of enabled currency codes and is the source for the 'E' and 'S' rows of the view.
- GL_LOOKUPS — the General Ledger lookup view. It supplies the 'N/A' literal code, restricted to LOOKUP_TYPE = 'LITERAL'.
The view text composes three branches joined with UNION: standard currencies (type 'E') where the code is not 'STAT'; the single statistical currency (type 'S') where the code equals 'STAT'; and the literal lookup code 'N/A' (type 'T') from GL_LOOKUPS. This UNION structure guarantees a single, non-duplicated row per code with an unambiguous type classification, which simplifies downstream filters and reporting.
Key Columns
- CURRENCY_TYPE — a single-character classification applied to each currency row. 'E' denotes a standard entered currency, 'S' denotes the Statistical currency, and 'T' denotes the literal 'N/A' placeholder. This column is the primary selection discriminator used by callers.
- CURRENCY_CODE — the currency or literal identifier itself. For types 'E' and 'S' this is a value from FND_CURRENCIES; for type 'T' it is the LOOKUP_CODE 'N/A' sourced from GL_LOOKUPS. Note that the view aliases LOOKUP_CODE to CURRENCY_CODE in the third branch so that both branches share a common column name.
Common Use Cases and Queries
Typical applications include currency-of-entry selection lists, validation of an entered currency before posting, and reporting that must separate the Statistical currency from ordinary currencies. Because the view already carries the classification, queries avoid complex inline logic.
- Listing only standard entered currencies:
SELECT CURRENCY_CODE FROM GL_ENTERED_CURRENCIES_V WHERE CURRENCY_TYPE = 'E' ORDER BY CURRENCY_CODE; - Isolating the statistical currency:
SELECT CURRENCY_CODE FROM GL_ENTERED_CURRENCIES_V WHERE CURRENCY_TYPE = 'S'; - Retrieving the literal placeholder used for non-currency entry:
SELECT CURRENCY_CODE FROM GL_ENTERED_CURRENCIES_V WHERE CURRENCY_TYPE = 'T'; - Grouping counts by type to audit the available entry set:
SELECT CURRENCY_TYPE, COUNT(*) FROM GL_ENTERED_CURRENCIES_V GROUP BY CURRENCY_TYPE;
All queries are read-only and incur no locking. When integrating with external systems, the CURRENCY_TYPE value should be preserved so that the Statistical and literal cases are not mistaken for ordinary currencies.
-
Lookup Type: CURRENCY_TYPE 12.2.2
currency type used in reports
-
Lookup Type: CURRENCY_TYPE 12.1.1
currency type used in reports
-
Lookup Type: CURRENCY_TYPE 12.1.1
currency type used in reports
-
Lookup Type: CURRENCY_TYPE 12.2.2
currency type used in reports
-
Lookup Type: CURRENCY_TYPE 12.1.1
currency type used in reports
-
Lookup Type: CURRENCY_TYPE 12.2.2
currency type used in reports
-
APPS.GL_ENTERED_CURRENCIES_V·↳ FND_CURRENCIES·↳ GL_LOOKUPS·Explore GL module →
-
APPS.JG_ZZ_ENTERED_CURRENCIES_V·↳ FND_CURRENCIES·↳ GL_LOOKUPS·Explore JG module →
-
APPS.JG_ZZ_ENTERED_CURRENCIES_V·↳ FND_CURRENCIES·↳ GL_LOOKUPS·Explore JG module →
-
APPS.GL_ENTERED_CURRENCIES_V·↳ FND_CURRENCIES·↳ GL_LOOKUPS·Explore GL module →
-
Table: FII_CURR_CONV_RATES 12.1.1
This table stores the currency conversion rates.
-
APPS.GLFV_GL_AVERAGE_BALANCES·↳ FND_CURRENCIES·↳ GL_CODE_COMBINATIONS·↳ GL_DAILY_BALANCES·Explore GL module →
-
APPS.GLBV_GL_AVERAGE_BALANCES·↳ FND_CURRENCIES·↳ GL_CODE_COMBINATIONS·↳ GL_DAILY_BALANCES·Explore GL module →
-
View: GLBV_BUDGET_BALANCES 12.1.1
APPS.GLBV_BUDGET_BALANCES·↳ GL_BALANCES·↳ GL_BUDGET_VERSIONS·↳ GL_CODE_COMBINATIONS·Explore GL module →
-
View: PA_PERF_RULES_V 12.2.2
This view stores the information regarding the available performance rules.
APPS.PA_PERF_RULES_V·↳ PA_LOOKUPS·↳ PA_PERF_RULES·↳ PJI_MT_MEASURES_V·Explore PA module →
-
View: GLFV_BUDGET_BALANCES 12.1.1
APPS.GLFV_BUDGET_BALANCES·↳ GL_BALANCES·↳ GL_BUDGET_VERSIONS·↳ GL_CODE_COMBINATIONS·Explore GL module →
-
This table stores the information regarding the available performance rules.
-
This table stores the information regarding the available performance rules.
-
View: PA_PERF_RULES_V 12.1.1
This view stores the information regarding the available performance rules.
APPS.PA_PERF_RULES_V·↳ PA_LOOKUPS·↳ PA_PERF_RULES·↳ PJI_MT_MEASURES_V·Explore PA module →
-
View: CEBV_CASH_FORECASTS 12.1.1
Business View
APPS.CEBV_CASH_FORECASTS·↳ CE_FORECASTS·↳ CE_FORECAST_HEADERS·↳ CE_LOOKUPS·Explore CE module →
-
View: PA_PERF_OBJECT_RULES_V 12.2.2
10SC Only
APPS.PA_PERF_OBJECT_RULES_V·↳ PA_PERF_OBJECT_RULES·↳ PA_PERF_RULES_V·Explore PA module →
-
View: CEBV_CASH_FORECASTS 12.2.2
Business View
APPS.CEBV_CASH_FORECASTS·↳ CE_FORECASTS·↳ CE_FORECAST_HEADERS·↳ CE_LOOKUPS·Explore CE module →
-
Table: PJI_FM_EXTR_PLN 12.1.1
-
View: PA_PERF_OBJECT_RULES_V 12.1.1
10SC Only
APPS.PA_PERF_OBJECT_RULES_V·↳ PA_PERF_OBJECT_RULES·↳ PA_PERF_RULES_V·Explore PA module →
-
Table: PJI_FM_AGGR_PLN 12.1.1
This is an intermediate summarization table.
-
View: CEFV_CASH_FORECASTS 12.1.1
Business View
APPS.CEFV_CASH_FORECASTS·↳ CE_FORECASTS·↳ CE_FORECAST_HEADERS·↳ CE_LOOKUPS·Explore CE module →
-
View: RG_CURRENCIES_V 12.2.2
10SC ONLY
APPS.RG_CURRENCIES_V·↳ RG_REPORT_PARAMETERS·Explore RG module →
-
View: CEFV_CASH_FORECASTS 12.2.2
Business View
APPS.CEFV_CASH_FORECASTS·↳ CE_FORECASTS·↳ CE_FORECAST_HEADERS·↳ CE_LOOKUPS·Explore CE module →
-
Table: PJI_FM_AGGR_FIN5 12.1.1
This is an intermediate summarization table.
-
APPS.GLFV_GL_STANDARD_BALANCES·↳ GL_BALANCES·↳ GL_BUDGET_VERSIONS·↳ GL_CODE_COMBINATIONS·Explore GL module →
-
View: GLBV_ACTUAL_BALANCES 12.1.1
APPS.GLBV_ACTUAL_BALANCES·↳ GL_BALANCES·↳ GL_CODE_COMBINATIONS·↳ GL_LEDGERS·Explore GL module →
-
View: GLFV_ACTUAL_BALANCES 12.1.1
APPS.GLFV_ACTUAL_BALANCES·↳ GL_BALANCES·↳ GL_CODE_COMBINATIONS·↳ GL_LEDGERS·Explore GL module →
-
View: RG_CURRENCIES_V 12.1.1
10SC ONLY
APPS.RG_CURRENCIES_V·↳ RG_REPORT_PARAMETERS·Explore RG module →
-
Table: PJI_FM_AGGR_FIN4 12.1.1
This is an intermediate summarization table.
-
This table records performance transaction data.
-
This table records performance transaction data.
-
Table: PJI_FP_PROJ_ET_WT_F 12.1.1
This table stores summarized cost and revenue measures at the project, expenditure type and worktype levels for Project Intelligence
-
Assignments of budgets, encumbrances, and currencies to reports
-
Assignments of budgets, encumbrances, and currencies to reports
-
APPS.GLBV_GL_STANDARD_BALANCES·↳ GL_BALANCES·↳ GL_BUDGET_VERSIONS·↳ GL_CODE_COMBINATIONS·Explore GL module →
-
Table: PJI_FP_PROJ_ET_F 12.1.1
This table stores summarized data for cost and revenue measures at the project and expenditure type level for Project Intelligence
-
This table stores denormalized amounts for various amount types for the set of periods defined in the PA_PROJ_PERIOD_PROFILES entity.
-
10SC ONLY
APPS.GL_ALLOC_FORMULA_LINES_V·↳ GL_ALLOC_FORMULA_LINES·↳ GL_BUDGET_VERSIONS·↳ GL_ENCUMBRANCE_TYPES·Explore GL module →
-
Forecasts
-
View: CE_FORECASTS_V 12.1.1
- Retrofitted
APPS.CE_FORECASTS_V·↳ CE_FORECASTS·↳ CE_FORECAST_HEADERS·↳ CE_LOOKUPS·Explore CE module →
-
View: CE_FORECASTS_V 12.2.2
- Retrofitted
APPS.CE_FORECASTS_V·↳ CE_FORECASTS·↳ CE_FORECAST_HEADERS·↳ CE_LOOKUPS·Explore CE module →
-
Table: PJI_AC_PROJ_F 12.1.1
This table stores summarized data for booking and backlog measures at the project level for Project Intelligence