Results for “as_sales_lead_lines”

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

Overview

The AS_SALES_LEAD_LINES table resides in the OSM schema and belongs to the AS – Sales Foundation product family within Oracle E-Business Suite releases 12.1.1 and 12.2.2. It stores the line-level detail of sales leads captured in Oracle Sales, complementing the parent header record held in AS_SALES_LEADS. Each row represents a discrete interest expressed by a prospective customer, such as a product of interest, a budgeted amount, a quantity, or a promotional association, and is therefore central to lead qualification, opportunity conversion, and pipeline reporting.

From a heuristic Data Vault modeling perspective, the FK topology suggests a satellite-leaning classification. The table carries a surrogate primary key (SALES_LEAD_LINE_ID) and depends on the parent lead hub, while also referencing multiple descriptive and classification dimensions such as interest types, interest codes, inventory items, promotions, and offers. This profile is characteristic of a satellite attached to a lead hub rather than a pure link table.

Key Information Stored

The table is documented with 42 columns. The most significant are:

• SALES_LEAD_LINE_ID — surrogate primary key, enforced by AS_SALES_LEAD_LINES_PK and backed by unique index AS_SALES_LEAD_LINES_U1. This is the sole documented business-key candidate.
• SALES_LEAD_ID — foreign key to AS_SALES_LEADS, linking each line to its parent lead.
• STATUS_CODE — lifecycle status of the individual lead line.
• INTEREST_TYPE_ID — FK to AS_INTEREST_TYPES_B, classifying the nature of the interest.
• PRIMARY_INTEREST_CODE_ID and SECONDARY_INTEREST_CODE_ID — FKs to AS_INTEREST_CODES_B, providing coded interest detail.
• INVENTORY_ITEM_ID and ORGANIZATION_ID — FK to MTL_SYSTEM_ITEMS_B, identifying the product of interest and its inventory organization.
• UOM_CODE and QUANTITY — unit of measure and quantity associated with the line.
• BUDGET_AMOUNT — monetary budget value recorded for the line.
• SOURCE_PROMOTION_ID — FK to AMS_SOURCE_CODES, tracing the promotional source.
• OFFER_ID — FK to AMS_ACT_OFFERS, tying the line to a marketing offer.
• CATEGORY_ID and CATEGORY_SET_ID — category assignment for the lead line.
• SECURITY_GROUP_ID — FK to FND_SECURITY_GROUPS for multi-org security.
• Standard WHO columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY) and 15 ATTRIBUTE flex columns with ATTRIBUTE_CATEGORY; OBJECT_VERSION_NUMBER supports optimistic locking.

Common Use Cases and Queries

Typical reporting scenarios include lead-line detail reports, pipeline analysis by product or interest code, promotion effectiveness measurement, and conversion tracking into quotes.

SELECT l.sales_lead_line_id, l.sales_lead_id, l.status_code,
       l.quantity, l.budget_amount, i.segment1 item_number
FROM   as_sales_lead_lines l,
       mtl_system_items_b i
WHERE  l.inventory_item_id = i.inventory_item_id
AND    l.organization_id  = i.organization_id
AND    l.sales_lead_id    = :p_sales_lead_id;

Aggregate budget by interest type:

SELECT l.interest_type_id, SUM(l.budget_amount) total_budget
FROM   as_sales_lead_lines l
WHERE  l.status_code = 'OPEN'
GROUP  BY l.interest_type_id;

Trace promotion-attributed lines using SOURCE_PROMOTION_ID and OFFER_ID, or join to ASO_QUOTE_RELATED_OBJECTS to identify lead lines already converted to quotes.

Related Objects

• AS_SALES_LEADS — parent header via SALES_LEAD_ID.
• AS_INTEREST_TYPES_B and AS_INTEREST_CODES_B — interest classification lookups.
• MTL_SYSTEM_ITEMS_B — product master via INVENTORY_ITEM_ID/ORGANIZATION_ID.
• AMS_SOURCE_CODES and AMS_ACT_OFFERS — marketing source and offer associations.
• ASO_QUOTE_RELATED_OBJECTS — references lead lines through OBJECT_ID for quote linkage.
• AS_SALES_LEAD_OPP_LINES — child table keyed by SALES_LEAD_LINE_ID.
• IGR_I_A_LINES and IGS_RC_I_A_LINES — interface tables that reference SALES_LEAD_LINE_ID.