Results for “salesrep_name”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

ICX_CST_SALES_REP_30DAY_V is an APPS-owned reporting view in Oracle EBS that presents margin analysis summarized by sales representative for a rolling 30-day window. It belongs to the ICX (Oracle iProcurement) product family, and specifically supports the cost and margin analysis functionality surfaced through Oracle iProcurement's Margin Analysis pages. The view consolidates invoiced revenue and margin amounts attributable to each sales representative, then derives percentage-based performance indicators against both the representative's own invoiced amount and the organization-wide totals. In Oracle EBS 12.1.1 and 12.2.2, this view acts as a denormalized read layer over the margin analysis and sales representative base tables, allowing the iProcurement user interface and related reports to retrieve pre-aggregated margin metrics without executing complex joins and arithmetic at query time.

Underlying Base Objects

The view is defined over three documented base objects. ICX_MARGIN_ANALYSIS (aliased MA) supplies the transactional margin analysis facts, including the sales representative identifier, period indicator, invoiced amount, margin, build identifier, and operating unit identifier. CST_MARGIN_BUILD (aliased MB) is joined on BUILD_ID and represents the margin build context under which the analysis rows were generated. RA_SALESREPS (aliased RSA) is joined on SALESREP_ID to resolve the sales representative's display name. The view also invokes the packaged function ICX_MARGIN_WEB_ANA_PKG.ICX_GET_TOTAL_SALES('30D') and ICX_MARGIN_WEB_ANA_PKG.ICX_GET_TOTAL_MARGIN('30D') to obtain organization-level totals used as the denominator for percentage calculations. Multi-org security is enforced through a USERENV('CLIENT_INFO') decode that matches the row's ORG_ID, defaulting to -99 where no operating unit context is established.

Key Columns

• PRIMARY_SALESREP_ID — The sales representative identifier from ICX_MARGIN_ANALYSIS.
• PERIOD — Period indicator; the view is restricted by HAVING PERIOD='30D'.
• SALESREP_NAME — Representative name resolved from RA_SALESREPS.NAME.
• SALES — Sum of INVOICED_AMOUNT for the representative over the period.
• MARGIN — Sum of MARGIN for the representative over the period.
• CUSTOMER_MARGIN_PCT — Margin divided by invoiced amount, expressed as a percentage rounded to two decimals; returns NULL when invoiced amount is zero.
• TOTAL_SALES_PCT — The representative's invoiced amount as a percentage of total 30-day sales across the organization; this is the column most closely associated with the "sales_pct" search term.
• TOTAL_MARGIN_PCT — The representative's margin as a percentage of total 30-day margin.
• TO_DATE / FROM_DATE — The window boundary, with FROM_DATE computed as TO_DATE minus 30 days.

Common Use Cases and Queries

Typical usage includes sales performance dashboards, margin contribution ranking, and rep-level comparison against organizational totals. A representative query returning the top contributors by sales share is:

• SELECT salesrep_name, sales, margin, customer_margin_pct, total_sales_pct, total_margin_pct FROM apps.icx_cst_sales_rep_30day_v ORDER BY total_sales_pct DESC;
• SELECT salesrep_name, total_sales_pct FROM apps.icx_cst_sales_rep_30day_v WHERE customer_margin_pct < 15;
• SELECT SUM(sales), SUM(margin) FROM apps.icx_cst_sales_rep_30day_v;

Because the view enforces operating unit context through USERENV and restricts rows to PERIOD='30D', queries execute within the caller's iProcurement or EBS responsibility context, and results reflect the active organization. Users searching for "sales_pct" should note that the exposed column is named TOTAL_SALES_PCT, computed via ICX_MARGIN_WEB_ANA_PKG.ICX_GET_TOTAL_SALES('30D') and rounded to two decimal places.