Search Results primary_qty

Overview

GMI_WSH_PICK_SLIP_V is an APPS-owned database view that belongs to the GMI (Process Manufacturing Inventory) product family within Oracle E-Business Suite 12.1.1 and 12.2.2. It is the query foundation for the OPM Pick Slip report, published as GMIRDPIK.rdf. The view consolidates pending move-order transaction data into a single pick-slip-oriented result set, joining material transaction lines, lot master information, item master details, and Oracle Inventory (MTL) system item records.

Functionally, the view exposes the data required to print a pick slip: the item to be picked, its lot and sublot, the source and destination subinventories and locators, quantities in both primary and secondary units of measure, and the associated move order header and line identifiers. This makes the view a reporting artifact rather than a transaction-processing object; it is queried, not updated.

Because the view is defined with a UNION ALL of two structurally identical SELECT blocks, it returns a combined data set covering both lot-controlled and non-lot-controlled item scenarios. That design choice reflects the OPM requirement to handle lot and non-lot inventory uniformly in a single report.

Underlying Base Objects

The view is defined over seven documented base objects, all referenced through synonyms in the APPS schema:

• IC_TRAN_PND — the pending transaction table (aliased ITP), which supplies the core pick-slip rows: quantities, UOMs, lot references, pick slip number, QC grade, transaction date, and the transaction line identifier.
• IC_TXN_REQUEST_HEADERS (MOH) — the move order header, providing REQUEST_NUMBER.
• IC_TXN_REQUEST_LINES (MOL) — the move order line, providing source and destination subinventory codes and locators, plus ORGANIZATION_ID, INVENTORY_ITEM_ID, and LINE_ID.
• IC_LOTS_MST (LOT) — lot master, supplying LOT_NO and SUBLOT_NO.
• IC_ITEM_MST (ITM) — OPM item master, supplying ITEM_NO, ITEM_ID, and the LOT_CTL flag.
• IC_ITEM_MST_B — the base table behind the IC_ITEM_MST synonym.
• MTL_SYSTEM_ITEMS (MTI) — inventory item definition, supplying INVENTORY_ITEM_ID keyed by ORGANIZATION_ID.

The joins tie the move order header and line together, link each transaction to its lot by LOT_ID and ITEM_ID, and resolve the OPM item to the MTL system item via ITM.ITEM_NO = MTI.SEGMENT1 combined with a matching organization and inventory item.

Key Columns

• FROM_SUBINVENTORY / TO_SUBINVENTORY — source and destination subinventory codes taken from the move order line. The user’s search term “to_subinventory” maps directly to MOL.TO_SUBINVENTORY_CODE, the destination subinventory to which material is being picked.
• FROM_LOCATOR_ID / TO_LOCATOR_ID — corresponding locator identifiers for source and destination.
• ITEM_NO, ITEM_ID, INVENTORY_ITEM_ID — OPM and MTL item identifiers.
• LOT_ID, LOT_NO, SUBLOT_NO — lot and sublot attributes.
• LOCATION — the transaction location from the pending transaction record.
• PRIMARY_QTY / SECONDARY_QTY — TRANS_QTY and TRANS_QTY2 multiplied by -1, presenting quantities in the pick-slip orientation.
• TRANS_UM1 / TRANS_UM2 — primary and secondary units of measure.
• PICK_SLIP_NUMBER — the pick slip grouping key.
• QC_GRADE, DETAILING_DATE, MO_NUMBER, MOVE_ORDER_LINE_ID, TRANSACTION_ID, LINE_STATUS — quality grade, transaction date, move order number, line and transaction identifiers, and a constant LINE_STATUS value of ‘UNPICKED’.

Common Use Cases and Queries

The primary use case is reproducing or extending the OPM Pick Slip report. A typical query filters by pick slip number to list all lines to be picked and their destination subinventories.

• Retrieve pick slip contents: SELECT PICK_SLIP_NUMBER, ITEM_NO, LOT_NO, FROM_SUBINVENTORY, TO_SUBINVENTORY, PRIMARY_QTY, TRANS_UM1 FROM APPS.GMI_WSH_PICK_SLIP_V WHERE PICK_SLIP_NUMBER = :p_pick_slip ORDER BY PICK_SLIP_NUMBER, ITEM_NO;
• Filter by destination subinventory (the searched term): SELECT MO_NUMBER, ITEM_NO, LOT_NO, PRIMARY_QTY FROM APPS.GMI_WSH_PICK_SLIP_V WHERE TO_SUBINVENTORY = :p_to_subinventory;
• List unpicked move order lines for a manufacturing order via MO_NUMBER for operational review.
• Export pick-slip data to downstream warehouse systems by selecting transaction and move order line identifiers.
• Reconcile pick quantities in primary and secondary UOM by comparing PRIMARY_QTY and SECONDARY_QTY per line.

Because the view only surfaces incomplete, non-staged, non-deleted pending transactions for OMSO document type, results reflect outstanding picking work rather than historical transactions.