Search Results gmd_test_methods_vl

Overview

GMD_TEST_METHODS_VL is a documented Oracle EBS view owned by the APPS schema and categorized under the GMD product family (Process Manufacturing Product Development). It is described in the ETRM metadata as "OPM QC Test Methods." In Oracle Process Manufacturing, a test method defines the analytical procedure and quality-control parameters used to evaluate the attributes of a material, lot, or process sample — for example titration, assay, moisture, or pH determination. The view presents the translatable, user-facing representation of these test methods, resolving language-dependent descriptions and joining them to their base technical definitions.

The suffix "_VL" denotes a "view with translation" pattern that is common across Oracle EBS. Such views typically join a base (or "_B") table, which holds language-independent attributes, with a translation (or "_TL") table, which stores language-specific descriptive text. Because the view filters the translation table by the session's language, it returns one row per test method in the current user's language, making it the appropriate source for forms, reports, and integrations that must display human-readable test method names. Its status is documented as VALID, confirming it is a supported, compiled database object in the ETRM 12.2.2 environment.

Underlying Base Objects

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

• GMD_TEST_METHODS_B — the base table holding the core, language-independent definition of each QC test method, including its identifier, code, numeric parameters, and descriptive flexfield columns.
• GMD_TEST_METHODS_TL — the translation table holding the language-specific description, keyed by TEST_METHOD_ID and LANGUAGE.

The view statement joins these on the condition B.TEST_METHOD_ID = T.TEST_METHOD_ID and restricts the translation rows with T.LANGUAGE = USERENV('LANG'). This ensures only the row matching the current EBS session language is returned. The view also selects B.ROWID as ROW_ID, which allows tools and forms to reference the underlying base row uniquely. The join is written so that every qualifying base record is paired with its session-language description.

Key Columns

Because the view merges the base and translation tables, it exposes the following principal columns:

• ROW_ID — the physical ROWID of the base table row, useful for row-level operations.
• TEST_METHOD_ID — the unique surrogate key of the test method.
• TEST_METHOD_CODE — the language-independent code assigned to the test method.
• TEST_METHOD_DESC — the translatable description, returned in the current session language.
• TEST_QTY, TEST_QTY_UOM — the default sample/test quantity and its unit of measure.
• DISPLAY_PRECISION — the numeric rounding precision used when presenting results.
• TEST_DURATION, DAYS, HOURS, MINUTES, SECONDS — the expected duration of the test, expressed both as a total and as broken-down time components.
• TEST_REPLICATE, RESOURCES — the number of replicates and required resources.
• TEST_KIT_ORGANIZATION_ID, TEST_KIT_INV_ITEM_ID — the inventory organization and inventory item used as the test kit.
• DELETE_MARK — the soft-delete indicator.
• TEXT_CODE, ATTRIBUTE_CATEGORY, ATTRIBUTE1–ATTRIBUTE30 — descriptive flexfield and standard descriptive columns.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard audit columns.

Common Use Cases and Queries

This view is commonly consumed by OPM Quality Management reports, custom inquiries, and external integrations that need a language-aware list of QC test methods. A typical query retrieves active test methods with their descriptions and default quantities, as shown below.

• Listing active test methods:

  SELECT TEST_METHOD_ID, TEST_METHOD_CODE, TEST_METHOD_DESC
  FROM   GMD_TEST_METHODS_VL
  WHERE  DELETE_MARK = 0
  ORDER BY TEST_METHOD_CODE;

• Retrieving timing and quantity details for a specific method:

  SELECT TEST_METHOD_CODE, TEST_METHOD_DESC,
         TEST_QTY, TEST_QTY_UOM,
         TEST_DURATION, DAYS, HOURS, MINUTES, SECONDS
  FROM   GMD_TEST_METHODS_VL
  WHERE  TEST_METHOD_CODE = :p_code;

• Joining to sample or specification tables by TEST_METHOD_ID to relate QC results to their governing methods.
• Integration feeds that export test method master data to quality systems, using TEST_METHOD_ID as the stable key and TEST_METHOD_DESC for display.

Because the description is resolved by USERENV('LANG'), the view always returns the description appropriate to the connected user's session, eliminating the need for callers to handle the _B and _TL tables separately.