Search Results pricing_attribute38




Overview
Explore in AI Chat

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

OKX_QTE_PRC_ATRBS_V is an APPS-owned database view within the OKX – Contracts Integration product family of Oracle E-Business Suite. It exposes the pricing attribute flexfield data associated with quotes generated and maintained through Oracle Quoting (ASO), presenting a denormalized, report-friendly projection of the underlying pricing attribute storage. The view is documented as VALID in ETRM metadata for both release 12.1.1 and 12.2.2, and its object name is registered as a VIEW in the APPS schema.

Its principal role is to provide a stable read interface over the pricing attribute columns used by Contracts Integration when quotes are copied, referenced, or transformed into contract documents. Rather than requiring downstream logic to enumerate the wide attribute set directly against the base table, the view materializes the descriptive flexfield title, the pricing context, and the full PRICING_ATTRIBUTE1 through PRICING_ATTRIBUTEn column series alongside standard WHO audit columns and concurrent program bookkeeping fields. This design supports extraction, reconciliation, and diagnostic reporting.

Underlying Base Objects

The documented base object referenced by OKX_QTE_PRC_ATRBS_V is ASO_PRICE_ATTRIBUTES, accessed through a SYNONYM. ASO_PRICE_ATTRIBUTES is the Oracle Quoting table that stores the descriptive flexfield segments captured against a quote header or quote line, keyed by PRICE_ATTRIBUTE_ID and related to the quote by QUOTE_HEADER_ID and QUOTE_LINE_ID.

Because the view text is a direct column projection over this single base table, it does not perform joins, unions, or aggregations. The mapping is therefore one-to-one at the row level: every row in the view corresponds to a row in ASO_PRICE_ATTRIBUTES. No filtering predicate is present in the documented view text, so the view returns all pricing attribute records, including those associated with quotes that are not currently active or that have been superseded. Consumers relying on the view for contract-relevant data should apply their own status or quote-relationship filters.

Key Columns

  • PRICE_ATTRIBUTE_ID – Primary key of the pricing attribute record; unique identifier for each attribute row.
  • QUOTE_HEADER_ID / QUOTE_LINE_ID – Foreign keys to the Oracle Quoting header and line, establishing the quote context of the attribute values.
  • FLEX_TITLE – The descriptive flexfield title, identifying which flexfield structure and context the attribute values conform to.
  • PRICING_CONTEXT – The flexfield context value that determines segment validation and meaning.
  • PRICING_ATTRIBUTE1 … PRICING_ATTRIBUTEn – The numbered flexfield segment values. The documented view text enumerates the series at length, and notably the excerpt terminates mid-list at PRICING_ATTRIBUTE7, indicating truncation of the captured DDL rather than a genuine short column list. In practice the view projects the complete contiguous attribute series used by ASO_PRICE_ATTRIBUTES, and column PRICING_ATTRIBUTE100 lies well beyond the range shown in the excerpt.
  • CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN – Standard WHO audit columns.
  • PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, REQUEST_ID – Concurrent program attribution, useful for tracing which batch process populated the attributes.

Common Use Cases and Queries

The view is most frequently used to inspect or extract pricing flexfield values for a given quote before or after contract integration. Because the user search term "pricing_attribute100" refers to a segment outside the range shown in the documented excerpt, developers targeting that segment should confirm the physical presence and spelling of the column against the live view definition using ALL_VIEW_COLUMNS or the view text in DBA_VIEWS.

A typical inspection query retrieves all attributes for a quote line:

  • SELECT PRICE_ATTRIBUTE_ID, QUOTE_HEADER_ID, QUOTE_LINE_ID, FLEX_TITLE, PRICING_CONTEXT, PRICING_ATTRIBUTE1, PRICING_ATTRIBUTE2 FROM APPS.OKX_QTE_PRC_ATRBS_V WHERE QUOTE_LINE_ID = :line_id;

A traceability query joins Program attribution to identify the load process:

  • SELECT REQUEST_ID, PROGRAM_ID, PROGRAM_APPLICATION_ID, COUNT(*) FROM APPS.OKX_QTE_PRC_ATRBS_V GROUP BY REQUEST_ID, PROGRAM_ID, PROGRAM_APPLICATION_ID;

For dynamic discovery of the full attribute series, query the data dictionary rather than assuming the highest index:

When projecting segments by name via dynamic SQL or a reporting layer, the view also supports context-driven extraction using FLEX_TITLE and PRICING_CONTEXT as grouping keys, enabling attribute completeness audits for integrated quotes.