DBA Data[Home] [Help]

APPS.INV_RESERVATION_AVAIL_PVT dependencies on MTL_LOT_UOM_CLASS_CONVERSIONS

Line 820: FROM mtl_lot_uom_class_conversions

816: l_qty_available_to_reserve2 number;
817:
818: CURSOR check_if_lot_conv_exists(p_lot_number varchar2, p_inventory_item_id number, p_organization_id number) IS
819: SELECT count(*)
820: FROM mtl_lot_uom_class_conversions
821: WHERE lot_number = p_lot_number
822: AND inventory_item_id = p_inventory_item_id
823: AND organization_id = p_organization_id
824: AND (disable_date IS NULL or disable_date > sysdate);