Search Results supplier_enabled_flag

Overview

PA_RES_FORMATS_VL is a bilingual (VL) view owned by the APPS schema in Oracle E-Business Suite, belonging to the Projects (PA) product family. It presents user-defined resource formats — the configuration records that determine which resource attributes are captured, displayed, and enabled when resources are assigned to project expenditures, assignments, or planning rows. In Oracle EBS 12.1.1 and 12.2.2, the VL suffix indicates a view that joins a language-independent base table with a translation table, resolving translated columns (NAME and DESCRIPTION) to the session's current language. Reporting queries, Oracle Forms, and integration extract programs against Projects resource definitions typically address this view rather than the underlying tables directly.

Underlying Base Objects

The documented view definition references two base objects:

• PA_RES_FORMATS_B — the language-independent base table holding the format identifiers, sequence, resource class, and the enabled/display flags for each resource attribute.
• PA_RES_FORMATS_TL — the translation table supplying language-specific NAME and DESCRIPTION values.

The view joins these on RES_FORMAT_ID and filters the translation side by T.LANGUAGE = USERENV('LANG'), so only the row matching the current language context is returned. This join pattern is the standard Oracle Applications translated-view convention and explains why NAME and DESCRIPTION appear only once per format even when multiple translations exist.

Key Columns

• RES_FORMAT_ID — the unique identifier (primary key) of the resource format; the join key across the two base tables.
• RESOURCE_FORMAT_SEQ — display sequence controlling the order in which resource formats are listed.
• RESOURCE_CLASS_ID / RESOURCE_CLASS_FLAG — the resource class to which the format applies and its enabling flag.
• RES_TYPE_ID / RES_TYPE_ENABLED_FLAG / RESOURCE_TYPE_DISP_CHARS — the resource type, whether the type attribute is enabled for entry, and its display width.
• ORGN_*, FIN_CAT_*, INCURRED_BY_* — corresponding enabled flags and display widths for organization, financial category, and incurred-by attributes.
• SUPPLIER_*, ROLE_* — the same enable/display pair for supplier and role attributes.
• NAME / DESCRIPTION — the language-translated labels for the format.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, plus ROW_ID.

The *_ENABLED_FLAG columns commonly carry Y/N values indicating whether the attribute is presented to the user; the *_DISP_CHARS columns record the displayed character width configured for each field.

Common Use Cases and Queries

Typical uses include reporting on configured resource formats, validating which attributes are enabled, and joining resource formats to resource definitions or expenditure entries for extract and reconciliation reporting.

• List all formats in the current language session.
• Identify formats where supplier or role capture is enabled.
• Join to translation and base records for a specific RES_FORMAT_ID.

Sample query:

• SELECT res_format_id, name, resource_format_seq FROM pa_res_formats_vl ORDER BY resource_format_seq;
• SELECT res_format_id, name, supplier_enabled_flag, role_enabled_flag FROM pa_res_formats_vl WHERE supplier_enabled_flag = 'Y';
• SELECT b.res_format_id, t.name FROM pa_res_formats_b b, pa_res_formats_tl t WHERE b.res_format_id = t.res_format_id AND t.language = USERENV('LANG') AND b.res_format_id = :format_id;

All columns are read-only through the view; DML must target the underlying B and TL tables. As with all Oracle Applications views, queries should run under a responsibility whose MO or data security profile restricts access appropriately.