Results for “ic_loct_inv_unalloc”

18 results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

APPS.IC_LOCT_INV_UNALLOC is a database view in the Oracle E-Business Suite Process Manufacturing (GMI) module, specifically within the Process Manufacturing Inventory product area. It is documented in the ETRM reference for both Oracle EBS 12.1.1 and 12.2.2 with a status of VALID, owned by the APPS schema. The official metadata description states "Not currently used," which indicates that no seeded Oracle forms, concurrent programs, or standard application flows depend on this view directly. Nonetheless, the view remains deployed and queryable, and it is frequently encountered by technical consultants and report developers searching for lot-status attributes such as ORDER_PROC_IND.

Functionally, the view presents a consolidated, denormalized view of on-hand lot inventory that has not been allocated, combined with the master attributes of each lot and the status flags governing its usability. By joining inventory, lot master, and lot status data, it allows a single query to return quantities on hand alongside the disposition indicators (product, order processing, shipping, and nettable) that control how the lot may be transacted. This makes it a convenient reporting vehicle even though it is not wired into standard application logic.

Underlying Base Objects

The view is defined over three referenced base objects, all exposed through APPS synonyms:

  • IC_LOCT_INV — the location-level on-hand inventory table, supplying item, warehouse, location, lot, lot status, and on-hand quantity.
  • IC_LOTS_MST — the lot master table, supplying the lot number, sublot number, expiry date, and inactive flag.
  • IC_LOTS_STS — the lot status table, supplying the disposition indicators associated with each lot status code.

The joins are driven from IC_LOTS_MST and IC_LOTS_STS into IC_LOCT_INV: inventory rows are matched to lot master rows on ITEM_ID and LOT_ID, and to lot status rows on LOT_STATUS. Only lots with INACTIVE_IND = 0 in the master, statuses with REJECTED_IND = 0, positive on-hand quantities (LOCT_ONHAND > 0), and a non-zero LOT_ID are returned.

Key Columns

  • ITEM_ID — inventory item identifier for the on-hand lot.
  • WHSE_CODE and LOCATION — warehouse and storage location holding the quantity.
  • LOCT_ONHAND — the quantity on hand at that location/lot combination.
  • LOT_STATUS — the status code applied to the lot, joining to IC_LOTS_STS.
  • LOT_ID, LOT_NO, SUBLOT_NO, EXPIRE_DATE — lot identity and expiry attributes from the master.
  • PROD_IND — indicates whether the lot status permits it to be used in production.
  • ORDER_PROC_IND — indicates whether the lot status permits the lot to be processed against orders (the flag users commonly search for).
  • SHIPPING_IND — indicates whether the lot status permits shipping.
  • NETTABLE_IND — indicates whether the lot is nettable for planning purposes.

Common Use Cases and Queries

The most common use is a report or diagnostic query listing all unallocated on-hand lots along with their disposition flags, to confirm which lots are order-processable, shippable, or nettable. A representative query follows:

SELECT item_id, whse_code, location, loct_onhand, lot_no, sublot_no, expire_date, prod_ind, order_proc_ind, shipping_ind, nettable_ind
FROM apps.ic_loct_inv_unalloc
WHERE order_proc_ind = 1
ORDER BY whse_code, item_id, lot_no;

Because the view filters to positive on-hand and non-rejected statuses, it is well suited to availability checks and to validating that a lot's status allows order processing before allocation. Report developers may also join it to item and warehouse master tables for descriptive output. Given the "Not currently used" designation, it is advisable to treat the view as read-only reference data and, where supported, consider equivalent direct queries against IC_LOCT_INV, IC_LOTS_MST, and IC_LOTS_STS for future-proofing.