Search Results gl_das_rate_types_m

Overview

APPS.GL_DAILY_CONVERSION_TYPES_V is a security-enabled reporting and integration view in Oracle E-Business Suite General Ledger. It exposes the set of daily conversion (currency rate) types defined in the application, augmented with row-level data-security privileges resolved at query time for the current user. Rather than presenting the underlying configuration table directly, the view projects three privilege indicators — VIEW_PRIVILEGE, USE_PRIVILEGE, and MODIFY_PRIVILEGE — that reflect whether the connected user may view, use, or modify each conversion type. This makes the view the preferred access point for forms, concurrent programs, and custom code that must respect Oracle data security on rate types.

The object responds to the search term "gl_das_rate_types_v" because the data-security function references the GL_DAS_RATE_TYPES security group name internally, which is the naming convention adopted in the underlying security model for daily conversion types.

Underlying Base Objects

The view is defined strictly over the synonym GL_DAILY_CONVERSION_TYPES, which resolves to the base GL daily conversion types table. Three documented base objects are referenced:

• GL_DAILY_CONVERSION_TYPES (SYNONYM) — the primary source of conversion type code, user name, description, and the SECURITY_FLAG controlling whether row-level security applies.
• FND_DATA_SECURITY (PACKAGE) — supplies the CHECK_FUNCTION call used to evaluate each privilege per conversion type and per user.
• FND_GLOBAL (PACKAGE) — supplies USER_NAME to identify the current application user in the privilege evaluation.

The join is effectively a per-row scalar evaluation rather than a table join: for every conversion type row, CHECK_FUNCTION is invoked up to three times, once for each privilege token (GL_DAS_RATE_TYPES_V, GL_DAS_RATE_TYPES_U, GL_DAS_RATE_TYPES_M).

Key Columns

• USER_CONVERSION_TYPE — the user-facing name of the conversion type, taken from CT.USER_CONVERSION_TYPE.
• CONVERSION_TYPE — the internal, language-independent code for the conversion type, taken from CT.CONVERSION_TYPE.
• DESCRIPTION — descriptive text for the conversion type.
• VIEW_PRIVILEGE — 'Y' if the user may view the rate type; derived from SECURITY_FLAG and the GL_DAS_RATE_TYPES_V check.
• USE_PRIVILEGE — 'Y' if the user may use the rate type in transactions; derived from the GL_DAS_RATE_TYPES_U check.
• MODIFY_PRIVILEGE — 'Y' if the user may amend the rate type; derived from the GL_DAS_RATE_TYPES_M check.

When SECURITY_FLAG is not 'Y', all three privilege columns default to 'Y', meaning unrestricted access.

Common Use Cases and Queries

Typical scenarios include populating rate-type list-of-values restricted to types the user may use, auditing which users hold modify rights, and validating a rate type before inserting daily rates. A representative unrestricted query is:

• SELECT conversion_type, user_conversion_type, description FROM apps.gl_daily_conversion_types_v WHERE view_privilege = 'Y';
• SELECT conversion_type FROM apps.gl_daily_conversion_types_v WHERE use_privilege = 'Y' ORDER BY user_conversion_type;
• SELECT user_conversion_type, modify_privilege FROM apps.gl_daily_conversion_types_v WHERE modify_privilege = 'Y';

Because privilege evaluation depends on FND_GLOBAL.USER_NAME, results vary by session user; reports and interfaces should therefore always filter on the privilege columns rather than treating the view as a static list.