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_CODEandLOCATION— 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 toIC_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.
-
View: IC_LOCT_INV_UNALLOC 12.1.1
Not currently used
APPS.IC_LOCT_INV_UNALLOC·↳ IC_LOCT_INV·↳ IC_LOTS_MST·↳ IC_LOTS_STS·Explore GMI module →
-
View: IC_LOCT_INV_UNALLOC 12.2.2
Not currently used
APPS.IC_LOCT_INV_UNALLOC·↳ IC_LOCT_INV·↳ IC_LOTS_MST·↳ IC_LOTS_STS·Explore GMI module →
-
12.1.1 FND Design Data 12.1.1
-
12.2.2 FND Design Data 12.2.2
-
SYNONYM: APPS.IC_LOTS_STS 12.2.2
-
SYNONYM: APPS.IC_LOTS_STS 12.1.1
-
SYNONYM: APPS.IC_LOCT_INV 12.2.2
-
SYNONYM: APPS.IC_LOCT_INV 12.1.1
-
SYNONYM: APPS.IC_LOTS_MST 12.1.1
-
SYNONYM: APPS.IC_LOTS_MST 12.2.2
-
eTRM - GMI Tables and Views 12.1.1
Table used to relate Item ID with Roles. If the Item ID is NULL, then Roles will be associated with the warehouse Item ID. This table will be used by the Lot Expiry/Retest Workflow.
-
eTRM - GMI Tables and Views 12.2.2
Table used to relate Item ID with Roles. If the Item ID is NULL, then Roles will be associated with the warehouse Item ID. This table will be used by the Lot Expiry/Retest Workflow.
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
eTRM - GMI Tables and Views 12.2.2
Table used to relate Item ID with Roles. If the Item ID is NULL, then Roles will be associated with the warehouse Item ID. This table will be used by the Lot Expiry/Retest Workflow.
-
eTRM - GMI Tables and Views 12.1.1
Table used to relate Item ID with Roles. If the Item ID is NULL, then Roles will be associated with the warehouse Item ID. This table will be used by the Lot Expiry/Retest Workflow.