Results for “fnd_printer_styles_vl”
34 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
FND_PRINTER_STYLES_VL is a descriptive (VL, or "view with language") view owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It belongs to the FND — Application Object Library product and is documented in ETRM as a view of FND_PRINTER_STYLES and FND_PRINTER_STYLES_TL. The view presents printer style definitions used by the Oracle Reports and concurrent processing architecture, combining the language-independent attributes of a printer style with its translated, user-facing name. Printer styles control physical page formatting for report output, including page width, page length, print orientation, and whether a header is emitted. The VL suffix indicates that the view performs an implicit language join against FND_PRINTER_STYLES_TL using USERENV('LANG'), so consumers automatically see the translated printer style name appropriate to the current session language. For reporting, integration, and administrative queries, FND_PRINTER_STYLES_VL is the preferred read interface because it exposes descriptive text alongside technical attributes without requiring the caller to manage the translation table directly. The view is documented as VALID in ETRM 12.2.2 and is flagged Oracle Proprietary, Confidential Information under the standard legal notices.
Underlying Base Objects
The view is defined over two referenced base objects, both exposed to APPS through synonyms: FND_PRINTER_STYLES (the base, language-independent table) and FND_PRINTER_STYLES_TL (the translation table). The documented view text is:
SELECT B.ROWID, B.PRINTER_STYLE_NAME, B.SEQUENCE, B.LAST_UPDATE_DATE, B.LAST_UPDATED_BY, B.CREATION_DATE, B.CREATED_BY, B.LAST_UPDATE_LOGIN, B.WIDTH, B.LENGTH, B.DESCRIPTION, B.ORIENTATION, B.SRW_DRIVER, B.HEADER_FLAG, T.USER_PRINTER_STYLE_NAME FROM FND_PRINTER_STYLES_TL T, FND_PRINTER_STYLES B WHERE B.PRINTER_STYLE_NAME = T.PRINTER_STYLE_NAME AND T.LANGUAGE = USERENV('LANG')
The join key is PRINTER_STYLE_NAME, and the language predicate is T.LANGUAGE = USERENV('LANG'). This means a row is returned only when a translation exists for the session language. All technical columns are sourced from the B (base) alias, while only USER_PRINTER_STYLE_NAME is sourced from the T (translation) alias. Because the join is an inner join, printer styles lacking a translation row for the active language are not returned by this view; querying FND_PRINTER_STYLES directly is required to see every defined style regardless of translation status.
Key Columns
The view exposes eleven columns from the base table and one from the translation table, plus ROWID.
- ROW_ID — ROWID of the underlying FND_PRINTER_STYLES row; unique row identifier within the view.
- PRINTER_STYLE_NAME — Internal, language-independent name of the printer style; the join key between the base and translation tables.
- SEQUENCE — Ordering value used when presenting or processing printer styles.
- WIDTH — Page width applied by the style for report output.
- LENGTH — Page length applied by the style.
- ORIENTATION — Print orientation (for example portrait or landscape) for the style.
- SRW_DRIVER — Oracle Reports (SRW) driver identifier associated with the style.
- HEADER_FLAG — Flag indicating whether header output is produced for the printer style. This column directly answers the common
header_flagsearch and is one of the principal formatting controls referenced by report administrators. - DESCRIPTION — Descriptive text for the printer style, stored on the base table.
- USER_PRINTER_STYLE_NAME — Translated, user-facing name of the printer style, sourced from FND_PRINTER_STYLES_TL for the session language.
- Audit columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, and LAST_UPDATE_LOGIN, inherited from the base table and used for change tracking and auditing.
Common Use Cases and Queries
The view is typically queried to inventory printer styles, inspect formatting attributes such as HEADER_FLAG, and join printer style names to concurrent program or report definitions. The following sample lists the primary technical and translated attributes for all styles visible in the current session language:
SELECT printer_style_name,
user_printer_style_name,
sequence,
width,
length,
orientation,
srw_driver,
header_flag
FROM fnd_printer_styles_vl
ORDER BY sequence, printer_style_name;
To isolate styles that produce a header, filter on the HEADER_FLAG column:
SELECT printer_style_name,
user_printer_style_name,
header_flag
FROM fnd_printer_styles_vl
WHERE header_flag = 'Y';
A further use case is auditing recently modified printer styles using the inherited audit columns:
SELECT printer_style_name,
user_printer_style_name,
last_update_date,
last_updated_by
FROM fnd_printer_styles_vl
WHERE last_update_date > SYSDATE - 30;
Because the view enforces the USERENV('LANG') predicate, administrators comparing output across languages should query FND_PRINTER_STYLES_TL explicitly. For all standard reporting and integration requirements, however, FND_PRINTER_STYLES_VL provides the documented, translation-aware interface to printer style configuration in both Oracle EBS 12.1.1 and 12.2.2.
-
View: FND_PRINTER_STYLES_VL 12.1.1
View of FND_PRINTER_STYLES and FND_PRINTER_STYLES_TL
APPS.FND_PRINTER_STYLES_VL·↳ FND_PRINTER_STYLES·↳ FND_PRINTER_STYLES_TL·Explore FND module →
-
View: FND_PRINTER_STYLES_VL 12.2.2
View of FND_PRINTER_STYLES and FND_PRINTER_STYLES_TL
APPS.FND_PRINTER_STYLES_VL·↳ FND_PRINTER_STYLES·↳ FND_PRINTER_STYLES_TL·Explore FND module →
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.1.1 FND Design Data 12.1.1
-
12.2.2 FND Design Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
eTRM - FND Tables and Views 12.2.2
No longer used
-
eTRM - FND Tables and Views 12.1.1
No longer used
-
eTRM - FND Tables and Views 12.2.2
No longer used
-
eTRM - FND Tables and Views 12.1.1
No longer used