Search Results customer_status_code




Overview
Explore in AI Chat

Overview

AS_OPPORTUNITY_DETAILS_V is a reporting and integration view owned by the APPS schema in Oracle E-Business Suite, belonging to the AS - Sales Foundation product family. It consolidates opportunity (lead) data sourced primarily from AS_LEADS_ALL and enriches it with decoded lookup meanings, customer party attributes, offer information, and sales stage data. The view exposes a denormalized, readable projection of the opportunity record, making it suitable for operational reporting, dashboards, and outbound interfaces that must not query the transactional base tables directly. In EBS 12.1.1 and 12.2.2 the object is documented as VALID, and it remains a stable read-only interface for Sales Foundation opportunity data. It is particularly relevant to users searching on methodology_name, because the view exposes both SALES_METHODOLOGY_ID and METHODOLOGY_CODE columns associated with the opportunity's sales methodology, though the METHODOLOGY_NAME column is returned as a literal NULL in the documented view text.

Underlying Base Objects

The documented view metadata identifies the following referenced objects:

The joins are implemented as outer joins so that opportunities lacking an associated party, offer, or lookup value are still returned.

Key Columns

Common Use Cases and Queries

Typical uses include pipeline reports, opportunity extracts for CRM or data warehouse loads, and interfaces that need a single flattened source. A sample query retrieving methodology-linked opportunities follows:

  • SELECT lead_number, status_code, sales_methodology_id, methodology_code, total_amount, currency_code FROM apps.as_opportunity_details_v WHERE deleted_flag = 'N';
  • SELECT lead_number, customer_name, win_probability, decision_date FROM apps.as_opportunity_details_v WHERE sales_stage_id = :stage_id ORDER BY decision_date;
  • SELECT o.lead_number, o.mean_vehicle_response FROM apps.as_opportunity_details_v o WHERE o.vehicle_response_code IS NOT NULL;

Because METHODOLOGY_NAME is null, join AS_LOOKUPS or the methodology base table on METHODOLOGY_CODE to obtain the descriptive name. All queries should filter on DELETED_FLAG to exclude soft-deleted opportunities.