Search Results customer_bill_address

Overview

APPS.MRPFV_FORECASTS is a Business Intelligence System view in Oracle E-Business Suite, registered under the FND Design Data reference MRP.MRPFV_FORECASTS and owned by the APPS schema. Its status is VALID in both release 12.1.1 and 12.2.2. The view presents an estimate of future demand on inventory items. Each forecast record contains information on the original and current forecast quantities (before and after consumption), the confidence factor, and any specific customer information associated with the demand.

Because the view is exposed as a Business Intelligence System view, it is intended primarily for reporting, analytics, and integration scenarios rather than for transactional data entry. It flattens master and transactional forecasting data — organization, forecast set, demand class, and customer context — into a single denormalized representation suitable for ad hoc queries, custom reports, and downstream extracts. The view is read-only with respect to the underlying tables and is not referenced by any other database object, so its use does not introduce cascading dependency concerns.

Underlying Base Objects

APPS.MRPFV_FORECASTS is defined over a set of synonyms resolving to base tables spanning inventory and customer master data:

• MRP_FORECAST_DESIGNATORS — the core forecasting table supplying forecast names, descriptions, sets, quantities, and demand class information.
• HR_ALL_ORGANIZATION_UNITS and MTL_PARAMETERS — provide the organization code and organization name context for the inventory organization in which the forecast exists.
• HZ_CUST_ACCOUNTS, HZ_PARTIES — supply customer name and customer number.
• HZ_CUST_ACCT_SITES_ALL, HZ_CUST_SITE_USES_ALL, HZ_PARTY_SITES, HZ_LOCATIONS — supply the customer ship-to and bill-to address information used to populate the address columns.

These objects are joined to present forecast demand enriched with organizational and customer descriptive attributes.

Key Columns

• ORGANIZATION_CODE / ORGANIZATION_NAME / ORGANIZATION_ID — the inventory organization associated with the forecast.
• FORECAST_NAME / FORECAST_DESCRIPTION / FORECAST_SET_NAME — identify the forecast and the forecast set to which it belongs.
• INACTIVE_DATE — the date on which the forecast or forecast set becomes inactive.
• DEMAND_CLASS — a user-defined classification used to segment demand.
• CUSTOMER_NAME / CUSTOMER_NUMBER / CUSTOMER_ID — identifying attributes of the customer associated with the forecast demand.
• CUSTOMER_SHIP_ADDRESS / CUSTOMER_SHIP_ID — the ship-to address text and identifier.
• CUSTOMER_BILL_ADDRESS / CUSTOMER_BILL_ID — the bill-to address text and identifier. The CUSTOMER_BILL_ADDRESS column is the attribute most relevant to the searched term "customer_bill_address".
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY — standard audit columns.
• _DF — a descriptive flexfield indicator column.

Common Use Cases and Queries

Typical scenarios include reporting forecasted demand by customer and bill-to address, auditing forecasts by demand class, and extracting demand data for planning or integration. For example, to retrieve forecast demand with customer bill addresses:

• SELECT FORECAST_NAME, CUSTOMER_NAME, CUSTOMER_BILL_ADDRESS, DEMAND_CLASS FROM APPS.MRPFV_FORECASTS WHERE CUSTOMER_BILL_ADDRESS IS NOT NULL;
• SELECT ORGANIZATION_CODE, FORECAST_SET_NAME, DEMAND_CLASS, CUSTOMER_NUMBER FROM APPS.MRPFV_FORECASTS WHERE INACTIVE_DATE > SYSDATE;
• SELECT CUSTOMER_NAME, CUSTOMER_BILL_ID, CUSTOMER_BILL_ADDRESS FROM APPS.MRPFV_FORECASTS WHERE CUSTOMER_ID = :customer_id;

These queries support customer-level demand analysis, address validation, and inactive-forecast exclusion during planning cycles.