DBA Data[Home] [Help]

APPS.WMS_ATF_RUNTIME_PUB_APIS dependencies on MTL_ONHAND_QUANTITIES_DETAIL

Line 4141: FROM mtl_onhand_quantities_detail

4137: AND mmtt.move_order_line_id = mol.line_id;
4138:
4139: CURSOR c_quantity_details IS
4140: SELECT SUM(primary_transaction_quantity) quantity,lpn_id,inventory_item_id,lot_number,revision
4141: FROM mtl_onhand_quantities_detail
4142: WHERE lpn_id = p_lpn_id
4143: --3631633
4144: --Force to use the N5 index
4145: AND subinventory_code = l_subinventory_code