Search Results cust_prof

Overview

The APPS.OE_AK_SOLD_TO_ORGS_V view is a seeded Oracle E-Business Suite database object delivered as part of the Order Management (ONT) application schema. It exposes a consolidated "sold-to" party/account profile organized across operating units, and it is a component of the Oracle Order Management public API and flexibility infrastructure (the OE_AK_ prefix indicates its association with Order Management attribute/descriptive-flexfield processing). The view joins customer account data, customer profile data, party records, and HR operating units into a single denormalized result set that returns the ordering attributes EBS uses to default order header values.

For reporting and integration purposes, this view is frequently used as a lookup layer where a caller needs the primary customer account attributes — price list, freight terms, shipping tolerances, order type, sales channel, standard terms, and the effective bill-to and ship-to site-use identifiers — resolved for a specific operating unit. It is heavily referenced by tools and reports searching on the term "cust_prof" because the HZ_CUSTOMER_PROFILES table is a core component of its definition, providing the STANDARD_TERMS value.

Underlying Base Objects

The view is defined over the following documented base objects:

• HZ_PARTIES (synonym) — supplies the party identity, joined to the customer account through PARTY_ID.
• HZ_CUST_ACCOUNTS (synonym) — the primary driver, providing the customer account and its ordering attributes.
• HZ_CUSTOMER_PROFILES (synonym) — joined via an outer join on CUST_ACCOUNT_ID, with the additional restriction SITE_USE_ID IS NULL so that only account-level (not site-level) profile rows participate.
• HR_OPERATING_UNITS (view) — supplies the ORGANIZATION_ID representing the operating unit context.
• MO_GLOBAL (package) — invoked as MO_GLOBAL.CHECK_ACCESS(HR.ORGANIZATION_ID), applying Multi-Org Access Control so only operating units accessible to the current session are returned.
• OE_HEADER_UTIL (package) — its GET_PRIMARY_SITE_USE_ID function resolves the primary BILL_TO and SHIP_TO site-use identifiers for the account/organization combination.

Key Columns

• CUST_ACCOUNT_ID — the sold-to customer account identifier, the primary key context.
• PRICE_LIST_ID, FOB_POINT, FREIGHT_TERM, SHIP_PARTIAL, SHIP_VIA — default ordering and shipping attributes drawn from the account.
• INVOICE_TO_ORG_ID, SHIP_TO_ORG_ID — resolved primary site-use IDs for bill-to and ship-to, computed via OE_HEADER_UTIL.
• STANDARD_TERMS — the standard payment terms sourced from HZ_CUSTOMER_PROFILES.
• ORDER_TYPE_ID, PRIMARY_SALESREP_ID, SALES_CHANNEL_CODE — order classification and sales attribution attributes.
• WAREHOUSE_ID — the default warehouse, cast from character to numeric via TO_NUMBER(TO_CHAR(...)).
• OVER_SHIPMENT_TOLERANCE, UNDER_SHIPMENT_TOLERANCE, OVER_RETURN_TOLERANCE, UNDER_RETURN_TOLERANCE — fulfillment tolerance thresholds.
• ITEM_CROSS_REF_PREF, DATE_TYPE_PREFERENCE, DATES_NEGATIVE_TOLERANCE, DATES_POSITIVE_TOLERANCE — cross-reference and date handling preferences.
• DEFAULT_LINE_SET — derived value returning 'SHIP', 'ARRIVAL', or NULL based on the ship-set and arrival-set flags.
• ORGANIZATION_ID — the operating unit identifier from HR_OPERATING_UNITS.

Common Use Cases and Queries

Typical usage resolves a customer's ordering defaults for an operating unit, or drives integrations that need bill-to/ship-to identifiers. A representative query:

• SELECT cust_account_id, price_list_id, standard_terms, invoice_to_org_id, ship_to_org_id, default_line_set, organization_id FROM apps.oe_ak_sold_to_orgs_v WHERE cust_account_id = :p_account_id;

Because access is filtered through MO_GLOBAL.CHECK_ACCESS, callers must run with a valid Multi-Org session context (via FND_GLOBAL.APPS_INITIALIZE) or results may be empty. Joining this view to HZ_CUST_SITE_USES_ALL or HZ_CUST_ACCT_SITES_ALL is common when reporting on customer profile defaults ("cust_prof" searches), since the account-level profile is the source of STANDARD_TERMS.