APPS.GMD_STABILITY_STUDIES_GRP dependencies on MTL_ONHAND_QUANTITIES

Line 294: FROM mtl_onhand_quantities

290: WHERE item_id = p_item_id
291: AND lot_id = cr_material_sources_lot_rec.lot_id ; */
292:
293: SELECT nvl(sum(transaction_quantity),0) INTO l_onhand_qty --INVOCNV
294: FROM mtl_onhand_quantities
295: WHERE inventory_item_id = l_inventory_item_id
296: AND organization_id = cr_material_sources_lot_rec.source_organization_id
297: AND lot_number = cr_material_sources_lot_rec.lot_number;
298: