Search Results icx_cst_margin_build_v

Overview

The view APPS.ICX_CST_MARGIN_BUILD_V is an Oracle Application Object Library database object owned by the APPS schema in Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It is catalogued under the ICX product family, which corresponds to Oracle iProcurement, and is registered with VALID status. Despite the iProcurement association, the object carries the ETRM description "Obsolete," indicating that Oracle no longer positions this view as an active integration or reporting component within the current release. Its presence is retained largely for backward compatibility with dependent code, customizations, or historical report definitions that may still reference it.

Functionally, the view exposes a single, most-recent record from the Cost Margin Build data set. It selects the row from CST_MARGIN_BUILD having the maximum BUILD_ID, effectively surfacing the current or latest margin build header. This behavior makes the view useful wherever a consumer needs to identify the active build without performing the aggregation logic themselves.

Underlying Base Objects

The view is defined over a single base table, CST_MARGIN_BUILD, which stores header information for cost margin builds. The definition uses a correlated subquery in the WHERE clause:

• FROM CST_MARGIN_BUILD — the sole source table for all selected columns.
• WHERE BUILD_ID = (SELECT MAX(BUILD_ID) FROM CST_MARGIN_BUILD) — restricts output to the row with the highest build identifier.

No other documented base objects are referenced; the view does not perform joins to organization, item, or cost detail tables. Because the subquery returns the maximum BUILD_ID across the entire table without an ORG_ID predicate, the view returns at most one row globally, not one row per operating unit. Consumers expecting per-organization results should apply additional filtering or query CST_MARGIN_BUILD directly.

Key Columns

The view projects the following columns from CST_MARGIN_BUILD:

• BUILD_ID — unique identifier of the margin build; the driving column for the maximum-value restriction.
• BUILD_NAME — descriptive name assigned to the build.
• BUILD_DESCRIPTION — free-text description of the build's purpose or scope.
• FROM_DATE, TO_DATE — effective date range associated with the build.
• ORG_ID — operating unit / organization identifier.
• HEADER_ID — reference to the associated header record.
• CREATION_DATE, CREATED_BY — standard EBS audit columns recording creation timestamp and creating user.

These columns mirror the base table without transformation, aliasing, or decoding, so values are presented exactly as stored, including any WHO-column audit semantics.

Common Use Cases and Queries

Typical usage centers on retrieving the latest margin build header, either for validation, reporting, or as a lookup within custom SQL. A representative query is:

• SELECT BUILD_ID, BUILD_NAME, FROM_DATE, TO_DATE, ORG_ID FROM APPS.ICX_CST_MARGIN_BUILD_V;
• SELECT BUILD_ID, BUILD_NAME FROM APPS.ICX_CST_MARGIN_BUILD_V WHERE ORG_ID = :p_org_id; — note that because the subquery is not organization-scoped, this predicate may return no rows if the globally latest build belongs to another organization.
• SELECT COUNT(*) FROM APPS.ICX_CST_MARGIN_BUILD_V; — useful to confirm the single-row cardinality.

Because the object is documented as obsolete and exposes only one row, it should not be treated as a replacement for querying CST_MARGIN_BUILD directly when full historical or multi-organization data is required. Any dependency on this view in custom code should be reviewed prior to upgrade or patching, given its deprecated status.