Search Results date_code




Overview
Explore in AI Chat

Overview

MTL_LOT_NUMBERS_VAL_V is an Oracle E-Business Suite view owned by the APPS schema within the Inventory (INV) product module. It is documented in ETRM as a validation view restricted to a specific deployment context, described simply as "10SC ONLY." Despite its narrow scope, the view exposes the full column set of the MTL_LOT_NUMBERS table, making it a convenient read interface for lot-controlled inventory data in EBS 12.1.1 and 12.2.2 environments where it has been deployed.

In Oracle EBS, lot numbers identify discrete quantities of an item tracked through receiving, storage, and issue transactions. Validation views such as MTL_LOT_NUMBERS_VAL_V are typically consumed by forms, concurrent programs, or integration layers that need to present or verify lot numbers without accessing the base table directly. Because the view is defined over a synonym referencing MTL_LOT_NUMBERS and filters on a specific flag value, it presents a curated subset of lot records rather than the entire lot population.

Underlying Base Objects

The documented base object referenced by MTL_LOT_NUMBERS_VAL_V is the MTL_LOT_NUMBERS synonym. MTL_LOT_NUMBERS is the core INV table storing lot master records, keyed by INVENTORY_ITEM_ID, ORGANIZATION_ID, and LOT_NUMBER. The view text selects every significant column from that table, including the descriptive attributes, grade and status fields, and the extensible attribute sets (C_ATTRIBUTE1 through C_ATTRIBUTE20, D_ATTRIBUTE1 through D_ATTRIBUTE10, N_ATTRIBUTE1 through N_ATTRIBUTE10).

Crucially, the view applies the predicate WHERE DISABLE_FLAG = 2. In the context of the INV lot schema, this filter restricts the result set to a specific disable-flag state, isolating the records intended for the "10SC" implementation. Any consumer of this view therefore sees only lots matching that flag value, not all lots defined for an item or organization.

Key Columns

Common Use Cases and Queries

Typical uses include validating lot numbers against a known date code, retrieving expiration data for shelf-life reporting, and integrating supplier lot information with external systems. The following query retrieves lots for a specific item and organization, returning the date code and related attributes:

  • SELECT LOT_NUMBER, DATE_CODE, EXPIRATION_DATE, SUPPLIER_LOT_NUMBER FROM APPS.MTL_LOT_NUMBERS_VAL_V WHERE INVENTORY_ITEM_ID = :item AND ORGANIZATION_ID = :org;
  • SELECT LOT_NUMBER, DATE_CODE, GRADE_CODE, STATUS_ID FROM APPS.MTL_LOT_NUMBERS_VAL_V WHERE DATE_CODE = :date_code;
  • SELECT LOT_NUMBER, BEST_BY_DATE, RETEST_DATE FROM APPS.MTL_LOT_NUMBERS_VAL_V WHERE EXPIRATION_DATE BETWEEN :start AND :end;

Because the view is restricted to DISABLE_FLAG = 2, users should verify that this subset meets their reporting needs; broader lot queries may require the base MTL_LOT_NUMBERS table or other lot views.