Search Results invoiced_amount




Overview
Explore in AI Chat

Overview

APPS.ICX_CST_CUSTOMER_30DAY_V is a reporting view in the Oracle E-Business Suite (EBS) e-commerce and costing schema. It is part of the Oracle iStore / Customer Self-Service margin analysis infrastructure and is designed to present customer-level sales and margin performance for a rolling 30-day period. The view aggregates invoiced revenue and margin amounts per customer, then derives percentage-based metrics that allow buyers, sales representatives, and internal analysts to compare the relative contribution of each customer against total organizational sales and margin.

The suffix 30DAY reflects that the view filters exclusively on a period code of '30D', meaning it returns figures tied to the trailing 30-day accounting window maintained by the margin analysis build process. The view is not a transactional object; it exposes summarized analytical output and is intended for read-only reporting and dashboard consumption rather than data entry or integration writes.

Underlying Base Objects

The view is defined over two base objects:

The two tables are joined with the condition MA.BUILD_ID = MB.BUILD_ID, ensuring that only rows belonging to the current margin build are returned. A predicate of MARGIN IS NOT NULL removes records lacking a computed margin value. Multi-organization security is enforced through a comparison of MA.ORG_ID against the organization identifier decoded from the USERENV('CLIENT_INFO') session context. This mechanism restricts results to the operating unit or inventory organization the caller is authorized to view, defaulting to a sentinel value of -99 when no organization context is present. Neither base object is further documented in the ETRM metadata, so lineage beyond this join cannot be confirmed from the supplied text.

Key Columns

  • CUSTOMER_ID — unique identifier of the customer used as the grouping key.
  • SOLD_TO_CUSTOMER_NAME — the customer name associated with the sold-to party.
  • SUM(INVOICED_AMOUNT) — total invoiced revenue for the customer over the 30-day period. This is the primary measure matching the search term invoiced_amount.
  • SUM(MARGIN) — total margin generated by the customer for the same period.
  • CUSTOMER_MARGIN_PCT — margin as a percentage of invoiced amount, computed as MARGIN / INVOICED_AMOUNT * 100, rounded to two decimals; returns NULL when invoiced amount is zero.
  • SALES_PCT — the customer's invoiced amount as a percentage of total sales for the 30-day period, obtained via ICX_MARGIN_WEB_ANA_PKG.ICX_GET_TOTAL_SALES('30D').
  • MARGIN_PCT — the customer's margin as a percentage of total margin for the period, obtained via ICX_MARGIN_WEB_ANA_PKG.ICX_GET_TOTAL_MARGIN('30D').
  • PERIOD — the analysis period code, fixed to '30D' by the HAVING clause.
  • TO_DATE / TO_DATE - 30 — the ending and starting dates bounding the 30-day window.

Common Use Cases and Queries

Typical usage centers on margin dashboards, customer scorecards, and exception reporting. To rank customers by invoiced revenue within the 30-day window:

  • SELECT customer_id, sold_to_customer_name, SUM(invoiced_amount)
  • FROM apps.icx_cst_customer_30day_v
  • ORDER BY 3 DESC;

To identify customers whose margin percentage falls below a threshold:

  • SELECT customer_id, sold_to_customer_name, customer_margin_pct
  • FROM apps.icx_cst_customer_30day_v
  • WHERE customer_margin_pct < 10;

Because SALES_PCT and MARGIN_PCT depend on packaged functions that return totals for the caller's authorized organization, results vary by session context. Reports built on this view should therefore rely on APPS-level connectivity and correct CLIENT_INFO initialization to avoid misleading comparisons.