Search Results total_sales_pct




Overview
Explore in AI Chat

Overview

ICX_CST_CUSTOMER_90DAY_V is an Oracle E-Business Suite self-service web view owned by the APPS schema. It is classified in the ETRM as a Web view designed to simplify access from Oracle Self-Service Web Applications, and it belongs to the ICX design data repository (ICX.ICX_CST_CUSTOMER_90DAY_V). The view supports the Margin Analysis by Customer inquiry used by Web Employees, presenting customer-level cost margin results for a rolling 90-day window.

In EBS 12.1.1 and 12.2.2, the object is registered as VALID. Its role is essentially analytical rather than transactional: it exposes pre-aggregated sales and margin figures per customer, along with computed percentage columns, so that the self-service inquiry layer can present margin performance without joining or aggregating transactional tables at runtime. The view is a named query over stored margin analysis results, which makes it appropriate for reporting and dashboard-style integration rather than for posting or transactional processing.

Underlying Base Objects

The documented dependencies of the view are APPS.CST_MARGIN_BUILD, APPS.ICX_MARGIN_ANALYSIS, and APPS.ICX_MARGIN_WEB_ANA_PKG. The principal source is ICX_MARGIN_ANALYSIS, which stores customer, sales, margin, and percentage analysis rows produced by the Cost Margin Load process. CST_MARGIN_BUILD is the Cost Management build object associated with that load, and ICX_MARGIN_WEB_ANA_PKG is the package referenced by the view (dependent code is available via the ETRM).

The view retrieves customers and their related sales, margin, and percentage amounts from ICX_MARGIN_ANALYSIS, selecting associated data no more than 90 days older than the TO_DATE of the Cost Margin Load process. The PERIOD column is fixed to the code value '90D'. The ETRM notes that ICX_CST_CUSTOMER_90DAY_V is not referenced by any other database object, confirming it is a terminal, consumer-facing reporting object.

Key Columns

  • CUSTOMER_ID (NUMBER) — Customer identifier, the join key to customer master data.
  • CUSTOMER_NAME (VARCHAR2(50)) — Customer name as displayed in the inquiry.
  • SALES (NUMBER) — Total sales amount by customer for the analysis window.
  • MARGIN (NUMBER) — Total margin amount by customer for the analysis window.
  • CUSTOMER_MARGIN_PCT (VARCHAR2(40)) — Total margin amount to total sales amount percentage for the customer.
  • TOTAL_SALES_PCT (VARCHAR2(40)) — Total sales amount percentage, the column most frequently searched against this view.
  • TOTAL_MARGIN_PCT (VARCHAR2(40)) — Total margin amount percentage.
  • PERIOD (VARCHAR2) — Period of the margin analysis; the value is 90 days, code '90D'.
  • TO_DATE, FROM_DATE (DATE) — Build date to and from values defining the analysis window.

Note that the three percentage columns are exposed as VARCHAR2(40), not numeric types. Consumers must apply explicit numeric conversion before performing arithmetic, sorting, or aggregation, and should account for any formatting or null values carried from the source table.

Common Use Cases and Queries

The primary use case is the Margin Analysis by Customer self-service inquiry, where the view supplies customers ranked or filtered by sales contribution and margin percentage. For example, to rank customers by their share of total sales:

  • SELECT customer_id, customer_name, sales, total_sales_pct FROM apps.icx_cst_customer_90day_v ORDER BY TO_NUMBER(total_sales_pct) DESC;
  • SELECT customer_name, sales, margin, customer_margin_pct FROM apps.icx_cst_customer_90day_v WHERE TO_NUMBER(customer_margin_pct) > 20;
  • SELECT customer_id, sales, from_date, to_date FROM apps.icx_cst_customer_90day_v WHERE period = '90D';

Typical scenarios include margin performance review by customer, identification of high-revenue but low-margin accounts, and validation of the Cost Margin Load window (FROM_DATE to TO_DATE). Because the view is not referenced by other database objects, it is safe to query directly for ad hoc reporting without impact on dependent code. When data appears stale, the Cost Margin Load process and CST_MARGIN_BUILD output should be reviewed, since the view reflects only the most recent 90-day analysis window.