DBA Data[Home] [Help]

APPS.WMS_ATF_RUNTIME_PUB_APIS dependencies on MTL_ONHAND_QUANTITIES_DETAIL

Line 4101: FROM mtl_onhand_quantities_detail

4097: AND mmtt.move_order_line_id = mol.line_id;
4098:
4099: CURSOR c_quantity_details IS
4100: SELECT SUM(primary_transaction_quantity) quantity,lpn_id,inventory_item_id,lot_number,revision
4101: FROM mtl_onhand_quantities_detail
4102: WHERE lpn_id = p_lpn_id
4103: --3631633
4104: --Force to use the N5 index
4105: AND subinventory_code = l_subinventory_code