Search Results oebv_dscntcasgns

Overview

OEBV_DSCNTCASGNS is a read-only Oracle E-Business Suite view owned by the Order Entry (OE) module. Its name reflects its functional purpose: a "discount customer assignments" construct (DSCNT-CASGNS) used within Oracle Advanced Pricing and Order Management discounting logic. The view exposes the assignment of discounts to customers and customer sites, together with a translated, user-facing label for the customer classification code. In EBS 12.1.1 and 12.2.2, this object exists primarily as a reporting and integration layer, allowing descriptive information about discount-to-customer associations to be queried without directly joining the base discounting tables. The documented ETRM metadata records the view as "Not implemented in this database," meaning it is a delivered, dictionary-registered object rather than a customer-created one. It is defined with the WITH READ ONLY clause, confirming that it is intended strictly for query access.

Underlying Base Objects

The view is defined over three documented base objects. SO_DISCOUNT_CUSTOMERS (aliased DISCOUNT_CUST) is the central table holding the discount-to-customer and discount-to-site assignment records. RA_SITE_USES_ALL (aliased SITE) supplies site-level address context and is joined with an outer (+) operator on SITE_USE_ID, so assignments without a matching site use are retained. AR_LOOKUPS (aliased LOOKUP) supplies the displayable meaning for the customer class and is joined as an outer join constrained to LOOKUP_TYPE = 'CUSTOMER CLASS', with LOOKUP_CODE matched to DISCOUNT_CUST.CUSTOMER_CLASS_CODE. ETRM documents no additional referenced base objects, and the view is not implemented in every database instance, so availability should be verified against the specific environment.

Key Columns

• START_DATE_ACTIVE / END_DATE_ACTIVE — Effective date range governing when the discount-customer assignment is active.
• CUSTOMER_CLASS_NAME — The MEANING from AR_LOOKUPS for the customer class code; this is the column targeted by searches for "customer_class_name" and provides the human-readable class label.
• _DF — A descriptive flexfield reference column carrying the value '_DF:OE:SO_DISCOUNT_CUSTOMERS:DISCOUNT_CUST', indicating the DFF context for the underlying table.
• DISCOUNT_CUSTOMER_ID — Primary identifier of the discount-customer assignment record.
• DISCOUNT_ID — Identifier of the discount definition to which the assignment pertains.
• CUSTOMER_ID / SITE_USE_ID / ADDRESS_ID — The customer, the specific site use, and the resolved address of the assigned entity.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY — Standard WHO audit columns.

Common Use Cases and Queries

This view is typically used to report which discounts are assigned to which customers or sites, and to surface the customer class label for filtering or grouping. A representative query retrieves active assignments with their class names:

• SELECT discount_customer_id, discount_id, customer_id, customer_class_name, start_date_active, end_date_active FROM oebv_dscntcasgns WHERE SYSDATE BETWEEN start_date_active AND NVL(end_date_active, SYSDATE + 1);
• SELECT customer_class_name, COUNT(*) FROM oebv_dscntcasgns GROUP BY customer_class_name;
• SELECT d.discount_id, d.customer_id, s.address_id FROM oebv_dscntcasgns d, ra_site_uses_all s WHERE d.site_use_id = s.site_use_id;

Because the view is read-only and relies on outer joins, queries should account for NULL customer class names where no lookup match exists.