Search Results po_doc_style_lines_b




Overview
Explore in AI Chat

Overview

PO_DOC_STYLE_LINES_B is a Purchasing (PO) module table in the Oracle E-Business Suite 12.1.1 and 12.2.2 environments. It stores the document subtype level information associated with a document style. In Oracle Purchasing, a document style controls the appearance, numbering, and behavioral characteristics assigned to a purchasing document type such as a Purchase Order, Purchase Agreement, or RFQ. While the header-level style definition resides in PO_DOC_STYLES_B, this table captures the finer granularity that distinguishes which subtypes (for example, Standard, Blanket, or Contract subtypes) are governed by a given style. Each row therefore links a style to one permitted document subtype and records whether that combination is active.

From a Data Vault modeling perspective, the mined relationship structure classifies this object as standalone, which suggests it is best modeled as a hub keyed on the natural composite business key (STYLE_ID, DOCUMENT_SUBTYPE), with any descriptive flags treated as attributes. This is a heuristic suggestion rather than a mandated design.

Key Information Stored

The table is identified by the primary key constraint PO_DOC_STYLE_LINES_B_PK, defined on the composite columns STYLE_ID and DOCUMENT_SUBTYPE. In this structure the surrogate identity of a row is effectively the combination of these two columns rather than a single generated key, so the primary key and the principal business key coincide.

  • STYLE_ID — Foreign reference to the parent document style in PO_DOC_STYLES_B; identifies which style the subtype line belongs to.
  • DOCUMENT_SUBTYPE — The document subtype governed by the style line; completes the composite primary key.
  • ENABLED_FLAG — Indicates whether the style-to-subtype association is active and available for use on purchasing documents.
  • ZD_EDITION_NAME — Edition discriminator used by the EBS data-model editioning feature; forms part of the unique index PO_DOC_STYLE_LINES_U1.
  • CREATION_DATE, CREATED_BY — Standard WHO audit columns recording when and by whom the row was inserted.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard WHO audit columns recording the most recent modification and the login session that performed it.

The unique index PO_DOC_STYLE_LINES_U1 spans STYLE_ID, DOCUMENT_SUBTYPE, and ZD_EDITION_NAME, confirming the business-key candidate combination while accommodating the editioning column added in 12.2.x.

Common Use Cases and Queries

Typical reporting scenarios include enumerating all permitted subtypes for a style, validating whether a subtype is enabled before document entry, and reconciling styles across editions during upgrades from 12.1.1 to 12.2.2.

A query to list the active subtypes for a given style:

  • SELECT style_id, document_subtype FROM po_doc_style_lines_b WHERE style_id = :p_style_id AND enabled_flag = 'Y';

A join to the parent style header for descriptive reporting:

  • SELECT s.style_name, l.document_subtype, l.enabled_flag FROM po_doc_styles_b s, po_doc_style_lines_b l WHERE s.style_id = l.style_id AND l.enabled_flag = 'Y';

Edition-aware queries in 12.2.2 should filter or join on ZD_EDITION_NAME to avoid duplication across editions when the editioning feature is active.

Related Objects

The following objects are the most significant references to PO_DOC_STYLE_LINES_B based on the documented key relationships and standard Purchasing data model dependencies:

  • PO_DOC_STYLES_B — Parent style table; joined on STYLE_ID. Supplies the style name and header attributes.
  • PO_DOC_STYLES_TL — Translation table for style descriptions, linked through the style header.
  • PO_DOC_STYLE_LINES_TL — Translation counterpart for subtype line descriptions.
  • PO_DOCUMENT_TYPES_ALL_B — Defines document types and subtypes referenced by DOCUMENT_SUBTYPE.
  • PO_HEADERS_ALL — Purchasing documents that consume the style and its permitted subtypes via the STYLE_ID column.
  • PO_DOC_STYLE_LINES_B_PK / PO_DOC_STYLE_LINES_U1 — Primary key and unique index enforcing key integrity and edition uniqueness.

These relationships make PO_DOC_STYLE_LINES_B the connective layer between style definitions and the subtypes that purchasing documents may adopt.