Search Results as_leads_all




Overview
Explore in AI Chat

Overview

The AS_LEADS_ALL table is a core transactional entity within the Oracle E-Business Suite Sales Foundation module (AS). It serves as the central repository for storing sales opportunity data, commonly referred to as leads or opportunities, across the enterprise. As a multi-organization table, denoted by the "_ALL" suffix, it contains data for all operating units, with access typically governed by the MO: Operating Unit security profile. Its primary role is to track the entire lifecycle of a sales opportunity, from initial creation through qualification, forecasting, and ultimately to closure (won or lost). The table's extensive foreign key relationships with other fundamental EBS modules, such as Trading Community Architecture (HZ), Receivables (RA), and Resource Manager (JTF), underscore its critical integration point for customer, financial, and sales force data.

Key Information Stored

The table's structure captures comprehensive details for each sales opportunity. The primary key is the system-generated LEAD_ID. Essential columns include identifiers for the involved CUSTOMER_ID (linked to HZ_PARTIES and RA_CUSTOMERS) and ADDRESS_ID. It tracks ownership and assignment via OWNER_SALESFORCE_ID (linked to JTF_RS_RESOURCE_EXTNS) and OWNER_SALES_GROUP_ID. The sales process is managed through links to SALES_STAGE_ID (AS_SALES_STAGES_ALL_B) and SALES_METHODOLOGY_ID. Financial aspects are recorded with CURRENCY_CODE, revenue amounts, and WIN_PROBABILITY. The table also holds data for opportunity source (SOURCE_PROMOTION_ID), status (STATUS), close competitor (CLOSE_COMPETITOR_ID), and key dates for creation, last update, and close.

Common Use Cases and Queries

This table is fundamental for sales pipeline management, forecasting, and performance reporting. Common operational and analytical queries include extracting the open opportunity pipeline by salesperson or team, calculating weighted revenue forecasts, and analyzing win/loss rates by stage or competitor. A typical query to retrieve active opportunities for a specific sales group would join to resource and customer tables:

  • SELECT l.lead_id, l.NAME, l.AMOUNT, l.CURRENCY_CODE, s.STAGE_NAME, p.PARTY_NAME FROM AS_LEADS_ALL l, AS_SALES_STAGES_ALL_B s, HZ_PARTIES p WHERE l.SALES_STAGE_ID = s.STAGE_ID AND l.CUSTOMER_ID = p.PARTY_ID AND l.OWNER_SALES_GROUP_ID = :group_id AND l.STATUS = 'OPEN';

Data from AS_LEADS_ALL is also frequently accessed via Oracle's Sales APIs for programmatic creation, update, and conversion of leads, and is a primary source for embedded CRM dashboards and standard reports like the Opportunity Detail and Pipeline Summary.

Related Objects

AS_LEADS_ALL has a wide array of dependent and associated objects, reflecting its central role. Key child tables that store detailed information for each lead include AS_LEAD_LINES_ALL (for products/items), AS_LEAD_CONTACTS_ALL, AS_LEAD_COMPETITORS, and AS_INTERESTS_ALL. It is referenced by audit and history tables such as AS_LEAD_LOG and AS_CHANGED_ACCOUNTS_ALL. Crucially, it maintains foreign key relationships with master data tables: HZ_PARTIES and RA_CUSTOMERS for customer data, JTF_RS_RESOURCE_EXTNS for sales resources, FND_CURRENCIES, AS_STATUSES_B, and AS_SALES_STAGES_ALL_B. The relationship with ASO_QUOTE_RELATED_OBJECTS facilitates integration with the Quoting module, linking opportunities to formal quotes.