Results for “rework_type”

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

Overview

PMIBV_PRODUCTFORMULA_INV_V is a read-only reporting view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the Process Manufacturing Intelligence (PMI) product family. Its documented purpose is to present formula detail together with the on-hand quantity of the ingredients that make up each formula. The view joins the formula master record to both the ingredient material detail lines and the product material detail lines, producing a single denormalized row for every valid ingredient-to-product relationship within an active formula.

Because the view is defined WITH READ ONLY, it functions strictly as a query surface for reporting, business intelligence extracts, and integration consumers. It exposes descriptive formula attributes such as FORMULA_DESC1 and FORMULA_DESC2 alongside the resolved foreign keys needed to link formula lines to inventory items, which makes it suitable for ad hoc analysis in Discoverer, OBIEE, or custom concurrent programs. The users searching for "formula_desc2" typically require the second descriptive line of a formula header, which this view surfaces directly from FM_FORM_MST.

Underlying Base Objects

The view is defined over two documented base objects, both referenced through APPS synonyms:

• FM_FORM_MST — aliased FMASTER in the view text; supplies the formula header attributes including formula number, version, type, class, and descriptive fields.
• FM_MATL_DTL — used twice. It is aliased FDETAIL to retrieve the ingredient lines and aliased PRODUCTDETAIL to retrieve the product line, joined through FORMULA_ID.

The join predicates restrict FMASTER.FORMULA_ID to both FDETAIL.FORMULA_ID and PRODUCTDETAIL.FORMULA_ID. Only rows where FDETAIL.LINE_TYPE equals -1 (ingredient lines) and PRODUCTDETAIL.LINE_TYPE equals 1 (product lines) are returned, so each output row pairs one ingredient with the corresponding product. Records flagged with FMASTER.INACTIVE_IND = 0 and FMASTER.DELETE_MARK = 0 are included, excluding inactivated or logically deleted formulas.

Key Columns

The view exposes a mix of formula header, product, and ingredient attributes. Notable columns include:

• FORMULA_NO, FORMULA_VERS, FORMULA_TYPE, SCALE_TYPE — core formula identification and scaling characteristics.
• FORMULA_DESC1, FORMULA_DESC2 — the two descriptive text fields on the formula header; FORMULA_DESC2 is the specific attribute frequently sought in searches.
• FORMULA_CLASS, FMCONTROL_CLASS — formula and formula control classification values.
• FORMULA_ID, PRODUCT_ITEM_ID, INGREDIENT_ITEM_ID — resolved keys linking to the formula and to the inventory items involved.
• INGREDIENT_FORMULALINE_ID, INGREDIENT_LINE_NO, INGREDIENT_QTY, INGREDIENT_ITEM_UOM — the ingredient line identity, sequence, quantity, and unit of measure.
• INGREDIENT_RELEASE_TYPE, INGREDIENT_SCRAP_FACTOR, INGREDIENT_SCALE_TYPE, COST_ALLOCATION, PHANTOM_TYPE, REWORK_TYPE — ingredient-level processing and cost attributes.
• PRODUCT_QTY, PRODUCT_UOM — the quantity and unit of measure for the product line.

Common Use Cases and Queries

Typical applications include formula ingredient reporting, on-hand versus formula quantity reconciliation, and integration extracts feeding planning or costing systems. The following query retrieves formulas by their second description and lists ingredient detail:

• SELECT formula_no, formula_vers, formula_desc2, ingredient_item_id, ingredient_qty, product_item_id, product_qty FROM apps.pmibv_productformula_inv_v WHERE formula_desc2 LIKE '%BASE%';
• SELECT formula_no, formula_desc1, formula_desc2, ingredient_line_no FROM apps.pmibv_productformula_inv_v WHERE formula_id = :p_formula_id ORDER BY ingredient_line_no;

Because the view is read-only and joins two distinct line types, consumers should treat each row as one ingredient-product pairing and aggregate accordingly when reconciling formula-level totals.