Search Results shelf_life_code




Overview
Explore in AI Chat

Overview

APPS.INL_ENTER_RECEIPTS_V is a denormalized reporting and integration view in Oracle E-Business Suite that consolidates the data elements required by the Receiving open interface and the Enter Receipts user interface. It joins purchasing, receiving, inventory, supplier, and currency reference data into a single row-level presentation of receipt lines awaiting entry, inspection, or delivery. The view belongs to the Oracle Inventory (INL) module family and is commonly referenced by custom forms, concurrent programs, and third-party integrations that need to populate the Receiving Transaction Interface (RTI) or replicate the standard Enter Receipts form's query block.

The presence of SHELF_LIFE_CODE, SHELF_LIFE_DAYS, LOT_CONTROL_CODE, and SERIAL_NUMBER_CONTROL_CODE among the projected columns confirms that the view is designed to supply inventory attribute information at the receipt line level, ensuring that lot and shelf life controls are enforced when receipts are created. The user's search term "shelf_life_code" maps directly to this column.

Underlying Base Objects

Per documented ETRM metadata for 12.2.2, the view is defined over the following base objects:

These joins make the view a superset of the requisition, purchase order, and receipt tables, with synonyms used to reference the APPS-owned base objects.

Key Columns

Common Use Cases and Queries

Typical usage includes populating Receiving interface staging tables, driving custom receipt entry forms, validating item receipt controls, and extracting open receipt lines for reporting.

  • Query receipt lines for a specific PO with shelf life and lot controls:
SELECT po_number, po_line_number, item_number, shelf_life_code,
       shelf_life_days, lot_control_code, ordered_qty, primary_uom
FROM   apps.inl_enter_receipts_v
WHERE  org_id = :p_org_id
AND    po_number = :p_po_number;
  • Identify items requiring lot/shelf life capture at receipt:
SELECT item_number, shelf_life_code, shelf_life_days, lot_control_code
FROM   apps.inl_enter_receipts_v
WHERE  shelf_life_code IS NOT NULL
AND    org_id = :p_org_id;

Because the view aggregates purchasing, inventory, and receiving attributes, it is well suited for integration layers that must present receipt-ready data without repeatedly navigating the underlying normalized tables.