Results for “gl_daily_conversion_types_v”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The view GL_DAILY_CONVERSION_TYPES_V is an Oracle E-Business Suite database object owned by the APPS schema and defined within the General Ledger (GL) product family. Its ETRM metadata designates it as "10SC ONLY," indicating that it is a supplemental or site-specific view associated with a 10SC implementation or configuration rather than a core, universally deployed GL object. The view presents currency conversion (daily) rate types together with row-level privilege information derived from Oracle's data security framework.
Functionally, the view exposes the same conversion type identifiers and descriptions found in GL_DAILY_CONVERSION_TYPES, but augments each row with three calculated privilege flags: VIEW_PRIVILEGE, USE_PRIVILEGE, and MODIFY_PRIVILEGE. These flags allow consumers to determine, per user, whether the current session may view, use, or modify a given conversion type. This security-aware projection makes the view suitable for reporting and integration scenarios where rate type visibility must respect Oracle data security grants.
Underlying Base Objects
Per the documented view text, GL_DAILY_CONVERSION_TYPES_V is defined over the following objects:
- GL_DAILY_CONVERSION_TYPES (SYNONYM) — the base table (referenced via the alias
CT) that stores conversion type definitions, includingUSER_CONVERSION_TYPE,CONVERSION_TYPE,DESCRIPTION, andSECURITY_FLAG. - FND_DATA_SECURITY (PACKAGE) — supplies
FND_DATA_SECURITY.CHECK_FUNCTION, which evaluates whether the current user holds a specific privilege on a given conversion type. - FND_GLOBAL (PACKAGE) — supplies
FND_GLOBAL.USER_NAME, used to pass the current user identity into the security check.
The view is therefore a join-free projection: it selects from the synonym GL_DAILY_CONVERSION_TYPES and applies DECODE logic together with Oracle data security function calls to compute the three privilege columns.
Key Columns
- USER_CONVERSION_TYPE — the user-facing name of the conversion (daily) rate type; the primary identifier reported to and referenced by users.
- CONVERSION_TYPE — the internal conversion type code, used for programmatic joins and lookups.
- DESCRIPTION — the descriptive text associated with the conversion type.
- VIEW_PRIVILEGE — 'Y' or 'N', indicating whether the current user has view access; determined by
FND_DATA_SECURITY.CHECK_FUNCTIONagainst the data security objectGL_DAS_RATE_TYPES_VwhenSECURITY_FLAGis 'Y'. - USE_PRIVILEGE — 'Y' or 'N', indicating use access, evaluated against
GL_DAS_RATE_TYPES_U. - MODIFY_PRIVILEGE — 'Y' or 'N', indicating modify access, evaluated against
GL_DAS_RATE_TYPES_M.
Where SECURITY_FLAG is not set to 'Y', the DECODE expression returns 'Y' for each privilege, effectively granting full access.
Common Use Cases and Queries
Typical usage includes security-filtered list-of-values queries, self-service reporting of available rate types, and integration extracts that must exclude rate types a user cannot access. A representative query restricts output to conversion types the current user may use:
- A simple listing:
SELECT user_conversion_type, conversion_type, description FROM apps.gl_daily_conversion_types_v ORDER BY user_conversion_type; - A privilege-filtered listing:
SELECT user_conversion_type, description FROM apps.gl_daily_conversion_types_v WHERE use_privilege = 'Y'; - A security audit:
SELECT user_conversion_type, view_privilege, use_privilege, modify_privilege FROM apps.gl_daily_conversion_types_v;
Because privilege evaluation depends on the session context (FND_GLOBAL.USER_NAME), results vary by the user executing the query. The view should be treated as a 10SC-specific, security-aware presentation layer over GL_DAILY_CONVERSION_TYPES and is not intended as a substitute for the base table in maintenance operations.
-
10SC ONLY
APPS.GL_DAILY_CONVERSION_TYPES_V·↳ FND_DATA_SECURITY·↳ FND_GLOBAL·↳ GL_DAILY_CONVERSION_TYPES·Explore GL module →
-
10SC ONLY
APPS.GL_DAILY_CONVERSION_TYPES_V·↳ FND_DATA_SECURITY·↳ FND_GLOBAL·↳ GL_DAILY_CONVERSION_TYPES·Explore GL module →
-
View: OKL_CREDITLINES_UV 12.1.1
User interface view for Credit Line Contract Page
APPS.OKL_CREDITLINES_UV·↳ ARP_ADDR_LABEL_PKG·↳ FND_CURRENCIES_VL·↳ FND_DATA_SECURITY·Explore OKL module →
-
View: OKL_CREDITLINES_UV 12.2.2
User interface view for Credit Line Contract Page
APPS.OKL_CREDITLINES_UV·↳ ARP_ADDR_LABEL_PKG·↳ FND_CURRENCIES_VL·↳ FND_DATA_SECURITY·Explore OKL module →
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.1.1 FND Design Data 12.1.1
-
12.2.2 FND Design Data 12.2.2
-
PACKAGE: APPS.GL_LEDGERS_PKG 12.1.1
-
PACKAGE: APPS.GL_LEDGERS_PKG 12.2.2