Search Results vendor_lot_num

Overview

GML_LN_RCV_ERV is a read-only view owned by the APPS schema in Oracle E-Business Suite, defined within the Process Manufacturing Logistics (GML) product family. Its documented purpose is to expose line-level information for a receipt in support of ERES (Electronic Records and Electronic Signatures) processing. The view is registered as VALID in both Oracle EBS 12.1.1 and 12.2.2 and is typically consumed by reporting and integration components that need a denormalized, human-readable representation of pending receipt lines before they are validated and posted by the receiving transaction processor.

Because the view is anchored on RCV_TRANSACTIONS_INTERFACE, it presents data at the receiving interface stage rather than at the posted transaction level. This distinction is important for ERES workflows, where lot-controlled inventory receipts must be captured with vendor lot attribution prior to final commit. The view joins interface rows to shipment headers, item master attributes, vendor records, locators, and organization definitions to produce a single flat result set suitable for downstream interfaces, label printing, and audit reporting. The search term vendor_lot_num maps directly to the VENDOR_LOT_NUM column, which is the primary attribute used to trace supplier-assigned lot or batch numbers through the receipt interface.

Underlying Base Objects

The view text identifies eight referenced objects, all accessed through APPS synonyms except PO_VENDORS, which is itself a view. The driving table is RCV_TRANSACTIONS_INTERFACE (aliased R), keyed by INTERFACE_TRANSACTION_ID. An inner join to RCV_SHIPMENT_HEADERS (SH) supplies the receipt number, while outer joins to PO_VENDORS (PV) and MTL_ITEM_LOCATIONS (MIL) provide vendor name/number and locator description respectively. MTL_SYSTEM_ITEMS (MSI) and HR_ALL_ORGANIZATION_UNITS (H) are joined internally on organization identifiers, and MTL_PARAMETERS (MP) supplies the organization code. A correlated EXISTS clause on GML_LOT_ERES_TEMP restricts output to interface transactions that have a matching ERES temporary lot record, ensuring only lot-relevant lines are returned. The filter MSI.LOT_CONTROL_CODE = 2 limits the view to lot-controlled items, and DESTINATION_TYPE_CODE = 'INVENTORY' restricts rows to inventory-destined receipts.

Key Columns

• GROUP_ID / INTERFACE_TRANSACTION_ID — Identifiers for the ERES group and the individual receipt interface line.
• RECEIPT_NUM — Receipt number derived from RCV_SHIPMENT_HEADERS; LINE_NUM is returned as NULL in this projection.
• ITEM_NO / ITEM_DESCRIPTION — Item segment and description, with the interface description taking precedence via NVL.
• VENDOR_NAME, VENDOR_ID, VENDOR_NO — Supplier identity attributes from PO_VENDORS.
• SUBINVENTORY, LOCATOR_DESC, LOCATOR_ID — Destination subinventory and locator details.
• QUANTITY, UOM, SECONDARY_QUANTITY, SECONDARY_UOM — Primary and secondary transaction quantities and units of measure.
• ORGANIZATION_CODE, ORGANIZATION_NAME — Receiving organization identifiers from MTL_PARAMETERS and HR_ALL_ORGANIZATION_UNITS.
• VENDOR_LOT_NUM — The supplier-assigned lot or batch number recorded on the interface row; central to ERES lot traceability.

Common Use Cases and Queries

Typical consumers use this view to validate pending lot-controlled receipts before submission, to reconcile vendor lot numbers against internal lot assignments, and to generate ERES audit extracts. A representative query filtered on the searched term follows:

• Locate all pending ERES receipt lines carrying a specific vendor lot: SELECT INTERFACE_TRANSACTION_ID, RECEIPT_NUM, ITEM_NO, VENDOR_NAME, VENDOR_LOT_NUM, QUANTITY, UOM, SUBINVENTORY, ORGANIZATION_CODE FROM APPS.GML_LN_RCV_ERV WHERE VENDOR_LOT_NUM = :p_vendor_lot.
• Summarize pending quantities by item and vendor lot for a receiving organization: SELECT ITEM_NO, VENDOR_LOT_NUM, SUM(QUANTITY) FROM APPS.GML_LN_RCV_ERV WHERE ORGANIZATION_CODE = :p_org GROUP BY ITEM_NO, VENDOR_LOT_NUM.
• Trace receipt-to-lot lineage for audit reporting: SELECT RECEIPT_NUM, VENDOR_NO, VENDOR_LOT_NUM, LOCATOR_DESC, TRANSACTION_DATE FROM APPS.GML_LN_RCV_ERV WHERE INTERFACE_TRANSACTION_ID = :p_itid.

Because the view surfaces only rows with a matching GML_LOT_ERES_TEMP entry and lot-controlled inventory items, queries against it are inherently scoped to ERES lot processing and should not be used as a general-purpose receipt history source.