Results for “bill_of_distribution_id”

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

Overview

The MRPFV_BILL_OF_DISTRIBUTIONS view is a read-only, foundation-level database object in the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 environments, owned by the APPS schema and belonging to the MRP (Master Scheduling/MRP) product family. It exposes a filtered list of sourcing rules that are specifically classified as bills of distribution — sourcing rules that describe how inventory is replenished from upstream supply points rather than from suppliers. In Oracle Advanced Supply Chain Planning and the broader MRP planning engine, bills of distribution are the mechanism used to propagate demand across a supply chain network and to define the replenishment hierarchy between organizations and warehouses.

The view is not a base table; it is a query layer built to present bill-of-distribution records in a form appropriate for forms-based UIs and for integrations. The naming convention MRPFV indicates an MRP "Form View," and the leading _DF-derived column and the injected "_DF:MRP:MRP_SOURCING_RULES:BD" descriptor confirm that it serves as a lov (list of values) / descriptive flexfield-aware display source. The view carries a WITH READ ONLY clause, so it cannot be used for DML; it exists purely for querying, lookups, and reporting.

Underlying Base Objects

The ETRM metadata documents the view as defined over two referenced objects:

• MRP_SOURCING_RULES (referenced via a SYNONYM) — the base table holding all sourcing rule definitions, including those whose SR sourcing rule type equals 2 (bill of distribution).
• MFG_LOOKUPS (referenced as a VIEW) — the manufacturing lookups view, used to translate the PLANNING_ACTIVE code into its meaning within the SYS_YES_NO lookup type.

The join between BD (aliased MRP_SOURCING_RULES) and LO (aliased MFG_LOOKUPS) is performed on LO.LOOKUP_CODE = BD.PLANNING_ACTIVE with the filter LO.LOOKUP_TYPE = 'SYS_YES_NO'. The view restricts rows to BD.SOURCING_RULE_TYPE = 2, which is the discriminating value that designates a sourcing rule as a bill of distribution. In practice, the same base table MRP_SOURCING_RULES also stores sourcing rules of other types (such as sourcing rules for suppliers), so the type filter is what isolates bills of distribution from the parent table.

Key Columns

• BILL_OF_DISTRIBUTION — the sourcing rule name, exposed from BD.SOURCING_RULE_NAME; the human-readable identifier.
• DESCRIPTION — BD.DESCRIPTION, free-text description of the bill of distribution.
• PLANNING_ACTIVE_FLAG — derived from LO.MEANING, the decoded value of the planning-active indicator (Yes/No).
• BILL_OF_DISTRIBUTION_ID — BD.SOURCING_RULE_ID, the surrogate primary key and the value most often used in foreign-key lookups by other modules and interfaces.
• LAST_UPDATE_DATE / LAST_UPDATED_BY / CREATION_DATE / CREATED_BY — standard EBS audit columns, useful for change tracking and data lineage.
• "_DF" — a descriptive flexfield placeholder column injected by the forms architecture.

Common Use Cases and Queries

Because the view is optimized for lookups and reporting, typical usage involves retrieving the bill-of-distribution identifier when a user selects a name, or verifying that a given sourcing rule is planning-active.

• List active bills of distribution: SELECT bill_of_distribution_id, bill_of_distribution, description FROM apps.mrpfv_bill_of_distributions WHERE planning_active_flag = 'Yes';
• Resolve an ID to a name: SELECT bill_of_distribution FROM apps.mrpfv_bill_of_distributions WHERE bill_of_distribution_id = :p_id;
• Integration extracts: the audit columns support incremental ETL pulls into planning or data-warehouse systems.
• Lov validation: populate a form list of values driven by the descriptive flexfield-aware display.

All access is restricted to valid, committed data, and no insert, update, or delete operations are possible against the view.