APPS.INV_CONSIGNED_VALIDATIONS dependencies on MTL_ONHAND_NET

Line 2279: FROM mtl_onhand_net mon, mtl_lot_numbers mln

2275: SELECT SUM(mon.primary_transaction_quantity)
2276: , SUM( NVL(mon.secondary_transaction_quantity, 0))
2277: INTO l_moq_qty
2278: , l_moq_sqty
2279: FROM mtl_onhand_net mon, mtl_lot_numbers mln
2280: WHERE mon.organization_id = p_org_id
2281: AND mon.inventory_item_id = p_item_id
2282: AND mon.organization_id = nvl(mon.planning_organization_id, mon.organization_id)
2283: AND mon.lot_number = mln.lot_number(+)