Search Results po_doc_style_headers_u1

Overview

PO_DOC_STYLE_HEADERS is a Purchasing (PO) schema table that stores the document style definitions used to govern procurement behavior across the lifecycle of a purchasing document. A document style determines how a document is displayed and how it may be used, including which pricing and financing features are enabled. In Oracle EBS, the styles defined here apply to Standard Purchase Orders, Global Agreements, and Global Contracts, allowing an implementation to enforce consistent procurement rules without duplicating configuration per document.

The table is classified heuristically as a standalone object under the Data Vault modeling convention. It has no documented foreign-key dependencies on other tables, and the primary key PO_DOC_STYLE_HEADERS_PK is defined on STYLE_ID. In Data Vault terms, this would be modeled as a hub for the style business key, with descriptive attributes such as the feature flags behaving as satellite content. The table resides in the APPS_TS_TX_DATA tablespace with PCTFREE 10, and its indexes reside in APPS_TS_TX_IDX.

Key Information Stored

The surrogate primary key is STYLE_ID (NUMBER), enforced by PO_DOC_STYLE_HEADERS_PK and also by the unique index PO_DOC_STYLE_HEADERS_U1, which in the 12.2.2 physical schema is documented on (STYLE_ID, ZD_EDITION_NAME). The business-facing identifiers are STYLE_NAME and STYLE_DESCRIPTION, each VARCHAR2(240) and each supported by a nonunique index (N1 and N2 respectively), plus STYLE_TYPE, which accepts DEFAULT or STANDARD. STYLE_ID, LOOKUP-derived values such as STATUS (ACTIVE/INACTIVE) and LINE_TYPE_ALLOWED (ALL/SPECIFIED) are drawn from PO_LOOKUP_CODES.

• STYLE_ID — surrogate identifier and primary key.
• STYLE_NAME / STYLE_DESCRIPTION — user-visible name and description.
• STYLE_TYPE — DEFAULT or STANDARD classification of the style.
• STATUS — ACTIVE or INACTIVE, sourced from PO_LOOKUP_CODES.
• LINE_TYPE_ALLOWED — ALL or SPECIFIED line-type restriction.
• ADVANCES_FLAG, RETAINAGE_FLAG, PROGRESS_PAYMENT_FLAG, CONTRACT_FINANCING_FLAG — financing feature toggles.
• PRICE_BREAKS_FLAG, PRICE_DIFFERENTIALS_FLAG, ENHANCED_PRICING_FLAG, COMPLEX_PRICING_FLAG — pricing capability toggles.
• CHANGE_PROCESS_TYPE, CTRL_ACTN_IN_CHGDOC_FLAG, CONC_MODS_ENABLED_FLAG — change-order processing controls.
• WF_APPROVAL_ITEMTYPE, WF_APPROVAL_PROCESS, AME_TRANSACTION_TYPE, MOD_AME_TRANSACTION_TYPE, PAR_AME_TRANSACTION_TYPE — approval routing configuration.
• DELIVERABLE_HOLD_FLAG, SINGLE_DISTRIBUTION_FLAG, INFO_FUNDED_SLIN_FLAG, WARRANT_ENABLED_FLAG — operational and funding behavior flags.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard WHO audit columns.
• ZD_EDITION_NAME — editioning column supporting EBR-enabled deployments.

Common Use Cases and Queries

Typical uses include identifying which style is the default, auditing which styles enable contract financing or retainage, and reporting the approval workflow assigned to each style. Because the table is standalone, queries generally filter and join on STYLE_ID, STYLE_NAME, or STATUS rather than traversing foreign keys.

• Listing active styles: SELECT style_id, style_name, style_type FROM po.po_doc_style_headers WHERE status = 'ACTIVE';
• Finding a style by name: SELECT style_id, style_description FROM po.po_doc_style_headers WHERE style_name = :p_style_name;
• Auditing financing features: SELECT style_name, advances_flag, retainage_flag, progress_payment_flag FROM po.po_doc_style_headers WHERE contract_financing_flag = 'Y';
• Reporting approval configuration: SELECT style_name, wf_approval_itemtype, wf_approval_process, ame_transaction_type FROM po.po_doc_style_headers;

Related Objects

Although the table is standalone with respect to declared foreign keys, purchasing documents reference the style selected for a given document through STYLE_ID on the document header records. The following are the most significant related objects in a typical implementation.

• PO_LOOKUP_CODES — provides the valid values for STATUS and LINE_TYPE_ALLOWED, joined by lookup type and lookup code.
• PO_DOC_STYLE_LINES — holds line-type-level rules that qualify each document style, joined on STYLE_ID.
• PO_HEADERS_ALL — associates each purchasing document with the style applied to it, joined on STYLE_ID.
• PO_AGREEMENTS_ALL — global agreements and contracts that carry the selected style.
• PO_DOCUMENT_TYPES_ALL — defines the document types whose behavior the style governs.
• PO_LOOKUP_TYPES — defines the lookup categories from which style values derive.
• FND_LOOKUP_VALUES — the runtime source of lookup meanings displayed for STATUS and LINE_TYPE_ALLOWED.
• WF_ITEM_TYPES / WF_PROCESSES — hold the approval workflows referenced by WF_APPROVAL_ITEMTYPE and WF_APPROVAL_PROCESS.