Search Results lead_rank_code




Overview
Explore in AI Chat

Overview

AST_LS_SALES_LEADS_V is an APPS-owned reporting view in the Oracle EBS TeleSales (AST) module. It consolidates sales lead header, contact, lookup, customer, and resource information into a single, denormalized result set intended for inquiry screens, concurrent report programs, and outbound integrations that need lead data without joining the underlying transactional tables directly. The view draws primarily from the AS_SALES_LEADS synonym (aliased LDH) and its related contact table, decorating raw coded values with their translated meanings from the lookup and translation views.

The user search term source_promotion_code resolves to one specific column in this view. That column is derived from CMP.SOURCE_CODE, where CMP is the AMS_P_SOURCE_CODES_V view joined through the SOURCE_PROMOTION_ID column on the lead header. In other words, SOURCE_PROMOTION_CODE is the human-readable marketing source or promotion code associated with the lead, while SOURCE_PROMOTION_ID carries the internal key.

Underlying Base Objects

The documented base objects for this view span TeleSales, Marketing, Receivables, Order Management, and Trading Community Architecture:

Because the view sits on top of these synonyms and views, it inherits their security and translation behavior while sparing report authors from re-implementing the joins.

Key Columns

Common Use Cases and Queries

The view is frequently used to list open, qualified leads by promotion source, to reconcile lead counts against campaign spend, and to feed external CRM or marketing automation systems.

Sample: list leads with their source promotion code

  • SELECT lead_number, customer_name, status, source_promotion_code FROM apps.ast_ls_sales_leads_v WHERE deleted_flag = 'N';

Sample: aggregate lead counts and budget by promotion source

  • SELECT source_promotion_code, COUNT(*) lead_count, SUM(budget_amount) total_budget FROM apps.ast_ls_sales_leads_v WHERE qualified_flag = 'Y' AND deleted_flag = 'N' GROUP BY source_promotion_code ORDER BY lead_count DESC;

Sample: filter by assigned resource and status

  • SELECT lead_number, assigned_name, status, sales_channel FROM apps.ast_ls_sales_leads_v WHERE assigned_name = :p_resource AND status = 'OPEN';

Always restrict results using DELETED_FLAG, and consider the view’s translation joins when pushing predicates on meaning columns, since those are resolved from the lookup and translation tables at runtime.