Search Results bill_address




Overview
Explore in AI Chat

Overview

ICX_MRP_FORECAST_ITEMS_V is a reporting view in the Oracle iProcurement (ICX) module of Oracle E-Business Suite, exposed as the "Forecast Items View." Its purpose is to present forecast item information sourced from Oracle Advanced Supply Chain Planning / MRP forecast tables, enriched with customer, address, and item master descriptive data, so that iProcurement and related planning or sourcing functions can display forecast demands at the item and organization level without directly joining the underlying transactional tables.

The view is not a standalone transactional entity; it is a denormalized read-only projection that consolidates forecast designators, forecast items, customer identities, bill-to and ship-to addresses, and item master attributes into a single queryable structure. In the ETRM documentation for release 12.2.2, the object is listed with no owner recorded in the database and no referenced base objects explicitly documented, which is consistent with an object that may not be implemented in every environment. The view text itself, however, clearly enumerates its dependencies.

Underlying Base Objects

The view is defined over a set of forecast, customer, address, item, and lookup tables. The principal forecast objects are MRP_FORECAST_ITEMS (MFI) and MRP_FORECAST_DESIGNATORS (MFD), which provide the forecast item rows and the forecast designator context respectively. Customer information is drawn from RA_CUSTOMERS_VIEW (CUST). Address and site-use data come from RA_ADDRESSES_ALL for both bill-to and ship-to addresses, joined through RA_SITE_USES_ALL using the site use codes 'BILL_TO' and 'SHIP_TO'. Item master attributes are supplied by MTL_SYSTEM_ITEMS and MTL_ITEM_FLEXFIELDS (KFV), while BOM_ITEM_TYPE meanings are resolved through MFG_LOOKUPS. All address, customer, and lookup joins are outer joins, permitting forecast rows to be returned even where customer or address data is absent.

Key Columns

Common Use Cases and Queries

The view is typically used to display forecast demand by customer and shipping location for iProcurement requisitioning or planning review. A representative query filters by organization and forecast designator:

SELECT item_number, description, customer_name, ship_address, primary_uom_code
FROM icx_mrp_forecast_items_v
WHERE organization_id = :org_id
AND forecast_designator = :designator;
ORDER BY item_number;

Because the joins to RA_SITE_USES_ALL and RA_ADDRESSES_ALL are outer joins, queries that include forecast rows without a defined ship-to or bill-to site return null address values rather than dropping rows. When troubleshooting the RA_SITE_USES_ALL dependency, note that BILLSU and SHIPSU are the only intervening objects joining address identifiers to site-use identifiers, and both are constrained to the 'BILL_TO' and 'SHIP_TO' site use codes.