Search Results std_qty




Overview
Explore in AI Chat

Overview

FM_FORM_EFF_VW1 is a database view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the GMD (Process Manufacturing Product Development) application. It is documented as the "Item Effectivity View" and functions as a filtered presentation layer over the item effectivity data used by Oracle Process Manufacturing. In EBS 12.1.1 and 12.2.2, the view exposes a curated subset of the columns and rows held in its underlying base object, allowing reports, concurrent programs, and integration interfaces to retrieve active formula effectivity records without having to re-implement the filtering logic themselves.

The view carries a VALID status in the data dictionary, indicating that it compiles cleanly against its referenced base object. Because it is a view rather than a table, it stores no data of its own; all values are resolved at query time from the synonym referenced in its definition. This makes it a low-risk, read-only access point for developers and analysts who require formula effectivity information in a stable, pre-filtered form.

Underlying Base Objects

The view is defined over a single referenced base object: FM_FORM_EFF, referenced through a synonym in the APPS schema. The view text is a straightforward projection and restriction of that table:

The FORMULA_USE = 2 predicate restricts the result set to a specific formula usage classification, while DELETE_MARK = 0 excludes rows that have been logically deleted. Together these filters ensure the view returns only current, meaningful effectivity records. Because it references a synonym rather than fully qualifying the table, the view depends on the APPS synonym resolution remaining intact after patching or cloning operations.

Key Columns

  • FMEFF_ID — The primary identifier for the formula effectivity record; useful as a join key and for auditing individual rows.
  • FORMULA_ID — Identifies the formula to which the effectivity record belongs, linking effectivity back to the formula definition.
  • ITEM_ID — The inventory item associated with the effectivity record, resolved against the item master.
  • ORGN_CODE — The organization code, enabling multi-organization filtering in process manufacturing environments.
  • STD_QTY — The standard quantity for the effectivity record. This is the column most commonly targeted by searches, since it drives quantity-based effectivity and yield calculations.
  • ITEM_UM — The unit of measure for the item quantity, essential for interpreting STD_QTY correctly.
  • END_DATE — The date on which the effectivity record ceases to be valid, supporting time-phased queries.

Common Use Cases and Queries

Typical uses include reporting on active formula effectivity by organization, validating standard quantities before integration loads, and joining effectivity data to formula and item master tables. A representative query is:

  • SELECT FMEFF_ID, FORMULA_ID, ITEM_ID, ORGN_CODE, STD_QTY, ITEM_UM, END_DATE FROM APPS.FM_FORM_EFF_VW1 WHERE ORGN_CODE = :orgn AND END_DATE > SYSDATE; — retrieves currently valid effectivity rows for a given organization.
  • SELECT FORMULA_ID, SUM(STD_QTY) FROM APPS.FM_FORM_EFF_VW1 GROUP BY FORMULA_ID; — aggregates standard quantities per formula.
  • SELECT * FROM APPS.FM_FORM_EFF_VW1 WHERE ITEM_ID = :item_id ORDER BY END_DATE DESC; — lists effectivity history for a specific item.

Because STD_QTY and ITEM_UM must be interpreted together, queries that report quantities should always include the unit of measure to avoid ambiguous results.