Results for “mod_auth”

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

Overview

APPS.PO_SGD_MOD_HDRS_UDA_V is a reporting view in Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 that exposes user-defined attribute (UDA) values associated with purchasing document headers and their modification drafts. The view pivots descriptive flexfield segment data stored in the PO_HEADERS_ALL_EXT_B extension table into a row-per-attribute format, pairing each attribute value with its internal column name and, where applicable, a decoded display value resolved from purchasing lookup codes.

The view plays a central role in ETRM (E-Business Suite Technical Reference Manual) documentation of contracting and supplier management attributes. It is commonly referenced when reports, integrations, or diagnostics need to retrieve attributes such as modification authority, contract category, priority, set-aside type, and the CCR expiration reason (CCR_EXP_REASON) without joining to flexfield metadata manually. Because it standardizes attribute naming and lookup decoding, it functions as a semantic layer over the raw flexfield storage.

Underlying Base Objects

The view is defined over the following documented base objects:

• PO_HEADERS_ALL_EXT_B (synonym) — the purchasing document header extension table that physically stores UDA column values referenced as poext.col_value.
• EGO_FND_DSC_FLX_CTX_EXT (synonym) — provides the descriptive flexfield context and attribute column metadata, supplying ega.attr_name and ega.col_name used to label each attribute.
• FND_DESCR_FLEX_COLUMN_USAGES (synonym) — flexfield column usage metadata used to map physical segments to their logical attribute names.
• PO_LOOKUP_CODES (view) — supplies decoded descriptions and displayed_field values for many lookup-driven attributes.
• FND_LOOKUP_VALUES (synonym) — resolves values such as NAICS using the FV_NAICS_TYPE lookup and the user's session language.
• FND_GLOBAL (package) — provides environment context such as userenv('lang') for language-sensitive decoding.
• PO_GEN_DIFF_PKG (package) — referenced in the view text for generated difference handling.

The primary key columns exposed are pk1_value (po_header_id) and pk2_value (draft_id), with pk3_value through pk5_value returned as null placeholders, aligning the view with generic UDA retrieval interfaces.

Key Columns

• PK1_VALUE — the PO header identifier (po_header_id) linking rows to the purchasing document.
• PK2_VALUE — the draft identifier (draft_id) associating the UDA value with a specific modification draft.
• PK3_VALUE, PK4_VALUE, PK5_VALUE — null placeholders retained for interface conformity.
• COL_NAME — the underlying flexfield column (segment) name, such as a UDA segment identifier.
• COL_VALUE — the raw stored value for that attribute.
• Decoded attribute values — via a DECODE on attr_name, values are translated using PO_LOOKUP_CODES or FND_LOOKUP_VALUES, producing human-readable results for MOD_AUTH, NO_COMP_RSN, CONTRACT_CATEGORY, ADMIN_SCD, DPAS_RATING, PRIORITY, CUST_PROJ_CODE, SET_ASIDE_TYPE, SIZE_STANDARD, SET_ASIDE_STAT, NAICS, CCR_EXP_REASON, and SUPLR_SIZE.

Common Use Cases and Queries

This view is typically queried to surface header-level UDA values for reporting, integration extracts, or troubleshooting. A representative query retrieving the CCR expiration reason for a header is:

• SELECT pk1_value, col_name, col_value FROM apps.po_sgd_mod_hdrs_uda_v WHERE pk1_value = :po_header_id AND col_name = 'CCR_EXP_REASON';
• SELECT pk1_value, col_name, col_value FROM apps.po_sgd_mod_hdrs_uda_v WHERE col_name IN ('MOD_AUTH','CONTRACT_CATEGORY','SET_ASIDE_TYPE');

Because the view returns both the raw COL_VALUE and its decoded form via the SELECT list DECODEs, BI Publisher reports, custom concurrent programs, and integration interfaces can consume a single row per attribute without additional lookup joins. Note that PO_LOOKUP_CODES decodes require the appropriate lookup_type entries to be enabled, and language-sensitive lookups such as NAICS depend on the session language supplied through FND_GLOBAL.