Results for “cust_prof”

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

Overview

OE_AK_SOLD_TO_ORGS_V is a read-only Oracle E-Business Suite view owned by the APPS schema and validated in the Order Management (ONT) product family. It belongs to the Oracle Order Management "AK" (Application Kit / attribute mapping) family of views that expose descriptive and transactional attributes of a sold-to organization for use in ordering workflows, defaulting logic, and reporting. The view presents, for each valid combination of customer account and operating unit, the defaulted order-entry attributes that Order Management applies when an order is created for a given sold-to party — including price list, freight terms, shipping method, payment terms, order type, sales representative, sales channel, and tolerance thresholds.

The view is exposed for external reporting and integration consumption rather than for direct DML. Its most notable feature is the embedded Multi-Org access control at the operating unit level: the WHERE clause calls MO_GLOBAL.CHECK_ACCESS(HR.ORGANIZATION_ID), which restricts the returned rows to operating units that the current session is authorized to access under the Multi-Org Access Control (MOAC) security model.

Underlying Base Objects

According to the ETRM metadata for 12.2.2, OE_AK_SOLD_TO_ORGS_V is defined over the following referenced base objects:

• HR_OPERATING_UNITS (VIEW) — supplies the ORGANIZATION_ID / ORG_ID context for each returned row.
• HZ_CUST_ACCOUNTS (SYNONYM) — the customer account header, providing price list, freight terms, shipment tolerances, order type, and salesrep attributes.
• HZ_CUSTOMER_PROFILES (SYNONYM) — supplies the customer profile fields, most importantly STANDARD_TERMS used as the payment term.
• HZ_PARTIES (SYNONYM) — the party-level record to which the customer account is linked.
• MO_GLOBAL (PACKAGE) — invoked for operating unit access checking (MOAC security).
• OE_HEADER_UTIL (PACKAGE) — invoked via GET_PRIMARY_SITE_USE_ID to resolve the primary bill-to and ship-to site use identifiers.

The customer-profile join is an outer join (CUST_PROF.CUST_ACCOUNT_ID(+)) with the filter CUST_PROF.SITE_USE_ID(+) IS NULL, ensuring that only the account-level profile (not site-level profiles) drives the terms default.

Key Columns

• ORGANIZATION_ID / ORG_ID — the operating unit identifier returned from HR_OPERATING_UNITS; governs MOAC filtering.
• PRICE_LIST_ID, FOB_POINT_CODE, FREIGHT_TERMS_CODE, SHIPPING_METHOD_CODE — default pricing and shipping attributes from the customer account.
• INVOICE_TO_ORG_ID, SHIP_TO_ORG_ID — primary bill-to and ship-to site use IDs resolved via OE_HEADER_UTIL.GET_PRIMARY_SITE_USE_ID.
• PAYMENT_TERM_ID — the payment term, sourced as CUST_PROF.STANDARD_TERMS (customer profile standard terms).
• ORDER_TYPE_ID, SALESREP_ID, SALES_CHANNEL_CODE — default order type, primary sales representative, and sales channel.
• OVER_SHIPMENT_TOLERANCE, UNDER_SHIPMENT_TOLERANCE, OVER_RETURN_TOLERANCE, UNDER_RETURN_TOLERANCE — shipment and return quantity tolerance limits.
• SHIP_FROM_ORG_ID — derived from the customer account warehouse.
• DEFAULT_LINE_SET — a DECODE expression resolving to 'SHIP' or 'ARRIVAL' based on the ship-set and arrival-set include-lines flags.

Common Use Cases and Queries

This view is typically queried to determine the sold-to defaults or to validate MOAC access for a known account. A typical query filtering by customer account and organization is:

SELECT organization_id, price_list_id, payment_term_id, ship_to_org_id, invoice_to_org_id FROM oe_ak_sold_to_orgs_v WHERE organization_id = :org_id;

Because the view's WHERE clause calls MO_GLOBAL.CHECK_ACCESS, callers must ensure the correct operating unit context is initialized (via MO_GLOBAL.SET_POLICY_CONTEXT or the FND session's org context) or the view may return no rows even where data exists. This makes it useful both as a reporting source and as a reference object when diagnosing why Order Management defaults failed to populate for a given sold-to account.