Search Results mrp_planning_code

Overview

MSD_SR_PRD_PF_V is a source view owned by the APPS schema within the Oracle E-Business Suite Demand Planning module (MSD). Its purpose is to associate the Product level of the Product Dimension with the Product Family level, supplying the Product-to-Product-Family hierarchy relationship that Demand Planning and related supply chain planning flows rely upon. In an Oracle EBS 12.1.1 or 12.2.2 environment, this view acts as an extraction source: the collections and staging processes that populate the Demand Planning analytical store read from it to build the product dimension rollup. The view is documented as VALID and is intended to be applied to an Oracle Applications 11i-derived instance from which the Product-to-Product-Family association information is sourced, remaining present in the 12.x data model for backward compatibility with those collections.

Underlying Base Objects

The view is defined over a join of several documented base objects, most of which are synonyms or views rather than physical tables:

MTL_SYSTEM_ITEMS_KFV — referenced twice, as CHILD and as PARENT, providing the concatenated item segments and the key descriptive flexfield attributes for both the component item and the assembly item.
BOM_BILL_OF_MATERIALS_V (BBOMV) and BOM_INVENTORY_COMPONENTS_V (BICV) — the bills of material header and component views, joined by BILL_SEQUENCE_ID to link assemblies to their components.
MSD_SETUP_PARAMETERS — referenced twice (MORG and MORG2), supplying the MSD_MASTER_ORG and MSD_PLANNING_PERCENTAGE planning parameters that drive the master-organization logic and the percentage-based inclusion rule.
MSD_APP_INSTANCE_ORGS (VORGS) — restricts the organizations considered to those configured for the MSD application instance.
MSD_SR_UTIL — a PL/SQL package supplying GET_NULL_PK, GET_NULL_DESC and IS_ITEM_OPTIONAL_FOR_LVL, used to substitute null placeholders and evaluate optional-item logic.
Supporting references to MTL_SYSTEM_ITEMS_TL and FND_GLOBAL complete the documented dependency set.

Key Columns

The view projects a small, fixed set of columns. The first two expose the child (product) identifier: INVENTORY_ITEM_ID and CONCATENATED_SEGMENTS, taken from the CHILD instance of MTL_SYSTEM_ITEMS_KFV. The third and fourth columns expose the corresponding parent (product family) identifier, again as an item ID and a concatenated segment string, but only when the parent resides in the master organization defined by the MSD_MASTER_ORG parameter; otherwise the MSD_SR_UTIL.GET_NULL_PK and GET_NULL_DESC placeholders are returned, effectively orphaning that product from any family. The remaining five columns are populated with NULL and are reserved as positional placeholders in the source-view contract expected by the collections interface. The absence of a column literally named MRP_PLANNING_CODE is significant: that attribute appears only as an internal filter predicate.

Common Use Cases and Queries

The principal use case is validating and diagnosing the product-to-product-family rollup before or after a Demand Planning collection. Analysts frequently search for "mrp_planning_code" because both CHILD and PARENT rows are filtered with the predicate MRP_PLANNING_CODE <> 6, which excludes items flagged as not planned (planning code 6). Additional filters restrict assemblies to BOM_ITEM_TYPE = 5 (product family) and exclude ATO forecast control 3, so the view returns only planned items participating in a family structure.

A representative diagnostic query is:

SELECT inventory_item_id, concatenated_segments FROM apps.msd_sr_prd_pf_v WHERE concatenated_segments IS NOT NULL; — lists child products that were successfully linked to a product family.
SELECT * FROM apps.msd_sr_prd_pf_v; — inspects the full projection, including the null placeholder columns.

Because the MRP_PLANNING_CODE filter is embedded and cannot be overridden at the view level, users who need to inspect excluded items must query the underlying MTL_SYSTEM_ITEMS_KFV and BOM views directly.

View: MSD_SR_PRD_PF_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:MSD.MSD_SR_PRD_PF_V, object_name:MSD_SR_PRD_PF_V, status:VALID, product: MSD - Demand Planning , description: This is the Source View that associates the Product level to Product Family level in the Product Dimension. This view would be applied to an Oracle Applications 11i instance from which the Product to Product Family level association inform , implementation_dba_data: APPS.MSD_SR_PRD_PF_V ,
View: MSD_BOM_COMPONENTS_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:MSD.MSD_BOM_COMPONENTS_V, object_name:MSD_BOM_COMPONENTS_V, status:VALID, product: MSD - Demand Planning , description: This view provides Planning BOMs and its attributes information for demand planning , implementation_dba_data: APPS.MSD_BOM_COMPONENTS_V ,
View: MSD_BOM_COMPONENTS_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:MSD.MSD_BOM_COMPONENTS_V, object_name:MSD_BOM_COMPONENTS_V, status:VALID, product: MSD - Demand Planning , description: This view provides Planning BOMs and its attributes information for demand planning , implementation_dba_data: APPS.MSD_BOM_COMPONENTS_V ,
View: MSD_SR_PRD_PF_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:MSD.MSD_SR_PRD_PF_V, object_name:MSD_SR_PRD_PF_V, status:VALID, product: MSD - Demand Planning , description: This is the Source View that associates the Product level to Product Family level in the Product Dimension. This view would be applied to an Oracle Applications 11i instance from which the Product to Product Family level association inform , implementation_dba_data: APPS.MSD_SR_PRD_PF_V ,
View: MSD_SR_PRD_CAT_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:MSD.MSD_SR_PRD_CAT_V, object_name:MSD_SR_PRD_CAT_V, status:VALID, product: MSD - Demand Planning , description: This is the Source View that associates the Product level to Product Category level in the Product Dimension. This view would be applied to an Oracle Applications 11i instance from which the Product to Product Category level association i , implementation_dba_data: APPS.MSD_SR_PRD_CAT_V ,
View: MSD_SR_PRD_IT_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:MSD.MSD_SR_PRD_IT_V, object_name:MSD_SR_PRD_IT_V, status:VALID, product: MSD - Demand Planning , description: This is the Source View that associates the Product level to Interest Type level in the Product Dimension. This view would be applied to an Oracle Sales Online Applications 11i instance from which the Product to Interest Type level associa , implementation_dba_data: APPS.MSD_SR_PRD_IT_V ,
View: MSD_SR_PRD_CAT_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:MSD.MSD_SR_PRD_CAT_V, object_name:MSD_SR_PRD_CAT_V, status:VALID, product: MSD - Demand Planning , description: This is the Source View that associates the Product level to Product Category level in the Product Dimension. This view would be applied to an Oracle Applications 11i instance from which the Product to Product Category level association i , implementation_dba_data: APPS.MSD_SR_PRD_CAT_V ,
View: MSD_SR_PRD_IT_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:MSD.MSD_SR_PRD_IT_V, object_name:MSD_SR_PRD_IT_V, status:VALID, product: MSD - Demand Planning , description: This is the Source View that associates the Product level to Interest Type level in the Product Dimension. This view would be applied to an Oracle Sales Online Applications 11i instance from which the Product to Interest Type level associa , implementation_dba_data: APPS.MSD_SR_PRD_IT_V ,