DBA Data[Home] [Help]

APPS.INV_RESERVATION_PVT dependencies on MTL_LOT_UOM_CLASS_CONVERSIONS

Line 214: FROM mtl_lot_uom_class_conversions

210: l_lot_secondary_rsv_qty NUMBER := 0;-- MUOM fulfillment Project
211:
212: CURSOR check_if_lot_conv_exists(p_lot_number varchar2, p_inventory_item_id number, p_organization_id number) IS
213: SELECT count(*)
214: FROM mtl_lot_uom_class_conversions
215: WHERE lot_number = p_rsv_rec.lot_number
216: AND inventory_item_id = p_rsv_rec.inventory_item_id
217: AND organization_id = p_rsv_rec.organization_id
218: AND (disable_date IS NULL or disable_date > sysdate);