Results for “set_aside_stat”

2 results




Overview
Explore in AI Chat

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

Overview

The PO_SGD_HDRS_UDA_V view is a Purchasing (PO) module reporting object owned by the APPS schema. In Oracle E-Business Suite 12.1.1 and 12.2.2 it presents header-level User-Defined Attribute (UDA) and descriptive flexfield values captured against sourcing, contract, and solicitation documents. The view flattens the descriptive flexfield context extension table into one row per attribute, pairing each stored column value with a resolvable display value. It is used by Oracle's Supplier Qualification, Sourcing, and Contract Lifecycle Management (CLM) functionality, and it exposes coded attributes such as modification authority, competition reason, contract category, set-aside type, NAICS classification, and the CCR expiration reason referenced by the search term ccr_exp_reason. The CCV_EXP_REASON attribute is among the enumerated flex attributes that this view decodes.

Underlying Base Objects

The documented base objects for this view are:

  • PO_HEADERS_ALL_EXT_B (synonym) — the extension/base table holding the descriptive flexfield column values keyed by PO_HEADER_ID and DRAFT_ID.
  • EGO_FND_DSC_FLX_CTX_EXT (synonym) — supplies the descriptive flexfield context extension metadata, including attribute names (ATTR_NAME) and column names (COL_NAME).
  • FND_DESCR_FLEX_COLUMN_USAGES (synonym) — descriptive flexfield column usage definitions that drive the alternate flexfield model.
  • PO_LOOKUP_CODES (view) — the Purchasing lookup view used to translate stored codes into human-readable descriptions or displayed fields. It is queried repeatedly inside inline DECODE/subquery expressions.
  • FND_LOOKUP_VALUES (synonym) — the common lookup table, used here for the NAICS lookup type FV_NAICS_TYPE and filtered by the user's language session via USERENV('LANG').
  • FND_GLOBAL (package) — the standard EBS session/context package supplying environment values such as language.
  • PO_GEN_DIFF_PKG (package) — the Purchasing generic difference/derivation package referenced in the view definition, used to compute or compare changed flexfield values.

The view therefore depends on both the transactional header extension table and the flexfield metadata tables, with PO_LOOKUP_CODES providing the translation layer between raw codes and their displayed meanings.

Key Columns

  • PK1_VALUE — maps to PO_HEADER_ID, the header identifier linking each row to the purchasing document.
  • PK2_VALUE — maps to DRAFT_ID, identifying the draft version of the document (relevant to the 12.2.x online drafting model).
  • PK3_VALUE, PK4_VALUE, PK5_VALUE — placeholders returned as NULL, since this view is header-scoped.
  • COL_NAME — the underlying descriptive flexfield column name for the attribute.
  • COL_VALUE — the raw stored value of the attribute, prior to translation.
  • Derived display value — after decoding, the attribute is emitted with a translated value from PO_LOOKUP_CODES or FND_LOOKUP_VALUES, depending on ATTR_NAME.

The alternate attributes specifically translated include MOD_AUTH (lookup PO_UDA_MOD_AUTHORITY), NO_COMP_RSN, CONTRACT_CATEGORY, ADMIN_SCD, DPAS_RATING, PRIORITY, CUST_PROJ_CODE, SET_ASIDE_TYPE, SIZE_STANDARD, SET_ASIDE_STAT, NAICS, and CCR_EXP_REASON (lookup PO_CLM_CCR_EXP_REASON).

Common Use Cases and Queries

This view supports reporting on solicitation and contract attributes that are otherwise stored as generic flexfield values, and it is commonly used by integrations that need the displayed meaning rather than the raw code. A representative query retrieves the CCR expiration reason for a specific header:

  • SELECT pk1_value, col_name, col_value FROM apps.po_sgd_hdrs_uda_v WHERE pk1_value = :header_id;
  • SELECT pk1_value, col_name, col_value FROM apps.po_sgd_hdrs_uda_v WHERE col_name = 'CCR_EXP_REASON';
  • SELECT pk1_value FROM apps.po_sgd_hdrs_uda_v WHERE col_name = 'SET_ASIDE_TYPE' AND col_value = 'SBA';

Because values are pivoted by attribute name, consumers typically join back to PO_HEADERS_ALL on PK1_VALUE or aggregate rows per header to obtain a denormalized reporting set of contract and solicitation attributes.