Search Results get_status_items_lov
Overview
INV_UI_ITEM_LOVS is an Oracle EBS Inventory (INV) PL/SQL package in the APPS schema that supplies list-of-values (LOV) query logic for item-related fields throughout the Inventory user interface. Rather than embedding LOV SQL directly in individual Oracle Forms or concurrent programs, the Inventory application centralizes the retrieval of item, revision, lot, serial, UOM, and container data within this package. The result is a consistent, maintainable source of valid item values that respects organization-level item validation, transaction enablement, and status control rules.
The package is classified as VALID and is documented with 43 procedures/functions. It serves as a shared dependency for several other Inventory and Warehouse Management packages, and it is typically invoked from form-level LOV triggers and from other APIs that need to present or validate item selections.
Key Procedures and Functions
The documented procedures cover several functional areas of the Inventory UI:
- General item LOVs: GET_ITEM_LOV and GET_ITEM_LOV_SUB_LOC_MOQD provide the standard item selection list, with the latter supporting subinventory and locator context (MOQD).
- Transaction-enabled items: GET_TRANSACTABLE_ITEMS returns items valid for inventory transactions.
- Revision LOVs: GET_REVISION_LOV and GET_INV_TXN_REVISION_LOV populate revision selections for general and inventory transaction use.
- Unit of Measure LOVs: GET_UOM_LOV, GET_UOM_LOV_RCV, and GET_UOM_LOV_PICK provide UOM lists for general, receiving, and picking contexts respectively.
- Lot and serial LOVs: GET_LOT_ITEMS_LOV and GET_LOT_ITEM_DETAILS support lot-controlled item selection and detail retrieval.
- Status items: GET_STATUS_ITEMS_LOV returns items filtered by material status.
- Shipping and container: GET_SHIP_ITEMS_LOV and GET_CONTAINER_ITEM_LOV serve shipping and container item selection.
- Physical inventory: GET_PHYINV_ITEM_LOV, GET_PHYINV_REV_LOV, and GET_PHYINV_UOM_LOV support physical inventory tag entry.
- Cycle counting: GET_CYC_ITEM_LOV, GET_CYC_REV_LOV, and GET_CYC_UOM_LOV support cycle count entry.
- Inspection: GET_INSPECT_ITEM_LOV supports receiving inspection item selection.
All procedures populate a record group or return a query result set for the calling UI element; parameter lists are not reproduced here.
Tables Accessed
The package reads from core Inventory tables via APPS synonyms, including MTL_SYSTEM_ITEMS and MTL_SYSTEM_ITEMS_B for item master definitions, MTL_ITEM_REVISIONS for revision data, MTL_UNITS_OF_MEASURE for UOM values, and MTL_LOT_NUMBERS and MTL_SERIAL_NUMBERS for lot and serial control. On-hand and transaction context is derived from MTL_ONHAND_QUANTITIES_DETAIL and MTL_TXN_REQUEST_LINES. Physical inventory LOVs use MTL_PHYSICAL_INVENTORY_TAGS and MTL_PHYSICAL_ADJUSTMENTS, while cycle count LOVs use MTL_CYCLE_COUNT_HEADERS, MTL_CYCLE_COUNT_ITEMS, and MTL_CYCLE_COUNT_ENTRIES. Status-based selection relies on MTL_STATUS_TRANSACTION_CONTROL, and cross-reference data comes from MTL_CROSS_REFERENCES. The package predominantly performs read-only queries to populate LOVs.
Usage Notes
INV_UI_ITEM_LOVS is invoked primarily from Oracle Forms in the Inventory module, where LOV triggers call the appropriate procedure to return a query string for a record group. It is also referenced by other server-side packages, including INV_CONVERT, INV_RCV_COMMON_APIS, INV_UI_RCV_LOVS, WMS_CATCH_WEIGHT_PVT, and WMS_PICKING_PKG, indicating reuse across receiving and warehouse management flows. Custom code should call these procedures rather than querying MTL_SYSTEM_ITEMS directly, ensuring that organization-level item validation, transaction enablement, and status rules remain consistent with standard EBS behavior. Because the package depends on SYS.STANDARD and is referenced by multiple INV and WMS packages, its interface should be treated as a stable shared contract.