Search Results pro_admin_office




Overview
Explore in AI Chat

Overview

The PO_SGD_ADDRESSES_UDA_V view is a Purchasing (PO) module object owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. Its purpose is to expose the user-defined descriptive flexfield attribute values associated with the "ADDRESSES" context of the PO_HEADER_EXT_ATTRS descriptive flexfield on purchasing documents. Rather than presenting the flexfield segments as physically stored in the PO_HEADERS_ALL_EXT_B extension table, the view unpivots and normalizes those segments into a generic key/value row format keyed by PO_HEADER_ID and DRAFT_ID. In effect, it flattens the EGO descriptive flexfield context metadata so that each attribute becomes a separate row carrying both a generated column name and its stored value.

The view is intended for reporting, integration, and diagnostic queries where the caller needs to resolve descriptive flexfield attribute values for purchasing addresses (such as offices) without hard-coding the underlying flexfield segment columns. It is part of the supplier/global descriptive flexfield (SGD) infrastructure that supports address-related office codes on PO headers.

Underlying Base Objects

The view is defined over four documented base objects:

The address types covered in the unpivot are restricted to a fixed list: SBA_OFFICE, PRO_ADMIN_OFFICE, INV_OFFICE, PAY_OFFICE, ISSUING_OFFICE, COTR_OFFICE, ADMIN_OFFICE, and REQ_OFFICE.

Key Columns

  • PK1_VALUE — primary key value, sourced from PO_HEADER_ID, identifying the purchasing document header.
  • PK2_VALUE — secondary key value, sourced from DRAFT_ID, identifying the draft of the document.
  • PK3_VALUE, PK4_VALUE, PK5_VALUE — reserved placeholders returned as NULL.
  • COL_NAME — the generated attribute name, formed as UPPER(ADDRESS_TYPE || '_' || ATTR_NAME), e.g. ISSUING_OFFICE_ATTRIBUTE1 style names.
  • COL_VALUE — the actual descriptive flexfield segment value for the row's attribute.
  • COL_DESC — a description column; for the ADDRESSCODE attribute it resolves the CLM office code from HR_LOCATION_EXTRA_INFO, otherwise NULL.

This is the col_desc element most commonly searched when locating descriptive text for an address-related user-defined attribute.

Common Use Cases and Queries

The view is typically queried to retrieve descriptive flexfield values for a purchasing document header in a generic, unpivoted form, or to join back to PO_HEADERS_ALL for reporting. A representative query follows:

  • SELECT pk1_value, pk2_value, col_name, col_value, col_desc FROM apps.po_sgd_addresses_uda_v WHERE pk1_value = :po_header_id; — returns all address-related attribute rows for a given header.
  • SELECT col_value FROM apps.po_sgd_addresses_uda_v WHERE pk1_value = :po_header_id AND col_name = 'ISSUING_OFFICE_ADDRESSCODE'; — retrieves a specific office code attribute.
  • Joined with PO_HEADERS_ALL on pk1_value = po_header_id to present flexfield values alongside standard segment columns.

Because the view normalizes flexfield segments into rows, it is well suited to ad hoc reporting, data extraction, and integration interfaces that must remain resilient to flexfield segment configuration changes.