Search Results lead_opp_line_id

Overview

The AS_SALES_LEAD_OPP_LINES table is a core data object within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the AS (Sales Foundation) module. Its primary function is to maintain the transactional linkage between sales lead lines and opportunity lines. This table serves as a critical junction in the sales pipeline, enabling the tracking of how individual product or service items from a qualified sales lead are formally converted into corresponding line items on a sales opportunity. By persisting these relationships, the table provides an auditable trail for sales process analysis and supports key functionality for forecasting and pipeline management.

Key Information Stored

The table's structure is designed to store the minimal yet essential identifiers required to establish the link. The primary key, LEAD_OPP_LINE_ID, uniquely identifies each linkage record. The two most critical foreign key columns are SALES_LEAD_LINE_ID, which references a specific line from the AS_SALES_LEAD_LINES table, and OPP_LINE_ID, which references a specific line from the AS_LEAD_LINES_ALL table (which stores opportunity lines). These columns collectively document which lead line item was the source for a given opportunity line item, forming the backbone of the conversion tracking.

Common Use Cases and Queries

This table is central to reporting and analytics on lead conversion effectiveness. A common use case is generating a report that shows all opportunity lines derived from a particular sales lead or campaign, allowing managers to measure the quality and yield of lead sources. Another scenario involves tracing the history of a won opportunity back to its original lead components for commission analysis or process auditing. A typical query would join this junction table to both lead line and opportunity line detail tables to enrich the data.

SELECT asll.product_name AS lead_product,
       allo.name AS opp_line_product,
       aslol.lead_opp_line_id
FROM   osm.as_sales_lead_opp_lines aslol,
       osm.as_sales_lead_lines asll,
       osm.as_lead_lines_all allo
WHERE  aslol.sales_lead_line_id = asll.sales_lead_line_id
AND    aslol.opp_line_id = allo.lead_line_id
AND    asll.sales_lead_id = :p_lead_id;

Related Objects

The AS_SALES_LEAD_OPP_LINES table exists within a defined relational schema, with documented foreign key relationships to two primary tables:

• AS_SALES_LEAD_LINES: Linked via the SALES_LEAD_LINE_ID column. This table holds the detailed line items (e.g., products, quantities, interests) of a sales lead.
• AS_LEAD_LINES_ALL: Linked via the OPP_LINE_ID column. This table stores the line items for sales opportunities, which are the converted and qualified versions of lead lines.

These relationships enforce referential integrity, ensuring that a link record always points to valid lead and opportunity lines. The table is typically accessed indirectly through Oracle Sales online forms and standard API interfaces rather than via direct DML.