Results for “asbv_sales_competitors”

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

Overview

ASBV_SALES_COMPETITORS is a read-only database view belonging to the AS - Sales Foundation product family within Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It presents competitor information associated with sales leads, exposing attributes such as the competitor identity, the products involved, and free-text comments recorded against a given lead-competitor association. The view is designated as a "read only" object in its definition (via the WITH READ ONLY clause), meaning it is intended strictly for query, reporting, and integration consumption rather than for direct DML operations.

In the context of the EBS Sales Foundation data model, this view serves as a reporting-friendly projection of lead-competitor data. Because it encapsulates the join logic and applies lookup translation support through the AS_LOOKUPS mechanism (via the _LA:COMPETITOR_CODE column), it shields downstream consumers from having to reconstruct those relationships manually. It is a candidate object for custom reports, extracts, and integration interfaces that need to surface competitive intelligence captured during lead management.

Underlying Base Objects

The view is defined over a single base table, AS_LEAD_COMPETITORS, aliased as COM in the view text. The documented structure indicates no additional joined base objects; all columns are sourced directly from this table. The view applies the WITH READ ONLY constraint, and lookup translation is handled through the AS_LOOKUPS lookup type COMPETITOR through the special _LA:COMPETITOR_CODE descriptor column.

Notably, the ETRM metadata records that this view is "Not implemented in this database," meaning it may not exist as a deployed object in every environment. Implementers should confirm object existence before relying on it. Where absent, equivalent logic can be reproduced directly against AS_LEAD_COMPETITORS joined to AS_LOOKUPS_VL or the relevant lookup view for competitor code meanings.

Key Columns

• _LA:COMPETITOR_CODE — A lookup-translation descriptor that resolves the competitor code to its meaningful display value via the AS_LOOKUPS COMPETITOR lookup type.
• COMPETITOR — The raw competitor identifier or code stored on the lead-competitor record.
• PRODUCTS — The products associated with the competitor for this lead.
• COMMENTS — Free-text remarks recorded about the competitor in the lead context.
• _DF — A descriptive-flexfield descriptor column.
• LEAD_COMPETITOR_ID — Primary key of the underlying AS_LEAD_COMPETITORS record.
• LEAD_ID — Foreign reference to the parent sales lead.
• COMPETITOR_ID — Reference to the competitor entity.
• LAST_UPDATE_DATE / LAST_UPDATED_BY — Audit columns recording the last modification.
• CREATION_DATE / CREATED_BY — Audit columns recording record creation.

Common Use Cases and Queries

Typical use cases include competitive analysis reporting, lead qualification dashboards, and extracts feeding CRM or marketing analytics. The following query retrieves competitor details for a specific lead:

• SELECT lead_id, competitor, products, comments FROM asbv_sales_competitors WHERE lead_id = :p_lead_id;
• SELECT competitor, COUNT(*) FROM asbv_sales_competitors GROUP BY competitor ORDER BY 2 DESC;
• SELECT c.lead_id, c.competitor, c.products FROM asbv_sales_competitors c WHERE c.creation_date >= :p_from_date;

These queries support competitor frequency analysis, lead-level competitive tracking, and time-bounded extraction for downstream integration. Consumers should account for the possibility that the view is not deployed in their environment.