Search Results po_doc_style_lines_tl




Overview
Explore in AI Chat

Overview

PO_DOC_STYLE_LINES_TL is a translatable (TL) table in the Oracle Purchasing (PO) schema. It stores the language-dependent descriptive attributes for individual lines belonging to a purchasing document style. Document styles in Oracle EBS control how purchasing documents such as purchase orders, quotations, and RFQs are numbered, approved, and presented. Each style is composed of one or more style lines, which associate a document subtype with a display name and other descriptive metadata. The base (non-translatable) attributes of those lines reside in PO_DOC_STYLE_LINES_B, while PO_DOC_STYLE_LINES_TL holds the translated display text keyed by language.

The table is classified in the ETRM metadata as standalone under a heuristic Data Vault assessment. As a modeling suggestion, this implies the table is best treated as a reference or descriptive satellite rather than a true hub or link, since it carries no foreign-key relationships to other objects within the documented schema and its primary identifying columns are drawn from its parent business entity.

Key Information Stored

The table contains eleven documented columns. The most significant attributes are:

  • STYLE_ID — Identifier of the parent document style; part of the primary key and the join back to PO_DOC_STYLE_LINES_B and PO_DOC_STYLES_B.
  • DOCUMENT_SUBTYPE — The document subtype the line applies to (for example, a specific purchasing document category); part of the primary key.
  • LANGUAGE — The language code for the translated row; part of the primary key and the discriminator that makes this a TL table.
  • SOURCE_LANG — The language of the source (base) record from which the translation was derived.
  • DISPLAY_NAME — The translated, user-facing name of the document style line; the primary translatable payload of the row.
  • ZD_EDITION_NAME — Editioning column used by the Oracle E-Business Suite online patching infrastructure (12.2.x); participates in the unique index PO_DOC_STYLE_LINES_TL_U1.
  • CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard WHO audit columns recording insert and update metadata.

The surrogate primary key is PO_DOC_STYLE_LINES_TL_PK, defined on (STYLE_ID, DOCUMENT_SUBTYPE, LANGUAGE). A business-key candidate is captured by the unique index PO_DOC_STYLE_LINES_TL_U1 on (STYLE_ID, DOCUMENT_SUBTYPE, LANGUAGE, ZD_EDITION_NAME), which adds the editioning column to the PK columns.

Common Use Cases and Queries

This table is primarily queried for reporting and configuration review. A typical pattern joins the TL table to its base table to retrieve both the code and the translated name for a given style:

  • Listing all translated style lines for a language:
    SELECT style_id, document_subtype, display_name FROM po_doc_style_lines_tl WHERE language = USERENV('LANG');
  • Joining to the base table to reconcile untranslated styles:
    SELECT b.style_id, b.document_subtype, t.display_name FROM po_doc_style_lines_b b, po_doc_style_lines_tl t WHERE b.style_id = t.style_id AND b.document_subtype = t.document_subtype AND t.language = 'US';
  • Reporting untranslated lines by comparing base rows against TL rows for a target language.

Because the table is read-mostly, it is rarely a target of application DML; changes are normally driven through the Document Types and Styles setup forms, which maintain both the _B and _TL rows in parallel.

Related Objects

  • PO_DOC_STYLE_LINES_B — Base (non-translatable) counterpart; joined on STYLE_ID and DOCUMENT_SUBTYPE.
  • PO_DOC_STYLES_B — Parent document style header; joined on STYLE_ID.
  • PO_DOC_STYLES_TL — Translated header attributes for the document style.
  • PO_DOCUMENT_TYPES_ALL_B / _TL — Document type definitions that reference style identifiers.
  • PO_DOC_STYLE_LINES_TL_PK / _U1 — Primary key and unique index enforcing row uniqueness.
  • FND_LANGUAGES — Joined on LANGUAGE and SOURCE_LANG to resolve language descriptions.

Together these objects form the purchasing document-style configuration set, with PO_DOC_STYLE_LINES_TL supplying the multilingual display layer for style lines.